Google Sheet Expert for Stock Option Tracking -- 3
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 stock option trading
-
Repair all bugs, including any new ones created from your work
Currently the Broker Fees is not 100% update it to be accurate based on the fidelity history(see csv)
Delete column T
Delete Column I
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 entry at the top of the page instead of the bottom(reverse order adding a blank line after entry of new line)
PLEASE CHECK THE REQUIREMENTS CAREFULLY THIS IS A COMPLEX GOOGLE SHEET
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 100% update it to be accurate based on the fidelity history(see csv)
Delete column T
Delete Column I
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 entry at the top of the page instead of the bottom(reverse order adding a blank line after entry of new line)
PLEASE CHECK THE REQUIREMENTS CAREFULLY THIS IS A COMPLEX GOOGLE SHEET
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