Python script to convert Redis query to JSON or CSV for WordPress AMCharts data loader

(Last Updated On: May 17, 2016)

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

 

HOW DO YOU START A PROFITABLE TRADING BUSINESS? Read more NOW >>>

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!
This entry was posted in Quant Development and tagged , , , , , , , , , , on by .

About caustic

Hi i there My name is Bryan Downing. I am part of a company called QuantLabs.Net This is specifically a company with a high profile blog about technology, trading, financial, investment, quant, etc. It posts things on how to do job interviews with large companies like Morgan Stanley, Bloomberg, Citibank, and IBM. It also posts different unique tips and tricks on Java, C++, or C programming. It posts about different techniques in learning about Matlab and building models or strategies. There is a lot here if you are into venturing into the financial world like quant or technical analysis. It also discusses the future generation of trading and programming Specialties: C++, Java, C#, Matlab, quant, models, strategies, technical analysis, linux, windows P.S. I have been known to be the worst typist. Do not be offended by it as I like to bang stuff out and put priorty of what I do over typing. Maybe one day I can get a full time copy editor to help out. Do note I prefer videos as they are much easier to produce so check out my many video at youtube.com/quantlabs