Google Sheet Expert for Stock Option Tracking
Budget: $10 – $30 USD
I am looking for a Google Sheet expert who can assist me in updating a google sheet for tracking stock options. The specific features I require for this sheet include: You must understand the basics of stock option trading
-
Repair all bugs,including any new ones created from your work
Currently the Broker Fees is not working (Column O)
If you are to use column T correct the work with the data needed
Add the probability calculator in Column I using the Black-Scholes Model(scrape data as needed so there is no additional data needed to be entered).
Change the log to make it on a yearly basis ( I want to close out existing year and start new for calendar year (based on date of transaction)
all calculations will be saved by calendar year and start new.
Make the formulas so they cannot be manually overwritten and cause errors ( so user errors do not occur)
Hide the line numbers on the left
Make the fee schedule more accurate according to Fidelity(see csv)
Make the entry at the top of the page instead of the bottom(reverse order adding a blank line after entry of new line)
In terms of assistance, I only need help with the creation of the sheet, not with data entry.
Ideal Skills and Experience:
- Proficient in Google Sheets and experienced in creating complex spreadsheets
- Familiar with probability calculations in relation to stock options using the Black-Schole method
If you have the necessary skills and experience to handle this project, please submit your proposal. Thank you.
https://docs.google.com/spreadsheets/d/1MxN9ETk666ioninl8O_dbjf7nrrLtb08IT74SKIGCcA/edit?usp=sharing
-
Repair all bugs,including any new ones created from your work
Currently the Broker Fees is not working (Column O)
If you are to use column T correct the work with the data needed
Add the probability calculator in Column I using the Black-Scholes Model(scrape data as needed so there is no additional data needed to be entered).
Change the log to make it on a yearly basis ( I want to close out existing year and start new for calendar year (based on date of transaction)
all calculations will be saved by calendar year and start new.
Make the formulas so they cannot be manually overwritten and cause errors ( so user errors do not occur)
Hide the line numbers on the left
Make the fee schedule more accurate according to Fidelity(see csv)
Make the entry at the top of the page instead of the bottom(reverse order adding a blank line after entry of new line)
In terms of assistance, I only need help with the creation of the sheet, not with data entry.
Ideal Skills and Experience:
- Proficient in Google Sheets and experienced in creating complex spreadsheets
- Familiar with probability calculations in relation to stock options using the Black-Schole method
If you have the necessary skills and experience to handle this project, please submit your proposal. Thank you.
https://docs.google.com/spreadsheets/d/1MxN9ETk666ioninl8O_dbjf7nrrLtb08IT74SKIGCcA/edit?usp=sharing