Hello, I want to do some backtesting and recently
bought some data from eddata.com -- which turned out to
be faulty---they promised to fix it weeks ago so don't deal from them at
all
they're hopeless and unreliable.
so someone sent me some data as an .xls
file--- but I can't convert it to Metastock .
I only use the Downloader every couple of years
for conversions and it's always a problem to remember exactly how to do it---
I find the Downloader "help" section most unhelpful
--
I convertedsome Metastock data back to .txt
to check the format and tried to copy that into mine but am having trouble
with Excel too.
for some crazy reason, Excel won't allow me to
save the date format into YYYYMMDD as it should be? when I save
it, it then switches back to DDMMYYYY .
then, when I save the data as a csv
file ( comma delimited txt file ), it saves it as an .xls as
under
it will save as a space delimited file but the
Downloader won't read that.
this data may get garbled in transmission
so I've also attached a copy
just as well I have plenty of hair or else
i'd have pulled it out by now -- I've spent hours on this --such a simple
thing and such hasles.
if someone could explain what I should do or
point me in the right direction, i'd appreciate it.
thanks Keith
| <TICKER>, |
<DTDDMMYYYY>, |
<OPEN>, |
<HIGH>, |
<LOW>, |
<CLOSE>, |
<VOLUME>, |
<OPEN INTEREST> |
| GC |
1/1/1975 |
191 |
191.5 |
182.7 |
183.9 |
512 |
237 |
| GC |
1/2/1975 |
184 |
184.8 |
173.9 |
175.1 |
294 |
209 |
| GC |
1/3/1975 |
175.5 |
178.5 |
172.5 |
177.5 |
633 |
758 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
