Google Sheets formulas / scripting / automation
Budget: $30 – $250 CAD
Please watch this video showing exact scope of job:
https://screencast-o-matic.com/watch/crQTb5V6Ay5
I also have a sample spreadsheet, found here (as shown in video):
https://docs.google.com/spreadsheets/d/1_me4fmEQKV_s6qbSuxz4-yfNkl7QmHSiKhClf1rSi3I/edit?usp=sharing
Please let me know what you can provide as per the video and the description below, and for how much (and how much time).
Required
i. Spreadsheet appends new data to "Trade Details" tab
ii. Calculated metrics are updated accordingly on Summary tab
iii. Chart is generated based on desired dimensions (and possibly choice of metrics)
From there I see at least three different levels of automation/complexity that could be created. Please quote me based on your experience and capabilities. I am ok with any of these but just need to weigh the cost and time (and of course if it's actually possible).
Scenario 1
I manually copy (using the Export button) and manually paste data from clipboard to relevant spreadsheet and tab (most time intensive for me).
Scenario 2
I manually copy the data using the Export button, and a script automatically pastes it to the proper spreadsheet and tab.
Scenario 3
A script automatically fetches and appends the data from a list of symbols (eg XRPPERP) on a daily basis with no intervention from me.
Scenario X
If you see something different working based on your skills, please feel free to suggest a solution!
Thank you for your interest in this project! I look forward to discussing. Kindly.
PS - Obviously the budget will vary based on the solution(s) proposed. Please mention your required budget for the solution(s) you propose and we will come to an agreement together.
https://screencast-o-matic.com/watch/crQTb5V6Ay5
I also have a sample spreadsheet, found here (as shown in video):
https://docs.google.com/spreadsheets/d/1_me4fmEQKV_s6qbSuxz4-yfNkl7QmHSiKhClf1rSi3I/edit?usp=sharing
Please let me know what you can provide as per the video and the description below, and for how much (and how much time).
Required
i. Spreadsheet appends new data to "Trade Details" tab
ii. Calculated metrics are updated accordingly on Summary tab
iii. Chart is generated based on desired dimensions (and possibly choice of metrics)
From there I see at least three different levels of automation/complexity that could be created. Please quote me based on your experience and capabilities. I am ok with any of these but just need to weigh the cost and time (and of course if it's actually possible).
Scenario 1
I manually copy (using the Export button) and manually paste data from clipboard to relevant spreadsheet and tab (most time intensive for me).
Scenario 2
I manually copy the data using the Export button, and a script automatically pastes it to the proper spreadsheet and tab.
Scenario 3
A script automatically fetches and appends the data from a list of symbols (eg XRPPERP) on a daily basis with no intervention from me.
Scenario X
If you see something different working based on your skills, please feel free to suggest a solution!
Thank you for your interest in this project! I look forward to discussing. Kindly.
PS - Obviously the budget will vary based on the solution(s) proposed. Please mention your required budget for the solution(s) you propose and we will come to an agreement together.