Horizon API to Spreadsheet?

ChrisMiller

Hello,
I was wondering if it was possible to call data from Stellar Horizon to a spreadsheet, perhaps something like Google Sheets, to build my own dashboard of token prices? My hope is to build a curated CoinMarketCap style list on my Stellar Asset Discussion site LumeRate.com. I have tried a few different things but I am way out of my depth. Any help or suggestions would be greatly appreciated.
Thanks

antb123

Hi Chris... this is very doable...

I have a few scripts I use they are all python backend using something called pandas.. For example
1) Get the bid/ask spread (ignoring orders worth less than $20)
2) get the bid price / ask price again ignoring small orders

if you want front end I recommend hiring a JS programmer . Stellarterm has a public api that might make things easier as well.

I also recommend you use lets encrypt to sure your site. Good luck!