Difference between revisions of "Collecting and Saving Data to MultiCharts Database"

From MultiCharts
Jump to navigation Jump to search
Line 3: Line 3:
  
 
==Saving Historical Data==
 
==Saving Historical Data==
Most of supported data vendors provide historical data that is always stored locally after data is received. All types of data is stored:  
+
Most of supported data vendors provide historical data that is always stored locally after data is received. All types of data are stored:  
 
* Ticks, minutes, days (see [[Tick, Minute and Daily Data]]);
 
* Ticks, minutes, days (see [[Tick, Minute and Daily Data]]);
 
* Asks, bids, trades.
 
* Asks, bids, trades.
Line 21: Line 21:
 
:* Minute and daily are recorded or not recorded for each data vendor individually:
 
:* Minute and daily are recorded or not recorded for each data vendor individually:
 
:: <div style="background-color: #E3FBE5;">'''Note''': If a data source provides only real-time data (no historical backfill) it is always recorded in MultiCharts database. Only the data vendors, supporting both history and real-time feed are listed in the following table.</div>
 
:: <div style="background-color: #E3FBE5;">'''Note''': If a data source provides only real-time data (no historical backfill) it is always recorded in MultiCharts database. Only the data vendors, supporting both history and real-time feed are listed in the following table.</div>
 +
 
{| class="wikitable"
 
{| class="wikitable"
 
|<p align="center">'''Data Vendor'''</p>
 
|<p align="center">'''Data Vendor'''</p>
Line 45: Line 46:
 
|<p align="center"><b><font color="red">X</font></b></p>
 
|<p align="center"><b><font color="red">X</font></b></p>
 
|<p align="center"><b><font color="red">X</font></b></p>
 
|<p align="center"><b><font color="red">X</font></b></p>
|
+
|<p align="center"><b><font color="red">X</font></b></p>
 
|-
 
|-
 
|<p align="center">'''Interactive Brokers'''</p>
 
|<p align="center">'''Interactive Brokers'''</p>
Line 57: Line 58:
 
|<p align="center"><b><font color="red">X</font></b></p>
 
|<p align="center"><b><font color="red">X</font></b></p>
 
|<p align="center"><b><font color="red">X</font></b></p>
 
|<p align="center"><b><font color="red">X</font></b></p>
|
+
|<p align="center"><b><font color="red">X</font></b></p>
 
|-
 
|-
 
|<p align="center">'''LMAX'''</p>
 
|<p align="center">'''LMAX'''</p>
Line 69: Line 70:
 
|<p align="center"><b><font color="red">X</font></b></p>
 
|<p align="center"><b><font color="red">X</font></b></p>
 
|<p align="center"><b><font color="red">X</font></b></p>
 
|<p align="center"><b><font color="red">X</font></b></p>
|
+
|<p align="center"><b><font color="red">X</font></b></p>
 
|-
 
|-
 
|<p align="center">'''Open E Cry'''</p>
 
|<p align="center">'''Open E Cry'''</p>
Line 75: Line 76:
 
|<p align="center"><b><font color="green">V</font><font color="red">*!</font></b></p>
 
|<p align="center"><b><font color="green">V</font><font color="red">*!</font></b></p>
 
|<p align="center"><b><font color="red">X</font></b></p>
 
|<p align="center"><b><font color="red">X</font></b></p>
|
+
|<p align="center"><b><font color="red">X</font></b></p>
 
|-
 
|-
 
|<p align="center">'''PFG BEST'''</p>
 
|<p align="center">'''PFG BEST'''</p>
Line 81: Line 82:
 
|<p align="center"><b><font color="red">X</font></b></p>
 
|<p align="center"><b><font color="red">X</font></b></p>
 
|<p align="center"><b><font color="red">X</font></b></p>
 
|<p align="center"><b><font color="red">X</font></b></p>
|
+
|<p align="center"><b><font color="red">X</font></b></p>
 
|-
 
|-
 
|<p align="center">'''Quik'''</p>
 
|<p align="center">'''Quik'''</p>
Line 87: Line 88:
 
|<p align="center"><b><font color="red">X</font></b></p>
 
|<p align="center"><b><font color="red">X</font></b></p>
 
|<p align="center"><b><font color="red">X</font></b></p>
 
|<p align="center"><b><font color="red">X</font></b></p>
|
+
|<p align="center"><b><font color="red">X</font></b></p>
 
|-
 
|-
 
|<p align="center">'''TradeStation'''</p>
 
|<p align="center">'''TradeStation'''</p>
Line 99: Line 100:
 
|<p align="center"><b><font color="red">X</font></b></p>
 
|<p align="center"><b><font color="red">X</font></b></p>
 
|<p align="center"><b><font color="red">X</font></b></p>  
 
|<p align="center"><b><font color="red">X</font></b></p>  
|
+
|<p align="center"><b><font color="red">X</font></b></p>
 
|}
 
|}
 +
 +
