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

[amibroker] Holes and new "repairing" data



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"