(Stock Data Base) Post 2

Meant to write this earlier in the week but oh well, I learned that dealing with excel in the way that I originally wanted to with pandas data-frame has some kind of issue with working with excel. So I have resolved to using csv style format file. As for writing the code I have the bare bones of it laid out which is basically just writing the request and since the apis have structured their data in json its easy to write a json request. The one area I have completed and that I feel that have completed is getting the dividends and calculating the total dividend payments in a year which I have done by writing a few lines using datetime to get get the current year subtracting one from it so I get the previous year and summing all of the dividend payments made that year. I have also written the lines of code to get the basics of data from some of the end points although I may change these at some point if I feel that there is more data that I want from these end points. I have also written the very bare bones of the lines of code that I will use to append the data to the csv file.