How to export trading data to a CSV file
Updated on 2011-12-26 03:37:41
|
QuantShare allows you to export historical end-of-date, intraday, tick and custom databases data to CSV files. CSV stands for comma-separated values. It is a simple file format that stores tabular data (text and numbers) in plain-text form.
Steps:
- Select "Data" then "Edit Databases"
- In "Database" pane, select quotes (EOD data), tick, intraday or custom database
- In "Symbols" panel, select a security by its symbol name
- If there is data for the selected security then the right grid will display the different database columns and the trading data for each trading period. For the EOD database, you will have the following columns: Date, Close, Open, High, Low, Volume and Open Interest.
- Below the grid, click on "Export to CSV"
- Type the file name then click on "Save" to export the data
Example of a CSV file:
02/10/2003 00:00:00;20.72;20.82;20.9;20.58;2410700;0
01/10/2003 00:00:00;20.96;20.87;21.21;20.76;2385800;0
30/09/2003 00:00:00;20.83;21.22;21.22;20.82;1465400;0
29/09/2003 00:00:00;21.35;21.16;21.58;20.92;1407300;0
26/09/2003 00:00:00;21.09;21.39;21.62;21.02;1572500;0
25/09/2003 00:00:00;21.5;21.83;22.44;21.45;2290400;0
24/09/2003 00:00:00;21.74;23.23;23.23;21.74;3432100;0
|
