Tag Archives: loader

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

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!

Forex Tick Historical Database Loader for backtesting C# application source code download

 

Forex Tick Historical Database Loader for backtesting  C# application source code download

This will extract from a potential Forex tick file which is comma serparated value CSV file. It will then populate certain info into an existing MYSQL table called FX.

Download source code here.

 

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!

How to build tick MYSQL historical database for forex trading with C# bulk data loader

How to build tick MYSQL historical database for forex trading with C# bulk data loader

I give brief run down on how to accomplish this using these tools. I also provide a MYSQL SQL file to create your forex tick data historical database in FREE MYSQL. This is over 2 years of multisecond tick data

Here is my Youtube video on this.

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!