NexusFi: Find Your Edge


Home Menu

 





Realtime OHLC feed into Excel


Discussion in Platforms and Indicators

Updated
    1. trending_up 4,422 views
    2. thumb_up 0 thanks given
    3. group 2 followers
    1. forum 1 posts
    2. attach_file 0 attachments




 
Search this Thread
  #1 (permalink)
TradTrader
Bern Switzerland
 
Posts: 1 since Apr 2020
Thanks Given: 0
Thanks Received: 0

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


Reply With Quote

Can you help answer these questions
from other members on NexusFi?
No book, only a stair: journaling fills where price move …
Cryptocurrency
Netherlands & Germany Surge as World Cup Field Narro …
Prediction Markets & Event Contracts
Warsh Drops Easing Bias, December Hike Now Above 50% -- …
Prediction Markets & Event Contracts
Trump Media to sell instant access to market-moving soci …
Traders Hideout
Without Pulisic, USA 61.5% Live vs. Australia -- France …
Prediction Markets & Event Contracts
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Want your NinjaTrader indicator created, free?
5 thanks
Franks Trading Journey
1 thanks
Denied 20K payouts: Alpha Futures
1 thanks
FootPrintV2 Chart for NT8
1 thanks
BERN ALGOS algo trading journal
1 thanks
  #2 (permalink)
gariki
Vancouver, Canada
 
Posts: 3 since Feb 2019
Thanks Given: 0
Thanks Received: 0

Not sure but try if the solution available here helps:


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.


Reply With Quote




Last Updated on April 25, 2020


© 2026 NexusFi®, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Downloads - Top
no new posts