Hi, I have been trying to create a calculator which looks at returns from a stock if you average in over time (average in is when you put $2000 into a stock every month or two months or so). Using data from yahoo finance such as https://au.finance.yahoo.com/quote/...96000&interval=1d&filter=history&frequency=1d what would people recommend is the best way to clean this data? For starters only "date" and "open" columns would be kept as the others are unneeded. There are some missing values in the data and some which read "null".
Continuing on from above I would then like a a formula of some sort where you select the "amount", "start date", "time interval" and "end date". Basically the formula then looks at these three things and put the amount in the start date and then puts another amount in after the time interval and then so on up until the end date. I have tried using some basic formulas but the issue is that a lot of dates aren't in the data set such as weekends and public holidays and so it just skips over them. I thought there may be a better way to clean the data which may make this easier.
Any help would be good thanks.
Continuing on from above I would then like a a formula of some sort where you select the "amount", "start date", "time interval" and "end date". Basically the formula then looks at these three things and put the amount in the start date and then puts another amount in after the time interval and then so on up until the end date. I have tried using some basic formulas but the issue is that a lot of dates aren't in the data set such as weekends and public holidays and so it just skips over them. I thought there may be a better way to clean the data which may make this easier.
Any help would be good thanks.
