PLEASE HELP - Using EODData - Converting extended intraday format to metastock data

[Satnam]

Hi,

Can someone please help. I am trying to convert extended intraday data
that I have downloaded from EODData.com. I cannot get my software that
reads metastock data to recognise the date time stamps.


EODDate format:
A,201105020930,50.22,50.49,50.18,50.49,45421

Is there any way I could get asc2ms to recognise the format above and
convert many files in a single command.

The date and time are listed in a single column.

Thanks, Satnam

[Samri]

Hi Satnam,

Somewhere on the EODdata website are utilities that either (1) convert
text data to Metastock format, or (2) download the data directly
already converted to Metastock. Your first recourse would be to try
those.

Otherwise, I have a bunch of scripts, some as DOS batch files (.bat)
which run in the Windows console, and some written in Python (a free
programming language) which I use to convert text data from a bunch of
sources. In your case, a script would take the text file you download
from EOD, then break the 201105020930 field into a Date and Time, then
add the Metastock header (<ticker>,<date>,<time>, <period>,
<open>,<high>,<low>,<close>,<vol>), and finally call Mansoor's
utilities for the conversion.

I can adjust one of my existing scripts for you if you want, but I
would need some sample data files to test them on. Try finding the
utilities on EODdata.com. If you don't have any success with them,
upload some sample data and I'll be glad to help.

Regards,
Samri

[Satnam]

Thanks for your reply Samri.
I have written a java programme to convert the files to the target
format. At the same time EODData.com my data provider has changed
their format to split th date and time stamp into separate columns.

So now my data provider is sending data in the following format:

<ticker>,<date>,<open>,<high>,<low>,<close>,<vol>
A,20101201,0905,35.45,35.45,35.45,35.45,300
A,20101201,0910,35.31,35.31,35.31,35.31,100
A,20101201,0925,35.65,35.65,35.65,35.65,604
A,20101201,0930,35.65,35.8,35.65,35.7,70995
A,20101201,0935,35.71,35.79,35.69,35.7,90990
A,20101201,0940,35.69,35.71,35.65,35.69,62508
A,20101201,0945,35.69,35.83,35.68,35.7,67183
A,20101201,0950,35.7,35.78,35.62,35.78,286136

The data above is intraday data at 5 min intervals. However, I still
cannot get this to successfully import into metastock database using
asc2ms util.

I am using the following command: asc2ms -f myfile.txt -r r -o
masterdir

Do I need to make further changes to the data format above?

Please still send me your scripts and conversion utils..It will be
helpful to see how you format the data..
Thanks, Satnam.


On Aug 31, 7:49 am, Samri

[Satnam Sandhu]

Thanks for your reply Samri.

I have written a java programme to convert the files to the target format. At the same time EODData.com my data provider has changed their format to split th date and time stamp into separate columns.

So now my data provider is now sending data in the following format:

<ticker>,<date>,<open>,<high>,<low>,<close>,<vol>
A,20101201,0905,35.45,35.45,35.45,35.45,300
A,20101201,0910,35.31,35.31,35.31,35.31,100
A,20101201,0925,35.65,35.65,35.65,35.65,604
A,20101201,0930,35.65,35.8,35.65,35.7,70995
A,20101201,0935,35.71,35.79,35.69,35.7,90990
A,20101201,0940,35.69,35.71,35.65,35.69,62508
A,20101201,0945,35.69,35.83,35.68,35.7,67183
A,20101201,0950,35.7,35.78,35.62,35.78,286136

The data above is intraday data at 5 min intervals. However, I still cannot get this to successfully import into metastock database using asc2ms util. 

I am using the following command: asc2ms -f myfile.txt -r r -o masterdir

Do I need to make further changes to the data format above?

Please still send me your scripts and conversion utils..It will be helpful to see how you format the data..

Attached is an example of a file that I'm trying to convert. Also, do you know if the asc2ms util can convert multiple files using a single command?

Thanks, Satnam.

--
To unsubscribe from this group, send email to metastockcmdline...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/metastockcmdlineutils

[Vikas Parikh]

Btw, mail me your cell number voice communication may better help or add my GTalk vikas...@gmail.com we can do voice chat

[Vikas Parikh]

I shall sent one C# code to parse Intraday google data. Then using Java or any language you can write Data to prescribed format to ASCII Files

Then you can import ascii files to metastock

But I am not sure your version of asc2ms will work for intraday data

As It did not worked for me.

Lets see

[Satnam Sandhu]

Hello Vikas,

Thanks for your kind help. I've managed to get intraday data parsed
using as2ms. It works nicely..

Let me know if you need assistance.

Thanks, Satnam