Python script to convert Redis query to JSON or CSV for WordPress AMCharts data loader
This will be very helpful for my WordPress charts in the near future
This will go through many iterations!!
Here is the sample of the Python script
import redis
import codecs, json
sym = ‘EUR’
fname = sym +’.json’
r = redis.StrictRedis(host=’localhost’, port=6379, db=0)
x = r.lrange(‘EUR’,0,10)
with codecs.open(name, ‘w’, ‘utf8’) as f:
f.write(json.dumps(x, sort_keys = True, ensure_ascii=False))
Important notes:
Original example uses redis-py Python package https://github.com/andymccurdy/redis-py
Original example above was found using dinos66 answer from http://stackoverflow.com/questions/12309269/how-do-i-write-json-data-to-a-file-in-python
http://stackoverflow.com/questions/19795012/how-to-convert-a-list-to-jsonarray-in-python
AMCharts data loader example
https://github.com/amcharts/dataloader/tree/master/examples –> refer to the stock samples and see data/MSFT.csv examples
I am sure there will be more to come for this
Join my FREE newsletter to learn how this code will help my automated trading
NOTE I now post my
TRADING ALERTS into my personal
FACEBOOK ACCOUNT and
TWITTER. Don't worry as I don't post stupid cat videos or what I eat!