Vijay D Jaria

Full time Trader, Mentor, Algo Software maker, Data analysis Software maker

Course available for 3 months after purchase

Code and Excel is shared 
In this course you will learn how to Fetch all stocks cash live data and all fno stocks and Indices Live option chain data of all expiries from Nse website in excel with help of python and store all option chain data at your desired interval and read all stores data and update in Excel for analysis

Details of stocks cash data
(open , high, low, close, previousClose, change, pChange, yearHigh, yearLow, totalTradedVolume, totalTradedValue	lastUpdateTime, nearWKH, nearWKL, perChange365d, perChange30d, companyName, industry, isin, listingDate)

 
Details of option chain data
(strikePrice, expiryDate, underlying, openInterest, changeinOpenInterest, pchangeinOpenInterest, totalTradedVolume, impliedVolatility, lastPrice, change, pChange, totalBuyQuantity, totalSellQuantity, bidQty, bidprice, askQty, askPrice, underlyingValue, instrumenttype)

Details of Learning in course-
1) Installing python
2) Installing visual basic 
3) Installing libraries
4) Understanding meaning of each line of code.
5) Checking and solving Errors
6) Handling errors and simplifying codes
7) Create function
8) Create pandas data frame 
9) Filter data frame with criteria
10) Get nse fno symbol list automatically
11) How to auto update cookie value
12) How to automatically Update option chain of all symbols in live market
13) how to fetch and record data automatically at your desired interval
14) How to store all data to track it later
15) How to do dynamic setting in excel to track each symbol option chain
16) How to do advance calculation in excel with big data
17) Python code is shared for better Understanding
18) Excel is shared for better Understanding

Function used
Python
1) for loop
2) While true
3) Creating dataframe
4) Filtering dataframe with criteria
5) Fetch data from website
6) creating function
7) storing data in csv files
8) how to use libraries like xlwings , pandas datetime

Excel
1) creating pivot table
2) creating slicer to filter pivot table dynamically
3) Advance sumifs formula to use in big data
4) advance Index match formula

Automatically Update of Nifty total market live data & All symbols option chain data (code shared)

watch video to understand what you will learn in this course

course details

Read all option chain stored data from folder and update in excel

More details of course

3 Month(s)

1 Year

Trade on Level

Maharashtra

Hey! I’m learning with Trade on Level and you can too. Here’s a course you might like: Automatically Update of Nifty total market live data & All symbols option chain data (code shared) by Vijay D Jaria
    https://www.tradeonlevel.com/courses/610513?utm_source=whatsapp&utm_medium=social&utm_campaign=web-course-share

Hey! I’m learning with Trade on Level and you can too. Here’s a course you might like: Automatically Update of Nifty total market live data & All symbols option chain data (code shared) by Vijay D Jaria
    https://www.tradeonlevel.com/courses/610513?utm_source=facebook&utm_medium=social-fb&utm_campaign=web-course-share

Hey! I’m learning with Trade on Level and you can too. Here’s a course you might like: Automatically Update of Nifty total market live data & All symbols option chain data (code shared) by Vijay D Jaria
    https://www.tradeonlevel.com/courses/610513?utm_source=telegram&utm_medium=social&utm_campaign=web-course-share

Hey! I’m learning with Trade on Level and you can too. Here’s a course you might like: Automatically Update of Nifty total market live data & All symbols option chain data (code shared) by Vijay D Jaria
    https://www.tradeonlevel.com/courses/610513?utm_source=linkedin&utm_medium=social-link&utm_campaign=web-course-share

Hey! I’m learning with Trade on Level and you can too. Here’s a course you might like: Automatically Update of Nifty total market live data & All symbols option chain data (code shared) by Vijay D Jaria
    https://www.tradeonlevel.com/courses/610513?utm_source=copy-link&utm_medium=social&utm_campaign=web-course-share

You have Successfully Published Automatically Update of Nifty total market live data &amp; All symbols option chain data (code shared)