mtheriault2000
Well-known Member
- Joined
- Oct 23, 2008
- Messages
- 826
What is the more reliable way to get live data in a cell?
Using a charting software, MultiCharts, I want to send prices info. My goal is to connect that live info to an Excel cell. Updated twice per second is sufficient.
At the moment, I have succeeded to sent a string of data from Multicharts directly to a designated cell. It work well until I'm working with Excel. Then, once in a while the link is stopped.
I did try to use global variable and use Excel to read from them. Problem, I was using all the resource only for that loop and Excel crashed.
I read that DDE solution is out of date and unreliable.
Witch way is more appropriate and stable for Excel and my charting software.
This is a bit of a philosophical question. A bigger but interesting project than i taught
Martin
Using a charting software, MultiCharts, I want to send prices info. My goal is to connect that live info to an Excel cell. Updated twice per second is sufficient.
At the moment, I have succeeded to sent a string of data from Multicharts directly to a designated cell. It work well until I'm working with Excel. Then, once in a while the link is stopped.
I did try to use global variable and use Excel to read from them. Problem, I was using all the resource only for that loop and Excel crashed.
I read that DDE solution is out of date and unreliable.
Witch way is more appropriate and stable for Excel and my charting software.
This is a bit of a philosophical question. A bigger but interesting project than i taught
Martin
