+- Gekko Forum (https://forum.gekko.wizb.it)
+-- Forum: Gekko (https://forum.gekko.wizb.it/forum-13.html)
+--- Forum: Technical Discussion (https://forum.gekko.wizb.it/forum-23.html)
+--- Thread: [Share][Plugin] Google Sheets Plugin - write all trades to a google sheet (/thread-56609.html)
RE: [Share][Plugin] Google Sheets Plugin - write all trades to a google sheet - Kris191 - 03-31-2018
Thank you for the example, my coding knowledge is next to zero hence all the questions. I've made the changes just waiting for a trade i will feedback either way, Thank you for replying and helping me out.
RE: [Share][Plugin] Google Sheets Plugin - write all trades to a google sheet - Kris191 - 03-31-2018
Works perfect thank you, i will keep you updated if anything changes but good work!!
RE: [Share][Plugin] Google Sheets Plugin - write all trades to a google sheet - Gryphon - 03-31-2018
Awesome :-)
RE: [Share][Plugin] Google Sheets Plugin - write all trades to a google sheet - Kris191 - 04-06-2018
Hi Gryphon,
Sheet works great thank you, i do have one questions tho, i want it to report on the asset holdings rather than currency, my coding skills suck so can you help me adjust your script to do this?
thanks
RE: [Share][Plugin] Google Sheets Plugin - write all trades to a google sheet - Gryphon - 04-09-2018
As it is it gives portfolio balance as the sum of your asset and currency holdings, denoted in currency, as that is what gekko provides. If you want to get this denoted by asset, add a column to the spreadsheet multiplying the balance by current asset price... The drawback is that the only source for the asset price is the gekko trade data, which ideally is high and low points in the price range, so your portfolio balance will be all over the place. -- If I understood what you were after correctly?
RE: [Share][Plugin] Google Sheets Plugin - write all trades to a google sheet - Kris191 - 04-13-2018
Yeah you were right it didn't work as i wanted it too. i will play with it a bit more over the weekend. However the sheet itself works perfectly great job and thank you.
RE: [Share][Plugin] Google Sheets Plugin - write all trades to a google sheet - Gryphon - 04-13-2018
There is a google sheets add-on called cryptofinance that you can use to pull in real time price data - might help you do what you want?
RE: [Share][Plugin] Google Sheets Plugin - write all trades to a google sheet - Kris191 - 04-15-2018
Sounds awesome i will look into that
RE: [Share][Plugin] Google Sheets Plugin - write all trades to a google sheet - Kris191 - 04-18-2018
Hi mate this is broken now with the trade class update as the cli doesn't output a sell it only sends a advice signal, on the exchange the sell will go through but the sheet doesn't pick it up.
RE: [Share][Plugin] Google Sheets Plugin - write all trades to a google sheet - Gryphon - 04-18-2018
Thanks for letting me know! I'll see what I can do to fix it, but will have very limited time for the next month
Edit:
Just pulled the latest gekko develop branch, the trade event is emitted just as before (tested on binance)...