When I have a chart open, with a live connection, the chart accumulates bars as time progresses.
Where does MultiCharts store this data, and in which format?
Can I access the data externally on the fly by reading a MultiCharts database file e.g. every second?
Directly access data accumulated by MultiCharts? [SOLVED]
- Svetlana MultiCharts
- Posts: 645
- Joined: 19 Oct 2017
- Has thanked: 3 times
- Been thanked: 163 times
Re: Directly access data accumulated by MultiCharts? [SOLVED]
KJW,
“Where does MultiCharts store this data, and in which format?”
Once the data is downloaded from the data feed server and plotted on the chart - it is stored in the cache.
In 64bit MultiCharts by default the cache is in PC's RAM. You can see the process TsServer.exe in the processes list for that.
When you close MultiCharts, QuoteManager and Portfolio Trader - the cached data is compressed and saved to the local database. In MultiCharts 12 we have also added an option to “Flush Cached Data to Database” manually (MultiCharts->File tab, QuoteManager->Edit tab).
For more information please see this page:
http://www.multicharts.com/trading-soft ... s_Database
“Can I access the data externally on the fly by reading a MultiCharts database file e.g. every second?”
One cannot access the database directly.
You can code a script to export data from a data series where the script is applied into a file in real-time.
Also, you can use RTD server functionality to export data to Excel in real-time:
https://www.multicharts.com/trading-sof ... Server)%3F
“Where does MultiCharts store this data, and in which format?”
Once the data is downloaded from the data feed server and plotted on the chart - it is stored in the cache.
In 64bit MultiCharts by default the cache is in PC's RAM. You can see the process TsServer.exe in the processes list for that.
When you close MultiCharts, QuoteManager and Portfolio Trader - the cached data is compressed and saved to the local database. In MultiCharts 12 we have also added an option to “Flush Cached Data to Database” manually (MultiCharts->File tab, QuoteManager->Edit tab).
For more information please see this page:
http://www.multicharts.com/trading-soft ... s_Database
“Can I access the data externally on the fly by reading a MultiCharts database file e.g. every second?”
One cannot access the database directly.
You can code a script to export data from a data series where the script is applied into a file in real-time.
Also, you can use RTD server functionality to export data to Excel in real-time:
https://www.multicharts.com/trading-sof ... Server)%3F