Hi, I have setup excel in my profile, and I use a single sheet to add/update values, at market settle.
I am trying to show the profit/loss made at each step, and I wish to write this to a new row cell every time the market settles.
So, for example, the first bet wins £2, I wish to place this at Cell C2, next bet loses, I now wish to place that value in cell C3
I have set a count cell elsewhere, at H2, which indicates =SUMPRODUCT(MAX((C2:C20000 <>"")*ROW(C2:C20000))) + 1, which, in short gives me the last empty row/cell. I wish to use this in my logging trigger, and I use a 'write to excel' action in the trigger, and have attempted to give the Cell Address as data!C + cell_data_H2, but of course this is not working.
I am not sure of the syntax of doing this as the documentation is very limited on excel
Any help is appreciated
Thanks