Export data

Questions about MultiCharts and user contributed studies.
miltonc4
Posts: 150
Joined: 14 Apr 2006
Has thanked: 1 time
Been thanked: 3 times

Export data

Postby miltonc4 » 18 Feb 2009

Hi All
Is there an Els that can be loaded into a chart (Point Chart) that exports data Real Time to a file in following format:-

DATE,TIME,OPEN,HIGH,LOW,CLOSE,VOL
time format: HHMM
File Ext: *.txt


Thanks
Milton

User avatar
TJ
Posts: 7151
Joined: 29 Aug 2006
Location: Global Citizen
Has thanked: 988 times
Been thanked: 2041 times

Postby TJ » 19 Feb 2009

someone wrote a routine for doing this.
check here:
http://www.tssupport.com/forum/viewforum.php?f=5

miltonc4
Posts: 150
Joined: 14 Apr 2006
Has thanked: 1 time
Been thanked: 3 times

Postby miltonc4 » 23 Feb 2009

Thanks TJ
Regards
Milton

htengler
Posts: 3
Joined: 29 Apr 2008
Has thanked: 1 time
Been thanked: 1 time

Export data

Postby htengler » 26 Feb 2009

Hi,
where can I find this indicator and what is its name?
Thanks,
htengler

brendanh
Posts: 158
Joined: 07 Apr 2007
Has thanked: 1 time

Re: Export data

Postby brendanh » 13 May 2013

Hi,

I'm looking for a way to export many symbols' OHLC data to csv (Excel) format. The above link in this topic is to the home page of the User Contributed Studies forum rather than to the study itself. Rather than wade through all 22 pages of topics, can anyone post a link to the indicator referred to?

Otherwise if anyone knows a way to export data en mass, I'd appreciate if they could post. I know you can export to QMD format in QuoteManager (File, Export all Symbols), but:

1. This doesn't actually download the data, just exports what's already in QM
2. It exports to QMD format which there is no way to convert to CSV.

Many thanks.

User avatar
TJ
Posts: 7151
Joined: 29 Aug 2006
Location: Global Citizen
Has thanked: 988 times
Been thanked: 2041 times

Re: Export data

Postby TJ » 13 May 2013

brendanh wrote:Hi,

I'm looking for a way to export many symbols' OHLC data to csv (Excel) format. The above link in this topic is to the home page of the User Contributed Studies forum rather than to the study itself. Rather than wade through all 22 pages of topics, can anyone post a link to the indicator referred to?

Otherwise if anyone knows a way to export data en mass, I'd appreciate if they could post. I know you can export to QMD format in QuoteManager (File, Export all Symbols), but:

1. This doesn't actually download the data, just exports what's already in QM
2. It exports to QMD format which there is no way to convert to CSV.

Many thanks.

Look up the keyword PRINT.
It writes whatever you want to an ascii file.

brendanh
Posts: 158
Joined: 07 Apr 2007
Has thanked: 1 time

Re: Export data

Postby brendanh » 13 May 2013

Thanks TJ, I'll look into writing my own script unless anyone can post some code. Wanted to save time as I can't believe no-one has done this before. Ideally I'd like the following functionality:
- writes the symbol name as filename,
- the exchange as folder,
- GMT time zone,
- Tick, minute or daily

What would be ultra-cool would be the ability to cycle say 100 symbols at a time in a screener until all the symbols in the data feed have been downloaded.

If any MC devs read this, exporting multiple symbols to ASCII\CSV would be a great feature, and often-used I'm sure.


Return to “MultiCharts”