|
PureBytes Links
Trading Reference Links
|
-Open file in Excel
-Click the small blank grey square on the left, above ROW #1, to Select the full sheet
-Click Data|Sort... and Sort Ascending using the Date column for sort order
-Click Edit|Copy
-Run the DL and Paste into the DL security file
or
-Before Save As below, best is to put the proper file's Source Type format
headings on top of each column
-Inset a new ROW and type the DL header in each column's Cell
-Click File and Save As the sheet as XLS file
or
-Click File|Save As and Save As PRN or TXT (TAB dilimitted)
-then go to the file and get rid of any blank line at the bottom of the file
----------------------------------------------
In DL Convert
-XLS files using Excel for Source Type
-PRN or TXT files using ASCII for Source Type
----------------------------------------------
See the recently posted Yahoo!-FAQ mail, to find 2 free programs that automaticaly
downloads data in files from the Yahoo!-site.
Regards,
Ton Maas
ms-irb@xxxxxxxxxxxxxxxx
Dismiss the ".nospam" bit (including the dot) when replying.
Homepage http://home.planet.nl/~anthmaas
----- Oorspronkelijk bericht -----
Van: "Kush Jhingan"
Aan: "Metastock User's List" <metastock@xxxxxxxxxxxxx>
Verzonden: zondag 22 oktober 2000 8:52
Onderwerp: Historical Data
> Hi Frnds,
> In an earlier enq on where i cud dnload hist.data for the Nasdaq Indices
> ,and a few of the
> Indian Co.,listed there and on the NYSE,I was directed to
> yahoo.com.While the data that i req is available there,its formatted in
> reverse chonological order(latest date first)
> Wud someone help as to how i shud go abt transferring this data to
> metastock,so that
> its transferred with the latest date last?
>
> Tks in advance
> Kush
|