search

krijnsent / crypto_vba

An Excel/VBA project to communicate with various cryptocurrency exchanges APIs
MIT License
157 stars 54 forks source link

Import historical price and volume data from Kraken #22

Closed Pi-Rr closed 6 years ago

Pi-Rr commented 6 years ago

Hi again,

Here is my last feature request (it was a lot!). Would it be possible to develop some code to import the historical prices and volumes from Kraken for any given pair available on the exchange? Ideally, the user will have to input three things: 1) The pair he is interested in (e.g. ETH/EUR, XRP/BTC, etc.) 2) The desired time interval between each prices (e.g. 5 minutes, 1 hour, etc.) 3) The desired period to cover (e.g. last 6 months, from 01-Jan-2017 to 31-Dec-2017, etc.)

If you think you could help with that, it would be amazing :)

Dank u wel! Pierre

krijnsent commented 6 years ago

Hi Pierre, thanks for the direction of thought! I have some simple version of this running locally, but it's buggy as can be. Will try to come up with a good location for this code (in this project or in another).

Pi-Rr commented 6 years ago

Great, glad to hear that you started that already :)

krijnsent commented 6 years ago

Hi Pi-Rr, I added some spreadsheet functions based on the cryptocompare API. They can also pass you quite some Kraken data (hourly & daily). Please do check out the functions and close this issue if it's good enough for you.

Pi-Rr commented 6 years ago

Hi Koen,

The functions I tested work well (though make the spreadsheet a bit unstable if too many are used in the same workbook, e.g. to recover historical prices over a long period of time). I am closing the ticket.

Thanks a lot! Pierre