|
PureBytes Links
Trading Reference Links
|
I tried your template, but I don't exacly know how to use it. When I open
it, (single clicking with IE4 :-) ) I have a spreadsheet with several ticker
symbols and the date. Is there something I have forgotten or do I have to
insert the open high low close volume open interest myself?
PS1 I send a mail to FIBBS, thanks for the tip.
PS2 I will send a separate email concerning the newsgroup item.
PS3 I made a macro in Excel97 that works. I am now trying to make some
usefull adjustments to it, so it will run even better. And yes you have to
learn a new programming language, namely Visual Basic (for Applications). If
you want any help about this I suggest to subscribe to
microsoft.public.excel.programming. They are very helpfull :-)
Best for the new year,
Jan Diederik
-----Original Message-----
From: A.J. Maas <anthmaas@xxxxxx>
To: metastock-list@xxxxxxxxxxxxx <metastock-list@xxxxxxxxxxxxx>
Date: zondag 28 december 1997 11:25
Subject: Re: Tech support #
>Ps. enclosed find the Excel "DailyUpdate"-template I use at the moment,
>I "linked" the template to the desktop, 2x left-click the "link" starts a
>'New' Excel-file, then select the 1st cell at the top of the data
>column, "12//97", in the 'formula-window' above it type the exact
>day(01 or 11 or 31) between the middle slashes, then 'copy' the
>"full date" a few times(incl. "multy"-copying as you go down
>the file's date-colom) and then "save as" 'space separated text
>file'(xxx.prn), then check in Notepad the file for empty lines at
>the bottom, e.g. put the blinker behind the lowest "0"(most to
>your right at the file-bottom), press 'Del' to delete ALL the
>invissible empty lines and run it through the downloader.
>
>To "change" the template: 1x right click the link, instead of 'New' choose
>'Open', make your adjustments, the columns require a minimal
>width/length-setup, and 'save' or 'save as' the template. This you
>only have to do once a month. Adjust the link's name/address if
>necessary. (Don't forget to make a spare-copy of the template
>somewhere else).
>By the way, FIBBS Fin DataBank offers a fully automatic-update
>service on the AEX, for the lowest price around.
>info@xxxxxxxx
>How are you progressing with your "filename=date macro"?
>Does one have to learn a/another new lango(VisualBasic) ?
>===============================================
|