Exploration to Find Tickers With Corrupted Data for Amibroker (AFL)
saukyk over 6 years ago Amibroker (AFL)
This formula to find which Ticker has corrupted data in your Amibroker, usually shown as “Invalid Date Time. 00:00:00” in your Date column or “-1.#QNAN” in your Close column if you edit your symbol in Quotations Editor.
Screenshots
Indicator / Formula
Copy & Paste Friendly
Filter=BeginValue( DateNum()) <0 ;
AddColumn(O,"Open");
AddColumn(H,"High");
AddColumn(L,"Low");
AddColumn(C,"Close");
AddColumn(V,"Volume");
AddColumn(OI,"Open Interest");
AddColumn(Aux1,"AUX1");
AddColumn(Aux2,"AUX2");
AddColumn(BeginValue( DateNum() ),"Begin");
0 comments
Leave Comment
Please login here to leave a comment.