[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Importing data by hand



PureBytes Links

Trading Reference Links

You can import ASCII data directly into SC. I do this with daily futures data
from Pinnacle as well as 5 min data files which I prepare from the nightly CME
Time & Sales files. Also, Pinnacle IDX data contains virtually all of the weekly
data which I used to enter by hand from Barron's. I now hand enter some data
from Barron's On Line and load the rest from Pinnacle. I have a data entry
program I wrote in VB which maintains the Barron's daily, weekly, and monthly
data in a Jet (Access) database and it exports the data in Omega .ord format but
I'll be dumping that whole process as soon as I switch to TradeLab - I'll import
the Pinnacle IDX data directly into TradeLab IEEE files. Don't bother with the
extended Equis formats (Master, EMaster, XMaster) - I wrote code to do it and it
is a giant bucket of worms as Equis stores data in obsolete Microsoft Binary
Format (superceded by IEEE floating point), the file format won't survive beyond
12/31/1999, and the design of the 3, repeat 3, extended master file formats is
absurd.

Earl

-----Original Message-----
From: Barry Kaufman <102577.325@xxxxxxxxxxxxxx>
To: omega-list@xxxxxxxxxx <omega-list@xxxxxxxxxx>
Date: Monday, July 20, 1998 12:12 PM
Subject: Importing data by hand


>There are about 30 weekly market indexes that I get from Barrons and enter
>into a flat file format with my ASCII text editor.  These aren't available to
>be downloaded electronically.  I want to be able to automatically update my
>data directory with these each week.  The method of ASCII importing these via
>the Omega DownLoader is too cumbersome because it appears that it has to be
>done one symbol at a time.  Correct me if I am wrong.
>
>On the other hand, it appears that the DownLoader will batch load a Metastock
>formatted group of symbols.  It may do this for other non-ASCII data formats
>as well.  I am a programmer and could write a utility to convert my flat file
>ASCII format to Metastock or other format, that is if I had the Metastock
>format specifications.  It looks like a Metastock data directory has MASTER
>and EMASTER files, as well as a .DOP and a .DAT file for each symbol.
>
>Any help would be appreciated on a data format specification, or code that
>reads the data format, or even an undocumented trick to batch import ASCII
>format data into the DownLoader.  Or, is there a way to update the Omega data
>files directly without using the DownLoader?
>
>Thanks, Barry.
>