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!