Discussion on "Cleaning Splits and Bonus Data Using Python and Calculating Their Factors!"

Yash Roongta · 2021-04-13T17:07:37.432Z

Welcome Readers 🤩 to the sixth article in the series "NSE EOD Stock Prices." This article will discuss how to use the pandas library to clean the Bonus and Splits Data we downloaded from the Bombay Stock Exchange in the article here. In the last art...

I have tried all what you implemented, thankyou very much. I have tried to implement further, i.e. applying Dividend/Split/Bonus to stocks, but failed, because of series changes from EQ to BE and BE to EQ frequently. Is there any OHCL Adjusted (Dividend/Split/Bonus etc.) Price Data Provider from year 2000.

Thanks Yash...excellent stuff, this very useful. I was not aware of the split/bonus info available as a file in BSE....that's saves a lot of time and effort (have experienced pain) of collecting it from other places in past. One question: If we have say 200 stocks that we have applied splits and bonuses adjustment...we want to check the smoothness price data (or correct application of splits/bonuses). Is there a way to do it with pandas? or would we have to check visually in plots

Example: I am using nsepy lib and for some reason it did not fetch any data from Sep 16th 2021 to 31st march 2022.

I enjoyed all the 7 articles, learnt a lot. Finish it off with making the adjustments to the price data.

You also mentioned that there is a better way to store this data than saving it as a csv.

Am eagerly waiting for the next article of this series.

Keep rocking!

Hi SURAJSINGH RAJPUT glad to know you finished all the articles, very few people complete them as per the analytics I have, so thank you! Google parquet files - they are better than csv. Any suggestions on what our next series should be based on?

Hey Yash Roongta , thanks for the response, I am exploring the adjusting of prices part and it is quite a brain tickler since am so new to pandas.

If you ask me I would wanna build further on this same project and delve into Tkinter for creating a GUI where in all these 7 articles can be used in a much simpler manner. And further explore doing some charting with the EOD database that we have with us now. There are different libraries for GUI and plotting charts in Python, you can create some good content which will be a continuation of this series itself.

What a series! It covers a lot of topics. I hope you create more amazing content.

Search Hashnode

Cleaning Splits and Bonus Data Using Python and Calculating Their Factors!

Responses4