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 |