A thread on getting intraday (any timeframe) data to excel without any coding. Limited to only last 60 days. Fetches from zerodha chart.

👇

1. Open the chart on zerodha web in chrome. Right click and select 'Inspect'. Click 'Network' as shown in this pic.
2. Right click on the last entry on the table you see and click 'copy as cURL (bash)'
3. Go to website https://t.co/f8rhwoGLUc and paste on the left box and click 'Run'
4. The output below candles written on right of box is the ohlc, volume and oi data. Copy and paste to excel.
5. You can change the dates on the first line of code pasted on left box and run again to get the data.

More from Trading

TradingView isn't just charts

It's much more powerful than you think

9 things TradingView can do, you'll wish you knew yesterday: 🧵

Collaborated with @niki_poojary

1/ Free Multi Timeframe Analysis

Step 1. Download Vivaldi Browser

Step 2. Login to trading view

Step 3. Open bank nifty chart in 4 separate windows

Step 4. Click on the first tab and shift + click by mouse on the last tab.

Step 5. Select "Tile all 4 tabs"


What happens is you get 4 charts joint on one screen.

Refer to the attached picture.

The best part about this is this is absolutely free to do.

Also, do note:

I do not have the paid version of trading view.


2/ Free Multiple Watchlists

Go through this informative thread where @sarosijghosh teaches you how to create multiple free watchlists in the free


3/ Free Segregation into different headers/sectors

You can create multiple sections sector-wise for free.

1. Long tap on any index/stock and click on "Add section above."
2. Secgregate the stocks/indices based on where they belong.

Kinda like how I did in the picture below.

You May Also Like