Data Anomaly Detected in multiple stocks

Hi,

While validating the data downloaded from Fyers API, foudn these anomalies. I scanned only “-EQ” stocks in recent time.

I have refreshed data from my side. Please have a look and share your thoughts or fix these.

Thanks

Note - I am not sure why I am not able to attached sheet. Here is the data I found.

symbol date anomaly_type details
FEDERALBNK 11-09-2000 non_positive_price open=0.0, high=0.0, low=0.0, close=1.17
FEDERALBNK 11-09-2000 close_out_of_range low=0.0, close=1.17, high=0.0
FEDERALBNK 01-01-2001 non_positive_price open=0.0, high=0.0, low=0.0, close=1.27
FEDERALBNK 01-01-2001 close_out_of_range low=0.0, close=1.27, high=0.0
GILLETTE 07-10-1998 open_out_of_range low=854.0, open=835.6, high=869.95
HEROMOTOCO 10-08-1998 split_like_move prev_close=95.57, close=186.59, ratio=0.4978, matched=0.5
IFBAGRO 20-04-2000 split_like_move prev_close=9.0, close=8.85, ratio=1.4754, matched=1.5
IFBAGRO 01-11-2000 split_like_move prev_close=3.6, close=5.35, ratio=2.0000, matched=2.0
IFBAGRO 08-11-2000 split_like_move prev_close=5.0, close=4.85, ratio=2.0000, matched=2.0
IFBAGRO 15-11-2000 split_like_move prev_close=4.35, close=2.2, ratio=1.9773, matched=2.0
IFBAGRO 22-11-2000 split_like_move prev_close=4.95, close=4.8, ratio=1.9800, matched=2.0
IFBAGRO 02-01-2001 split_like_move prev_close=6.8, close=4.65, ratio=1.4624, matched=1.5
IFBAGRO 05-07-2001 split_like_move prev_close=6.0, close=3.9, ratio=1.5385, matched=1.5
IFBAGRO 14-08-2001 split_like_move prev_close=2.6, close=1.75, ratio=1.4857, matched=1.5
IFBAGRO 12-11-2001 split_like_move prev_close=2.3, close=4.5, ratio=0.5111, matched=0.5
IFBAGRO 22-11-2001 split_like_move prev_close=3.95, close=2.6, ratio=1.5192, matched=1.5
KILITCH 24-09-2012 split_like_move prev_close=69.38, close=41.69, ratio=2.0257, matched=2.0
KOTAKBANK 25-04-2000 split_like_move prev_close=1.05, close=0.7, ratio=1.5000, matched=1.5
KOTAKBANK 19-05-2000 non_positive_price open=0.0, high=0.0, low=0.0, close=0.63
KOTAKBANK 19-05-2000 close_out_of_range low=0.0, close=0.63, high=0.0
KOTAKBANK 14-06-2000 non_positive_price open=0.0, high=0.0, low=0.0, close=0.74
KOTAKBANK 14-06-2000 close_out_of_range low=0.0, close=0.74, high=0.0
KOTAKBANK 04-12-2000 non_positive_price open=0.0, high=0.0, low=0.0, close=0.71
KOTAKBANK 04-12-2000 close_out_of_range low=0.0, close=0.71, high=0.0
MASTEK 12-06-2015 split_like_move prev_close=438.05, close=148.95, ratio=2.9203, matched=3.0
MFSL 08-05-2000 split_like_move prev_close=56.26, close=110.91, ratio=0.4935, matched=0.5
RAYMOND 14-05-2025 split_like_move prev_close=1564.3, close=551.2, ratio=2.9796, matched=3.0
S&SPOWER 19-11-1998 close_out_of_range low=9.8, close=9.95, high=9.94
S&SPOWER 23-04-1999 split_like_move prev_close=9.6, close=9.1, ratio=1.9794, matched=2.0
S&SPOWER 20-07-2001 split_like_move prev_close=3.25, close=2.15, ratio=1.5116, matched=1.5
S&SPOWER 24-12-2001 split_like_move prev_close=3.0, close=2.0, ratio=1.5000, matched=1.5
SIEMENS 07-04-2025 split_like_move prev_close=4928.15, close=2812.45, ratio=2.0115, matched=2.0
TEAMGTY 22-06-1999 split_like_move prev_close=6.5, close=4.4, ratio=1.4773, matched=1.5
TEAMGTY 24-07-2001 split_like_move prev_close=8.1, close=5.5, ratio=1.4727, matched=1.5
TEAMGTY 02-11-2001 split_like_move prev_close=9.8, close=4.95, ratio=1.9798, matched=2.0
TEAMGTY 11-06-2002 split_like_move prev_close=4.95, close=9.15, ratio=0.4925, matched=0.5
TORNTPHARM 07-10-1998 open_out_of_range low=4.6, open=4.39, high=4.65
TRENT 03-06-1998 split_like_move prev_close=16.51, close=11.08, ratio=1.4572, matched=1.5
VESUVIUS 20-03-1999 non_positive_price open=0.0, high=12.6, low=12.31, close=12.33
VESUVIUS 20-03-1999 open_out_of_range low=12.31, open=0.0, high=12.6
VLSFINANCE 04-03-2004 split_like_move prev_close=6.95, close=4.5, ratio=1.5444, matched=1.5

Hi @109657016862718966111,

This is not an issue. Due to data unavailability at the source, you may observe anomalies for some symbols on certain days.

The same applies to charts as well—data for those specific dates is not available. This behavior may also be observed on charting platforms such as TradingView.

However, the data is correct and available for all other dates.

Hi @naresh_janagama ,
Thanks for the reply, apologies I could not post the filtered table above. That is what I was trying to do in the first place.

There may be other also, I could find these only.

Below Example of anomalies -

MASTEK

  • 2015-06-12
  • prev_close=438.05
  • close=148.95
  • ratio=2.9203

SIEMENS

  • 2025-04-07
  • prev_close=4928.15
  • close=2812.45
  • ratio=2.0115

RAYMOND

  • 2025-05-14
  • prev_close=1564.3
  • close=551.2
  • ratio=2.9796

Hey @109657016862718966111,

Thank you for bringing this to our attention. A few corporate actions were not adjusted for certain symbols. We will update them.

how do we adjust historical prices downloaded and saved on our local system, through the Fyers API based on Corporate actions