search

walkjivefly / LOC-Extension

LibreOffice Cryptocurrency extension
GNU Lesser General Public License v3.0
37 stars 14 forks source link

Fetch Historical Data? #5

Open Shipwreck opened 6 years ago

Shipwreck commented 6 years ago

Ubuntu 7.10 and LOC .0.2.3

Great plugin, thanks very much for your work! I'm hoping to fetch historical data, ideally from adjacent cells, but I'm having a hard time.

In examples.ods>ccxt I see the 'datacode' options for timestamp and datetime - looks perfect!

However, I can't get anything other than #VALUE!

datetime is ISO8601 so I thought just putting 2017-03-12 would fetch the data for a particular pair on a particular exchange on that date.

For example

=CCXT("BitFinex","BTC/USD","last") works great but =CCXT("BitFinex","BTC/USD","2017-03-04") returns Exception Encountered.

So, is what I am trying to do possible and if so could you please tell me how 🥇

Thanks very much for your time.

walkjivefly commented 6 years ago

Hey, @Shipwreck, nice idea but no it isn't possible with the extension in its current form.

The information is available from some exchanges as historical OHLCV candlestick data and the embedded ccxt exposes it where possible. LOC-Extension could probably be extended to do what you want but it's not something I'm going to attempt. I've flagged this as an enhancement request and help wanted; maybe someone else is up for the challenge.

Thanks for using the extension and hopefully you'll continue to find it helpful even if not ideal.

Shipwreck commented 6 years ago

Hey @walkjivefly thanks for the prompt response. I'll poke around the CCXT community and see if there are any leads.

Have a good one, thanks again for the great plugin!