<b><font color="green">V</font><font color="red">*!</font></b> - Open E Cry data source provides real-time minute data that is stored in database. It is important to know that if charts only with minute data from Open E Cry are plotted in MultiCharts, tick data is not stored locally.
 +
 +
<div style="background-color: #E3FBE5;">'''Note''': Take into account that Download Missing Historical Data checkbox affects the way MultiCharts treats received real-time data for Chart and Market Scanner windows. </div>
 +
 +
 +
[[Category:FAQ]]

Revision as of 17:12, 21 May 2012

There is plenty of ways to recieve data in MultiCharts, however each way treats received data individually. The only common thing is that no data can be received (except for ASCII Import, see) if Offline mode of MultiCharts is selected.

Note: Data that was recieved in MultiCharts is stored in cache during MC working session. Once the software (tsserver.exe, see MultiCharts Processes) is shut down, the data is stored in MultiCharts database.

Saving Historical Data

Most of supported data vendors provide historical data that is always stored locally after data is received. All types of data are stored:

Exceptions: Historical data from the following data sources is not stored locally:
* ASCII Mapping
* CSI
* GlobalServer
* MetaStock
* Historical data from TradeStation can be stored locally if the box is checked in the data source settings.

When data is imported from ASCII file, it is always stored in MultiCharts database.

Saving Collected in Real-Time Data

Saving RT Data Collected in QuoteManager

All types of data received from data vendors if "Collect RT Data w/o Plotting" is on in QuoteManager (see Online Mode Data Collection) is stored in database.

Saving RT Data Collected in MultiCharts

  • RT data plotted in DOM window is not saved.
  • RT data plotted in Market Scanner window is saved the same way as data plotted in Chart window.
  • RT data plotted in Chart window is stored or is not stored, depending on its type:
  • Ticks are always stored.
  • Minute and daily are recorded or not recorded for each data vendor individually:
Note: If a data source provides only real-time data (no historical backfill) it is always recorded in MultiCharts database. Only the data vendors, supporting both history and real-time feed are listed in the following table.

Data Vendor

RT minutes
DL missing historical data is not checked

RT minutes
DL missing historical data is checked

RT daily
DL missing historical data is not checked

RT daily
DL missing historical data is checked

Barchart

CGQ

eSignal

V

X

X

X

Interactive Brokers

V

X

X

IQFeed

V

X

X

X

LMAX

V

X

MB Trading

V

X

X

X

Open E Cry

V

V*!

X

X

PFG BEST

V

X

X

X

Quik

V

X

X

X

TradeStation

Zen-Fire

V

X

X

X

V*! - Open E Cry data source provides real-time minute data that is stored in database. It is important to know that if charts only with minute data from Open E Cry are plotted in MultiCharts, tick data is not stored locally.

Note: Take into account that Download Missing Historical Data checkbox affects the way MultiCharts treats received real-time data for Chart and Market Scanner windows.