Build google spreadsheet
Budget: $65 – $115 HKD
Hi, I’d like to hire a programmer for improving my current google spreadsheet
This is a project for option trading idea and log the trade (with several portfolios)
Generating trading idea.
1. In sheet ‘Data’ – a user will manually copy and paste all the weekly expiring option
2. Then a user will copy the data into “Weekly Idea’. Now currently a user needs to copy each ticker into “Earning results calendar” B1 cell and then go to website B3 to copy the date shown in the table on the website and paste into Cell ‘N17:T26’. (Automatic workflow is needed)
3. The current spreadsheet will retrieve from google finance and update “Price History” and then update the number automatically in the Result Day table.
4. Then a user must copy cells “H5:L5” into Weekly Idea column “X: AB”. And YTD from “Earning Results Calendar” cell B8 into “Weekly Idea” cell column V. (Automatic workflow is need”)
5. Once a user has input all the details for each stock. A user must go to “earning results calendar” B4 to check the closest option price with the details of “Weekly Idea” column O “Exp Date”, column AC “Expect strike” to fill the column “AD”. (Hopefully it can be automatic)
This is a project for option trading idea and log the trade (with several portfolios)
Generating trading idea.
1. In sheet ‘Data’ – a user will manually copy and paste all the weekly expiring option
2. Then a user will copy the data into “Weekly Idea’. Now currently a user needs to copy each ticker into “Earning results calendar” B1 cell and then go to website B3 to copy the date shown in the table on the website and paste into Cell ‘N17:T26’. (Automatic workflow is needed)
3. The current spreadsheet will retrieve from google finance and update “Price History” and then update the number automatically in the Result Day table.
4. Then a user must copy cells “H5:L5” into Weekly Idea column “X: AB”. And YTD from “Earning Results Calendar” cell B8 into “Weekly Idea” cell column V. (Automatic workflow is need”)
5. Once a user has input all the details for each stock. A user must go to “earning results calendar” B4 to check the closest option price with the details of “Weekly Idea” column O “Exp Date”, column AC “Expect strike” to fill the column “AD”. (Hopefully it can be automatic)