google sheet customization
Budget: $2 – $8 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 are 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 every year ( I want to close out the existing year and start new for the calendar year (based on the date of the 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(in reverse order adding a blank line after the entry of the 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 about stock options using the Black-Scholes 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 are 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 every year ( I want to close out the existing year and start new for the calendar year (based on the date of the 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(in reverse order adding a blank line after the entry of the 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 about stock options using the Black-Scholes 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