Gekko Forum
[Share][Plugin] Google Sheets Plugin - write all trades to a google sheet - Printable Version

+- 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)

Pages: 1 2 3 4 5 6


RE: [Share][Plugin] Google Sheets Plugin - write all trades to a google sheet - Kris191 - 05-31-2018

API question i have got my access token and run it through the terminal to get the response however which is the API the created or modified number?


RE: [Share][Plugin] Google Sheets Plugin - write all trades to a google sheet - Gryphon - 06-01-2018

For Pushbullet? It's just the Access Token that you get from your user accounts page that you need - simply copy that into the pushbullet config.

Note that I have added a couple of lines to the pushbullet CLI config - the sample config is in comments at the top of the modified plugin file.


RE: [Share][Plugin] Google Sheets Plugin - write all trades to a google sheet - whoodat - 06-07-2018

@Gryphon great tool man I like the concept....my only problem with it, I have run live for a few weeks and neither pushbullet or google sheets tracks live data correctly. It will track what it's suppose to buy or sell at but with slippage or any other factor that adjusts the price before a true buy or sell the data never matches making the tracking pretty inaccurate.


RE: [Share][Plugin] Google Sheets Plugin - write all trades to a google sheet - Gryphon - 06-07-2018

You're not the only person to report this unfortunately. Weirdly when I've gone through my Binance trade log and compared, it's been accurate but I've had others send me screenshots and there have been inaccuracies.

The sheet logs what gekko reports at the end of a trade - unfortunately it's the best data that gekko can give. The whole trade module in gekko is getting a massive overhaul at the moment (check pull requests on GitHub) so I'm hoping that might improve things.

If you have any logs from the sheet and exchange you're able to share here to show where it doesn't match that would be excellent.


RE: [Share][Plugin] Google Sheets Plugin - write all trades to a google sheet - wewantmoore - 06-08-2018

Great plugin! Just can't seem to get it to work yet..

CLI says the following, but trades don't show up in the sheet yet. Any ideas?

Setting up:
0|Gekko | 2018-06-06 14:58:45 (INFO): Google Forms
0|Gekko | 2018-06-06 14:58:45 (INFO): Logs Trades to Google Forms
0|Gekko | 2018-06-06 14:58:45 (INFO): Prefilled link parsed successfully. 11 fields found.
0|Gekko | 2018-06-06 14:58:45 (INFO): gForms Plugin Active. Any new trades will be sent to your google form


RE: [Share][Plugin] Google Sheets Plugin - write all trades to a google sheet - Gryphon - 06-08-2018

That is most likely because the current version of gekko doesn't emit the trade event properly. You can try the fix that xFFFFF posted earlier in this thread, worked for me, but may have been what made my gekko unstable.


RE: [Share][Plugin] Google Sheets Plugin - write all trades to a google sheet - wewantmoore - 06-08-2018

OK, haven't updated my version of gekko for a while, but I will try it, thanks.


RE: [Share][Plugin] Google Sheets Plugin - write all trades to a google sheet - Olider - 06-09-2018

Hello man. First thanks fot this amazin plugin

I'm trying to set it up but keep getting this error

https://imgur.com/maJjFKL

ths is how I have the code... just copy and paste as the indications

https://imgur.com/z3vvgP9

Any idea what could it be???


RE: [Share][Plugin] Google Sheets Plugin - write all trades to a google sheet - Kris191 - 06-11-2018

(06-09-2018, 07:46 PM)Olider Wrote: Hello man. First thanks fot this amazin plugin

I'm trying to set it up but keep getting this error

https://imgur.com/maJjFKL

ths is how I have the code... just copy and paste as the indications

https://imgur.com/z3vvgP9

Any idea what could it be???
you need to add  a , after 'gfroms'


RE: [Share][Plugin] Google Sheets Plugin - write all trades to a google sheet - Kris191 - 06-11-2018

(06-08-2018, 11:14 AM)wewantmoore Wrote: OK, haven't updated my version of gekko for a while, but I will try it, thanks.

you may need to setup the trigger for the script.

https://stackoverflow.com/questions/17992718/how-to-get-onformsubmit-to-trigger-automatically