Finish a tiny python script that I started for stock volatility
Budget: $10 – $30 USD
I wrote a python script to download a basket of stocks and find the average volatility over a 3 year period for a given date. It also grabs the 10 year US treasury yield for that date.
I'd like to have it flushed out with more features: 1) read an excel file that will have multiple dates in one tab and the list of stock symbols in another 2) check each date to make sure it's a trading day (i.e. week day), and if not increment the date to the nearest trading day 3) if a stock symbol wasn't trading during any day in the 3 year period but has some trade data, get average volatility for data that exists, otherwise ignore it 4) write the results out to a new excel sheet.
This is not too hard...if I can do it, certainly a python expert could knock it out in no time!
I'd like to have it flushed out with more features: 1) read an excel file that will have multiple dates in one tab and the list of stock symbols in another 2) check each date to make sure it's a trading day (i.e. week day), and if not increment the date to the nearest trading day 3) if a stock symbol wasn't trading during any day in the 3 year period but has some trade data, get average volatility for data that exists, otherwise ignore it 4) write the results out to a new excel sheet.
This is not too hard...if I can do it, certainly a python expert could knock it out in no time!