Financial analysis in python

Inputs: txt file containing list of stock symbols location of data folder date range output excel file so command line will look like this: python [login to view URL] c:\[login to view URL] c:\datafolder\ 01/01/2017 06/01/2017 c:\[login to view URL] The stock data is daily open high low close volume. See attached files for format. Output: dataframe 1: This will only be for the last day in the date range. Columns will be: stock symbol, 20 day average true range, 20 day average volume, close as % of 52 week range, close as % of 90 day range, and close as % of 30 day range. (IE if stock range is 0-100 and close is 90 it returns 90%) The rest of the dataframes will be for all days in the date range. So first column will be stock symbol and 1st row will be date. dataframe 2: (close-20 day simple moving average)/close dataframe 3: if high is less than high of previous day, and low is greater than low of previous day = "inside" if high is greater than high of previous day, and low is less than low of previous day = "outside" if low is less than low of yesterday, and yesterday low is less than low of day before that, AND high is less than high of yesterday, and high of yesterday is less than high of day before that = "threedown" if high is greater than high of yesterday, and high of yesterday is greater than high of day before that AND low is greater than low of yesterday, and low of yesterday is greater than low of day before that = "threeup" If none of these are true, = "none" dataframe 4: today close vs yesterday close % change dataframe 5: (today open-yesterday close)/yesterday close Finally these dataframes will be written to one excel file, each dataframe on its own sheet. I will be travelling next week so may have delays in communicating and paying when complete, but I will make best efforts to get on wifi ASAP.