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

[EquisMetaStock Group] Re: data conversion



PureBytes Links

Trading Reference Links

thanks to those who replied to my question
the solution is now at hand
 
Keith
 
----- Original Message -----
Sent: Friday, November 28, 2008 12:58 PM
Subject: Re: [EquisMetaStock Group] Re: data conversion

You can convert excel dates into YYYYMMDD by

1.  creating a new column with the formula below, then copy and paste to all rows)
=YEAR(B1)*10000+MONTH(B1)*100+DAY(B1)
2.  then copy and paste special (values only) into the date column
3. then format the column as a number with zero decimal places
4. then delete the column you originally created.

Alternatively, perhaps consider looking at a data vendor that does all of this for you.

-- 
Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futures and Foreign Exchange Data for
  markets in Australia, Asia, Canada, Europe, UK & USA -
www.premiumdata.net



On 28/11/2008 8:25 AM, keith wrote:

 

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
































 



  

__._,_.___

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___