Realtime OHLC feed into Excel

April 18th, 2020, 11:01 AM

Hi,
I am looking for a good Realtime OHLC feed into Excel - and wonder what is available for a Windows User?

I would like to feed for example 1min OHLC prices of stocks for the last 60 minutes - and the update into Excel need to happen automatically by updating a row in Excel without any macro trigger or reading csv etc. The purpose is to use it for charting etc. There is No need to receive the OHLC for the data as ow "now" - but the row in Excel needs to update after the 1min time period.

I know that there are several RTD solutions to feed for example Bid, Ask, Last, Volume etc - and I am looking for a RTD solution for OHLC.

Thank you,
TradTrader

April 25th, 2020, 07:05 PM

Not sure but try if the solution available here helps:

Export data from TOS(volumes, price)

Hello all!

Does anybody ever tried to link data from TOS(volumes, price action) to Excel or some programming language platform for further analyze?

If yes, please help with info how to start in that direction?

Thanx

If not, its a drag but you can try programming in excel using current time and using last prices to calculate/populate your own ohlc values.

Realtime OHLC feed into Excel

Discussion in Platforms and Indicators

Realtime OHLC feed into Excel