Hi All,

I'm extracting live data (Index Options)from website and have set the refresh frequency as 5 minutes. So, the data is getting updated every 5 minutes and I've created a clustered column chart to monitor columns OI, Change in OI and Volume for both Calls/Puts section. Now, instead of seeing the data update in the same chart after data refresh, I want a new clustered column chart to be created after every data refresh. So, for the refresh rate of 5 minutes, 72 charts should be created for the market period of 6 hours. This would allow to analyze the Calls/Puts build-up better. Also, for the column LTP (Last Traded Price), instead of column chart, I want to plot a line chart for different strike prices. For instance, I want to see the price updates for strike prices 8000, 8100, 8200, 9000, 9100, 9200 alone(both calls & puts section). I'm not sure how to achieve this. Any help would be very much appreciated.

Thanks.

Note: I've posted this query in other forums as well
https://www.excelforum.com/excel-pro...lp-please.html
https://www.excelguru.ca/forums/show...y-data-refresh
https://www.mrexcel.com/forum/excel-...a-refresh.html

Attached Files

Option Analysis.xlsx (30.8 KB, 10 views)

Thanks for adding the links.
Just be aware that cross posting does not necessarily increase your chances of getting an answer

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Instead or 74 (3 times?) different charts, save data refreshing time into your Main table into additional column. And then design a report sheet(s), where you select (use Data Validation List) refreshing time, and according charts are displayed. Additionally you can design charts to compare with previous and/or next refreshing time.

The best design for this is to have a hidden sheet(s) where source data for charts is calculated accordingly refreshing time selected on report sheet.

When you want to have several report sheets, and you want to select refreshing time for every report separately, then you must calculate separate source table(s) for every report sheet.