Skip to content

Opening book details…

Can I read Power Query for JSON Option Data on EtoBox?

Power Query for JSON Option Data by sandesh is a document available to read on EtoBox.

What is Power Query for JSON Option Data about?

The document contains Power Query M code to extract option chain data from the NSE India website for the Nifty and Bank Nifty indices. It makes HTTP requests to the API endpoints, specifying headers and cookies. It then parses the JSON response, extracts the records, and expands the Column1 field to separate out the strike price, expiry date, and call and put option data into distinct columns.

Author
sandesh
Language
EN