Converting Data into Excel

[Vito]

Hi All,
I subscribe to Norgate data and I am having trouble getting the SPI data into a format that I can work with in Excel. If any one can please help it would be greatly appreciated.


Merry Xmas
Vito

 

[Timmy]

Hi All,
I subscribe to Norgate data and I am having trouble getting the SPI data into a format that I can work with in Excel. If any one can please help it would be greatly appreciated.


Merry Xmas
Vito

Have you asked Richard at Norgate? Email him - he will bend over backwards to help you if he can.

 

[Timmy]

You can use The Downloader in Metastock to convert data from Metastock format to Excel .

 

[Trader Paul]

Hi All,
I subscribe to Norgate data and I am having trouble getting the SPI data into a format that I can work with in Excel. If any one can please help it would be greatly appreciated.

Merry Xmas
Vito

Hi Vito,

With many thanks to a very kind online buddy, the attached file explains
how to convert data files in text format, from within Excel ... !~!

Merry Christmas

paul



=====

 

[Vito]

Thankyou all for all of your help

Thanks
Vito

 

[Richard Dale]

Hi Vito,

DataTools (the futures updating program) comes with an in-built ASCII CSV translation mechanism. CSV files can be opened directly in Excel.

Click File -> Translate Database to Text Format, select which contracts you want to convert. By default they are stored in C:\Text - just navigate there with Windows Explorer then double click on the CSV file to open it in Excel.

Let me know if you need any further help.

Cheers,
Richard.