coinbasepro-python VS crypto_vba

I'm trying to set up algo trading through the Blankly Python library. I've generated my Coinbase Pro API keys, but when I try to enter them it always tells me that it failed to connect, and to check to make sure my keys are correct. I'm quite certain that they are, and I made a new set of API keys just in case something was wrong with the first set. I also cannot create an "authenticated client" as described on their readme because the cbpro library is out of date and currently incompatible with blankly.

which uses the coinbasepro-python library to perform trades https://github.com/danpaquin/coinbasepro-python

My question is, when does the order expire, if ever? The documentation is pretty sparse -- https://github.com/danpaquin/coinbasepro-python .

This is pretty trivial if you don't mind getting your feet wet scripting with cbpro.

The cbpro library for Python, for instance, makes interacting with the API very simple, then all you have to do is loop through your accounts grabbing whatever data you need.

To start, I'd say coinbase has a well documented api, (coinbase pro, the exchange, not the other one). This wrapper package was one of the first I used, I assume it's still supported: https://github.com/danpaquin/coinbasepro-python. To knock out 1 and 2 would look something like (psuedo code, don't quote this):

Yeah it does. You can set it up to deposit money it seems. Under deposit/withdraw here: https://github.com/danpaquin/coinbasepro-python it seems to suggest this. To be honest I was already thinking of doing this before I saw your comment, but if someone else would use it too then that's extra motivation. I understand where you're coming from though. I would personally prefer to set it up for myself so it deposits some money in my account every day, buys algorand, and then transfers it to my algorand wallet after a few days, without me having to think about it at all. Just out of curiosity what do you do for employment? I'm a data scientist so I'm a bit of an evangelist for learning python and if it's something that you would be interested in at all I can recommend some resources.

Not sure what language or library you're using, but try the example here: https://github.com/danpaquin/coinbasepro-python#websocketclient-methods

I’m using a Coinbase Pro API for Python to access data from the WebSocket feed. Here’s a first cut that has some debugging code left in place (along with two ways to generate the VWAP, one inefficient (the _vwap method) and one more efficient). Let’s see if py-spy reveals how much time this code uses.

If not, you can find it here: https://github.com/danpaquin/coinbasepro-python

It basically uses the Dictionary object to create variables (e.g. with a dictionary in a dictionary) and after that using that library to transform it into a string. I'm using it in my project here: https://github.com/krijnsent/crypto_vba/blob/master/ModExchKucoin.bas

I agree with u/sslinky84 that there is no safe place in VBA. The main question is: what's the purpose of an API key in this case? From your description you are not linking an API-key to a single user, but have "one key to rule them all". So you probably want to prevent someone from grabbing your end-point and spamming it? In that case you're perfectly fine in creating one API-string in VBA and checking that on the server: it blocks the person who is opening a browser to fiddle with your end-point, but it does give you some security. The people who can get through are the ones that manage to crack open your VBA (assuming you have a password on the VBA). To make their life a bit harder you could instead of a "fixed string" as API key go for some kind of hash, as u/archn suggests. E.g.: take the rest of the post message that e.g. also includes a mandatory timestamp, make a simple hash of that (might even include a "fixed key", see e.g. https://github.com/krijnsent/crypto_vba/blob/master/ModHash.bas for some code).

I've built an open source VBA-Excel library to communicate with cryptocurrency exchanges ( https://github.com/krijnsent/crypto_vba ) and have my code available as .bas and in an .xlsm file. A couple of days ago someone posted an issue that my xlsm file triggered a Windows defender alert. At my pc this doesn't happen, the AVG virus scanner also won't show anything.

I am mainly using Cryptocompare, but if you want to use CoinGecko, check out my code, it has the basics: https://github.com/krijnsent/crypto_vba/ It has most of the essentials: connecting Excel to web, handling Json and some API examples.