06-15-2018, 04:23 PM
(06-15-2018, 04:00 PM)maxblack Wrote: Thanks for this plugin, it's really great. Quick question: is there a way to calculate the profit/loss of each trade? I had a quick look at the script, but I couldn't figure out "addEntry" and "newSheet" methods work: the only method called onSubmit seems to be "newSubmission".
What are these two methods for?
Thanks again
Glad you like it, thanks.
Do you mean show the value gained and lost in the currency of the pair? You could add it in code, or you could just add a column at the end and do a standard excel calculation.
Function wise, the new sheet is called when a previously unseen tag/asset/currency/exchange combination is submitted to the form. It generates a new tab and all the headings at the top.
New entry adds the latest info from the form submission into the relevant tab.
The Google script isn't the easiest to follow, addressing different cells repeatedly as it does...