Stock Portfolio Organizer

The ultimate porfolio management solution.

Shares, Margin, CFD's, Futures and Forex
EOD and Realtime
Dividends and Trust Distributions
And Much More ....
For Portfolio Manager Click Here

WiseTrader Toolbox

#1 Selling Amibroker Plugin featuring:

Advanced Adaptive Indicators
Advanced Pattern Exploration
Neural Networks
And Much More ....
Find Out More Here

Exploration to Find Tickers With Corrupted Data for Amibroker (AFL)
saukyk
almost 5 years ago
Amibroker (AFL)

Rating:
5 / 5 (Votes 1)
Tags:
amibroker, exploration

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.

Back