PureBytes Links
Trading Reference Links
|
There is no reason to do it through EXCEL macro, Amibroker is
here to do the job.
Suppose my suspect stock is "RATL" with Feb 12, 18, 19
and the last 8 sessions missing for some reason.
The ASCII format I use is
<FONT
size=2><TICKER>,<PER>,<DTYYYYMMDD>,<OPEN>,<HIGH>,<LOW>,<CLOSE>,<VOL>MSFT,D,20030224,24.44,24.5,23.84,24.07,62502679
I may fill THE INTERMEDIATE HOLES if I create new
RATL arrays, with the
<FONT color=#000000
face="Times New Roman">// SELECT THE INDEX OF YOUR DATABASE, Apply to current
stock, all quotationsN="RATL";// PLACE YOUR STOCK
HEREROPEN=Foreign(N,"O",1);RHIGH=Foreign(N,"H",1);RLOW=Foreign(N,"L",1);RCLOSE=Foreign(N,"C",1);RVOLUME=Foreign(N,"V",1);Filter=1;AddTextColumn(N,"<TICKER>");AddTextColumn("D","<PER>");AddColumn(19000000+DateNum(),"<DTYYYYMMDD>",1.0);AddColumn(ROPEN,"<OPEN>");AddColumn(RHIGH,"<HIGH>");AddColumn(RLOW,"<LOW>");AddColumn(RCLOSE,"<CLOSE>");AddColumn(RVOLUME,"<VOLUME>");
Export the results
to a csv file and delete the first two columns.
Fill the last empty
lines and, thats it !!!
Dimitris
Tsokakis
Yahoo! Groups Sponsor
ADVERTISEMENT
Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Attachment:
ratl.gif
Attachment:
Description: "Description: GIF image"
|