Stock Symbols Minimum & Maximum and Average flotation band
Budget: $30 – $250 USD
I want to automate some procedure I have been doing manually for a while.
Base on Up-to-yesterday's-date historical prices, that can be downloaded from multiples websites for free, calculate the flotation band, and other things.
Normally, any downloadable database, per stock symbol, will include a year or more of this data:
- Date
- Open
- High
- Low
- Close
- Adjusted Close
- Volume
I only need this data:
- Date
- High
- Low
I need to calculate the following:
* Band = High - Low.
* B @ 80% = 80% of Band
* Buy = Low + 10% of Band
* Sell = High - 10% of Band
* Profit $ = Sell - Buy
* Profit % = Profit $ / Buy
* Average 30 $ = Average of most recent 30 days of Profit $
* Average 60 $ = Average of most recent 60 days of Profit $
* Average 90 $ = Average of most recent 90 days of Profit $
* Average 180 $ = Average of most recent 180 days of Profit $
* Average 30 % = Average of most recent 30 days of Profit %
* Average 60 % = Average of most recent 60 days of Profit %
* Average 90 % = Average of most recent 90 days of Profit %
* Average 180 % = Average of most recent 180 days of Profit %
I need to be able to enter AT ONCE or PASTE a full list with up to 8,000 stock symbols.
The expected delivery will be the full list of up to 8,000 stock symbols sorted by "Average 30 %", everything done in 2-3 hours max. List must contain 2 columns, Stock Symbol, and Average 30 %
Base on Up-to-yesterday's-date historical prices, that can be downloaded from multiples websites for free, calculate the flotation band, and other things.
Normally, any downloadable database, per stock symbol, will include a year or more of this data:
- Date
- Open
- High
- Low
- Close
- Adjusted Close
- Volume
I only need this data:
- Date
- High
- Low
I need to calculate the following:
* Band = High - Low.
* B @ 80% = 80% of Band
* Buy = Low + 10% of Band
* Sell = High - 10% of Band
* Profit $ = Sell - Buy
* Profit % = Profit $ / Buy
* Average 30 $ = Average of most recent 30 days of Profit $
* Average 60 $ = Average of most recent 60 days of Profit $
* Average 90 $ = Average of most recent 90 days of Profit $
* Average 180 $ = Average of most recent 180 days of Profit $
* Average 30 % = Average of most recent 30 days of Profit %
* Average 60 % = Average of most recent 60 days of Profit %
* Average 90 % = Average of most recent 90 days of Profit %
* Average 180 % = Average of most recent 180 days of Profit %
I need to be able to enter AT ONCE or PASTE a full list with up to 8,000 stock symbols.
The expected delivery will be the full list of up to 8,000 stock symbols sorted by "Average 30 %", everything done in 2-3 hours max. List must contain 2 columns, Stock Symbol, and Average 30 %