|
PureBytes Links
Trading Reference Links
|
CSV
(comma seperated values, wonder why TOO many programs start and 'save as'
semi-colon values, wich results in SCV!!!, when one expects.............. comma's)
To use with CSV
-apply the proper colom headers(+arranging see below)
To use with Excel
-for proper colom arranging, first look into the dl manual p.72-73
"Quatro/1-2-3 and Excel Source File Layout" and too, for the correct
"spreadsheet" files layouts and other conditions
(VERY VERY important! for not getting irretating errors)
-open your csv-file in Excel and make the appropeate adjustments in each colom,
either for 'saving as' a ASCI or Spreadsheet layout(TXT or CSV or XLS) but make
your choice upfront as f.i. ASCI layout in XLS-file doesn't convert
-GIVE each colom its own header
-use for historical updating per SINGLE security ONLY
To use with ASCI
-DO NOT EVER APPLY coloms headings wich are written in dl manual on p.70
(THESE ARE ONE OF THE CAUSE OF METASTOCKS' UNFRIENDLY ERRORS)
but first make a normal 'any security will do' conversion from Metastock type to "your type",
this, as header arrangement and its 'naming' differs f.i. in the way the "<date>" header
ought to be written. This MUST be <DTYYMMDD> and not <DATE> or <date>(=ERRORS).
-in each file seperately, apply the apropiate colom-headers(especialy when receiving
more of these STUPID IRRETATING "can't do" errors, even though the files' layout and its
contents are in the correct order or layout)
-delete AND don't ever apply the superflous, usually in the header, <time> colom
(don't know for whatever reasons files get back-converted with a header and a colom as such as
the "standard" MSwin is not RT compatible, but THIS TOO causes plenty of ERRORS)
-when files are back-converted, rename them as files are automatically WRONG named with
7 positions of the ticker symbol, and the "period" D at the names' 8 position filename(so much
for Win95 compatibility, no the Downloader for Windows95 v6.5 is only TRUE DOS compatible)
-delete all empty lines at a files' bottom(don't know why this have to matter BUT IT DOES)
-check on and delete all superflous "tabs","spaces","comma's"(especialy the last one right of
the 7th data(10th "normal") colom(usualy "open intrest") and all other useless but non-the less
added(WORD97) characters, a lot too are "invisible"(CR etc.) BUT ALL WILL CREATE ERRORS
-use for daily+historical updating per MULTIPLE and SINGLE securities
-Notepad has a limit to file lengths and ALSO in its 'copy' or making manual adjustments
functioning, thus Wordpad for the long lengthy files, but then make sure Wordpad doesn't
correct a file by itselve(re-arranging, adding not visable characters), as that happens too often.
Have fun with the irritating CSV, if you wish, the pleasant EXCEL or ASCI.
regards,
Ton Maas
Ms-IRB@xxxxxxxxx
-----Oorspronkelijk bericht-----
Van: Don <runadog@xxxxxxxxxxxxxxxx>
Aan: metastock@xxxxxxxxxxxxx <metastock@xxxxxxxxxxxxx>
Datum: zaterdag 20 juni 1998 12:39
Onderwerp: CSV to Metastock
>
>I was wondering if anyone here can tell me how to change CSV data files into
>MetaStock. I've been playing with a shareware program called "NeuroStock
>2.020".
>the program has a downloader and pulls up three years worth of historical
>data from
>a web site. I use Reuteres as a data providerand also have to wait till
>late in the evening to download my data. It would be great if I could look
>at those CSV files with
>MetaStock.
>
> NeuroStocks web site is at : http://pdicsoft.com/neurostock/
>
>
>
> Don
>
>
|