NexusFi: Find Your Edge


Home Menu

 





AFL to find wrong Data


Discussion in Platforms and Indicators

Updated
    1. trending_up 1,489 views
    2. thumb_up 0 thanks given
    3. group 2 followers
    1. forum 3 posts
    2. attach_file 0 attachments




 
Search this Thread

AFL to find wrong Data

  #1 (permalink)
Jacare
Munich Germany
 
Posts: 10 since Jan 2014
Thanks Given: 1
Thanks Received: 2

Hi all,

I use Yahoo Finance as quote provider and there are a lot of wrong quotes. For example, a stock that has its price $5, next day price $120 and the next day $5 again. It is like a gap, but with a big %Change. Could someone help me with the code? I try this one, but it doesn't work:


Buy = L > ((Ref(C, -1)*2);
Sell = H < ((Ref(C, -1)*2);

Filter = (Buy OR Sell)

AddTextColumn( FullName(), "Name",100, colorDefault,colorDefault,300);
AddTextColumn( WriteIf( Buy, "Buy", "Sell" ), "Signal", 50, colorDefault,colorDefault, 50 );

SetSortColumns( 4,-5) ;



I would appreciate any kind of help.

Thanks,

Jaca

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
NexusFi Journal Challenge - April 2024
Feedback and Announcements
Request for MACD with option to use different MAs for fa …
NinjaTrader
My NT8 Volume Profile Split by Asian/Euro/Open
NinjaTrader
ZombieSqueeze
Platforms and Indicators
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Retail Trading As An Industry
58 thanks
Battlestations: Show us your trading desks!
48 thanks
NexusFi site changelog and issues/problem reporting
47 thanks
GFIs1 1 DAX trade per day journal
32 thanks
What percentage per day is possible? [Poll]
31 thanks

  #2 (permalink)
colion
Asheville, North Carolina
 
Posts: 24 since Sep 2010
Thanks Given: 1
Thanks Received: 15

You might try downloading again as Yahoo often corrects data (or rather their data supplier catches the problem and corrects) and this is particularly true for historical data rather than Daily. To see if there is a more fundamental problem with the data always double check the data against other sources such as StockCharts.com or TradingView.com.

Reply With Quote
  #3 (permalink)
Jacare
Munich Germany
 
Posts: 10 since Jan 2014
Thanks Given: 1
Thanks Received: 2


Thanks for the answer, but I am looking for an AFL that can find this errors. I checked again and i.e. AGL is still wrong.

Could someone help me with the formula?

Thanks,

Jacare

Reply With Quote
  #4 (permalink)
colion
Asheville, North Carolina
 
Posts: 24 since Sep 2010
Thanks Given: 1
Thanks Received: 15

Some questions and "to dos":

1 - Give us a couple of examples - which symbols and dates and timeframe (daily/historical). Are all of the errors like 5-120-5? Are you by chance looking at a split or dividend and your downloader is not compensating? What downloader are you using? Is the data OK on the website?
2 - Run your data through database purify. Does that solve the problem?
3 - If 2 is not adequate define what conditions you want to search for? Your code will not do the job. You will have to define conditions for O, H, L, C independently as any of these can be off.

Reply With Quote





Last Updated on September 29, 2014


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts