Apologies if this is in the wrong section, but I wasn’t sure where to post it.
I am developing a risk engine for bitcoin trading in Google Sheets but I can’t seem to find the data I need and hope someone here would know how.
I trade on very short time frames (most of my trades are no longer than 10mins in duration) and as such I would need the last 100-500 opening prices, closing prices and volume of the candles from the refresh point.
For example, with 100 data points, the most recent would be the previous minute, and the least recent would be from 100 minutes previously.
I have looked up a few of the exchange’s APIs but they seem to be only hourly, and it wouldn’t be an accurate calculation of risk when trading on such short time lines.
If anyone could help that would be great, of course I will be more than happy to share the finally spreadsheet when I finally get it finished!