Hi ! Is there any way to import personal transactions to google sheets ? I would like to keep a track of my performance and, in the long term, set my orders automatically through google sheets. Thank you !
Hi Lionel, Great question! I'm working on a solution for this now. Due to past security issues, coinbase makes it quite difficult to pull personal data (righfully so I think). I'll be posting another video once I've gotten this solution worked out! Doug
@@mixedanalytics hi, thank you very much ! I very appreciate it ! I didn’t know about the security issues. It seems that coinbase generates private keys to pull private transactions, place orders… but my knowledge on using APIs is still quite limited. It would be super helpful, I couldn’t find any tutorial on this. Thank you !!
does it auto refresh live data? also i would like for it to add in the all time high for various coins on another cell (can that be auto refreshed also?)
Hi Andrew, Data does not auto-update. You have to manually refresh (you get 8x per day on free account) or you can upgrade to pro for unlimited refreshes + hourly scheduling. Google is pretty weird about allowing extensions to auto-update too much (it's a big problem for us developers lol). As for the second part, this would be pretty interesting to implement.... I think coinbase doesn't have this data (if you mean all time high) but this endpoint has 24 hour candle looks like: docs.pro.coinbase.com/#get-24hr-stats Honestly, I'd highly recommend coingecko, as their API is totally free and they have tons of data available.
Glad it was helpful! If you have any more technical bumps you run across, our Reddit community is quite active and helpful, so feel free to post there.
Nope. You would need to hit "Run" every time you want to refresh the prices (with the free version of API Connector). The Pro version allows you to do scheduling for handling this (you could run hourly, daily, etc).
Hey Jake, Due to the inherently static nature on which spreadsheet programs were built, it's not easy to use Google Sheets as a real-time data dashboard. Our Pro version offers 15 minute interval updates, or you can manually update as fast as you want. You may want to look into an alternative technology (I'm thinking specifically of webhooks, I admittedly don't know much about but am exploring).
Hello, Have you tried running in a different browser/incognito mode? Could be interfering with another extension or something else.. Lemme know if that helps! :)
![Beginners Intro to Pulling API Data into Google Sheets [BONUS: Secret APIs]](http://i.ytimg.com/vi/9VBxRZgY8_4/mqdefault.jpg)
![Beginners Intro to Pulling API Data into Google Sheets [BONUS: Secret APIs]](/img/tr.png)
Great great video ! I don't get why you got so few views, you deserve 1000x more !
I agree XD
Hi ! Is there any way to import personal transactions to google sheets ?
I would like to keep a track of my performance and, in the long term, set my orders automatically through google sheets. Thank you !
Hi Lionel,
Great question! I'm working on a solution for this now. Due to past security issues, coinbase makes it quite difficult to pull personal data (righfully so I think). I'll be posting another video once I've gotten this solution worked out!
Doug
@@mixedanalytics hi, thank you very much ! I very appreciate it !
I didn’t know about the security issues.
It seems that coinbase generates private keys to pull private transactions, place orders… but my knowledge on using APIs is still quite limited.
It would be super helpful, I couldn’t find any tutorial on this. Thank you !!
does it auto refresh live data? also i would like for it to add in the all time high for various coins on another cell (can that be auto refreshed also?)
Hi Andrew,
Data does not auto-update. You have to manually refresh (you get 8x per day on free account) or you can upgrade to pro for unlimited refreshes + hourly scheduling. Google is pretty weird about allowing extensions to auto-update too much (it's a big problem for us developers lol).
As for the second part, this would be pretty interesting to implement.... I think coinbase doesn't have this data (if you mean all time high) but this endpoint has 24 hour candle looks like: docs.pro.coinbase.com/#get-24hr-stats
Honestly, I'd highly recommend coingecko, as their API is totally free and they have tons of data available.
@@mixedanalytics maybe we can connect to discord and we can walk this through
@@pulseprofit-p2p I don't use discord, but you can drop a post over in Reddit and we can chat there for more complex stuff like this :)
Thank you! Not much information is out there regarding this and I’ve been struggling to understand it
Glad it was helpful! If you have any more technical bumps you run across, our Reddit community is quite active and helpful, so feel free to post there.
Hi! I am looking for a Crypto portfolio in Excel for max 50 coins Are you able to do that as well?
Nope, we only work with Google Sheets :)
This method automatically updates the prices ?
Nope. You would need to hit "Run" every time you want to refresh the prices (with the free version of API Connector). The Pro version allows you to do scheduling for handling this (you could run hourly, daily, etc).
Very helpful, thank you! Is there a way for the spreadsheet to update the dollar value of a crypto in real-time?
Hey Jake,
Due to the inherently static nature on which spreadsheet programs were built, it's not easy to use Google Sheets as a real-time data dashboard. Our Pro version offers 15 minute interval updates, or you can manually update as fast as you want. You may want to look into an alternative technology (I'm thinking specifically of webhooks, I admittedly don't know much about but am exploring).
Awesome! Thank you!!!
Thanks for watching Calvin :D
AMAZING. Thank you!!!
You are so welcome!
I click add new and nothing happens
Hello,
Have you tried running in a different browser/incognito mode? Could be interfering with another extension or something else.. Lemme know if that helps! :)
Not applicable now. They changed everything. :(
Hmmm, what changed? I'll be happy to do an update video if need :)
No good! Free copy only gives you 3 saved queries! Useless if you want more than 3 coins in your sheet!
they changed it needs updated
Oh cheers, thanks for the heads up! Can you point me to what got updated so I can check it out?