Can this format work?

bunster · Apr 17, 2009

A data supplier can provide managed fund data in this format. Here's a sample:

2JLGT,B9.3928LC-0.21278
2JLMCT,B15.8184LU
2JLMF,B10.2777LC-0.0819C
2JLMT,B10.8566LC-0.0866U
2JMCO,B10.1212LC-0.0806Q
2JPRE,B22.404LY
2JPRET,B19.301LF
2JUKBC,B19.8963LC+1.1657O
2JUKBT,B15.9571LC+0.93482

Taking the top line, the format is: 2JLGT, (Ticker) B9.3928 (Bid price) L (currency flag) C-0.21278 (Change)

Sometimes there is an offer price (eg O1.784)instead of, or as well as the bid price.

Looking at this data, is there a way to get it into MetaStock?

Thanks

RichardDale · Apr 18, 2009

MetaStock requires at (least) a symobl, a date and a close value.

You need to convert it into an ASCII format suitable for a utility such as The Downloader to convert it into MetaStock format.

Typically, this is a ASCII CSV file of the format:

First line describes the fields.
eg:
<TICKER>,<DATE>,<CLOSE>

Then you'd need to populate the rest of the file with:
2JLGT,20090417,9.3928

There are variations on this (eg date can be in US date format) - see the Downloader for details.

The way it is right now you wouldn't be able to insert into MetaStock without further manipulation.

bunster · Apr 18, 2009

Thanks Richard.

There's over 2000 lines per file - do you know if there is there some utility that can do the conversion: ie add the date, add the commas, get rid of the 'B' ahead of the Bid Price and get rid of the other unwanted stuff?

tkamal · May 14, 2009

seeking help for convert tick Intraday data to OHLC intraday Data

RichardDale said:
MetaStock requires at (least) a symobl, a date and a close value.

You need to convert it into an ASCII format suitable for a utility such as The Downloader to convert it into MetaStock format.

Typically, this is a ASCII CSV file of the format:

First line describes the fields.
eg:
<TICKER>,<DATE>,<CLOSE>

Then you'd need to populate the rest of the file with:
2JLGT,20090417,9.3928

There are variations on this (eg date can be in US date format) - see the Downloader for details.

The way it is right now you wouldn't be able to insert into MetaStock without further manipulation.

Dear RichardDale,
How can I convert below IEOD data format into 1min or 5min OHLC timeframe with THE HELP OF MS Downloader?
Example:
<TICKER>,<DD-MMM-YYYY>,<HH:MM:SS>,<CLOSE>,<VOLUME>
RELIANCE,13-May-2009,10:01:44,1957.0,859
RELIANCE,13-May-2009,10:02:32,1958.0,679
RELIANCE,13-May-2009,10:03:20,1953.8,485
RELIANCE,13-May-2009,09:55:27,1974.75,1168
RELIANCE,13-May-2009,09:55:31,1973.6,2078
RELIANCE,13-May-2009,09:57:03,1964.0,1249

bunster · May 14, 2009

How can I convert below IEOD data format into 1min or 5min OHLC timeframe with THE

If you need a little piece of software written to convert files into the correct format for Downloader, I recommend Scott Kellish (SoftSystems Solutions LLC)

Tim

RichardDale · May 15, 2009

Change your header line to:

<TICKER>,<DATE>,<TIME>,<CLOSE>,<VOLUME>

You'll also need to change your date format to either:
YYYYMMDD or mm/dd/yyyy (eg. 20090513 or 05/13/2009)

The time should be in 24 hour format... eg 15:25:01

For more information start The Downloader, click help then search and search for "ASCII Source File Layout"

tkamal · Jun 25, 2009

Thanks for reply but it couldn't solve my problem
Actually I have CSV files containing data in below format & I want to convert such csv file data to 1 min or any higher timeframed OHLC ASCII file
e.g. CSV file data of FUTSTK-RELIANCE-25JUN2009_NSE109524 as under:
20090624.1 2013 3000
20090624.1 2016 3900
20090624.1 2025 1200
20090624.1 2018.4 3600
waiting for more helps
thanks again

Can this format work?

bunster

Newbie

RichardDale

Active member

bunster

Newbie

tkamal

Junior member

bunster

Newbie

RichardDale

Active member

tkamal

Junior member

Similar threads