Options paper trading in excel |Data fetched from NSE through excel power query.

In this video i have discussed how we can use data from nse for paper trading in excel.

This method works only when you have recent version of the excel like 2019.

Options are not easy to understand but once we understand them we need to practice the strategies before deployment with actual capital.

So Follow the steps shown in video properly to practice the options trading in the excel.

This is not the easy way to do paper trading but once you get the practice of it you can easily create all the strategies very easily.

Data fetching works mainly in market hours only i.e from 9:15 am to 3:30 pm.

#banknifty
#bankniftypapertrading
#bankniftycall
#bankniftyput
#calloption
#putoption
#excel
#exceltrading
#papertrading
#options
#optionstratagies
#optionsdata
#nse
#options
#stocks
#stockmarket
#trading
#investing
#optionstrading #finance
#investment
#daytrader
#invest
#technicalanalysis
#optionstrader
#swingtrader
#business

Thank you for this video. Not everyone is tech savy, therefore it is requested to ....
Please provide a readymade excel sheet for viewers for practising paper trading in various strategies related to oprions.

Can google automated sheets be created for option paper trading

Sir, NK stocks talk channel of Nitish Kumar talks of many strategy like hedge 11, Hege 17, , 1 to ka 4, tufani hedge, Hedge 21 etc .He recommend paper trading for at least 90 days before trying in real market.

There are many apps like Sensibull, opstra which charge for paper trading

I am looking for a google sheets for nse options chains and futures which automatically refreshes LTP last traded price.., , this sheet if possible to develop would save a lot of time and help to try practice paper trading for different strategies.ESP NK Sirs strategies

Can you make one such google sheets where one can take positions in google sheets and the sheets automatically refreshes LTP of each options and the sheets calculate PnL of positions

I hope you could create such sheet

Thank you

Please make it more comprehensive so that realized profits and unrealised profits and loss and history of trades could be stored so that one can do paper trading for longer period like 2 -3 years and review and refine one’s trading skills before risking the real money

It’s only a request if possible

Any way thanks a lot

[second]

Can you make sl system just like original demate

[blackqueenmelodies]

Please tell me can I try this in windows 10 kindly reply 🙏

[sagarsirja]

sir, if you not any problem theen you should upload this file at google drive and share link with us. so we can easily use this excel sheet.

[blackqueenmelodies]

Sir it's not connecting kindly please help