File Link
I would like to thank you all for your assistance to the excel community beforehand.
I have real-time stock information in Excel on column K for each ticker. I want to capture the price information at regular intervals horizontally for each day for example (every 1,5,10 or 15 minutes) in columns L for 9:30, column G for 9:45, N for 10:00 AM etc. (this is an example of capture the price that constantly changed for each ticker in column K every 15 minutes).
The link to the file is here File Link you will need the Microsoft stock plugin for this to work but it may work for you automatically if you have the latest version of excel.
Can someone please assist with this task ?
I would like to thank you all for your assistance to the excel community beforehand.
I have real-time stock information in Excel on column K for each ticker. I want to capture the price information at regular intervals horizontally for each day for example (every 1,5,10 or 15 minutes) in columns L for 9:30, column G for 9:45, N for 10:00 AM etc. (this is an example of capture the price that constantly changed for each ticker in column K every 15 minutes).
The link to the file is here File Link you will need the Microsoft stock plugin for this to work but it may work for you automatically if you have the latest version of excel.
Can someone please assist with this task ?
