Tag Archives: CSV

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!

Best way to write and read flat CSV files in Microsoft dotnet C# with Protobuf

Best way to write and read flat CSV files in Microsoft dotnet C# with Protobuf

http://www.nuget.org/packages/protobuf-net

http://docs.nuget.org/docs/start-here/using-the-package-manager-console

Neat secrets from my ‘London quant’ friend …. join my FREE newsletter to learn programming secrets

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!

Exporting time series data to csv in R for quant development

Exporting time series data to csv in R for quant development

I am relatively new to R, but making progress learning. However, I met one challenge that so far I haven’t been able to overcome and I was wondering whether somebody here could help me.

I have done some work with time series and ended using the decompose() function. I would like to export this to a CSV so that I can import it into Excel or other tools. Unfortunately, a time series doesn’t seem to be a regular data frame and therefore I haven’t succeeded in exporting it with regular tools. Does anybody have a suggestion on how to approach this?

 
Convert the decompose() output in R to matrix format “output <- as.matrix(decompose.output)” and write it to csv format using “write.csv()”, though the suggested may not give you ready to use decompose outuput, but after some excel formatting/transposes the output can be obtained in useable format.

Added my two cents.

 

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 use Metatrader forex or stock data streaming for FREE! Export tick data to CSV text file to work with Matlab!

How to use MQL 4 / Metatrader 4 forex or stock data streaming for FREE! Export tick data to CSV text file to work with Matlab!

Here are the entire resources to get you started. This is very powerful for any cheap ass like me that wants quality data for nothing to be dumped into a CSV file. This includes your tick data. This is so powerful and has much potential! Let me know how you do!

Interaction between MetaTrader 4 and Matlab via CSV Files

http://articles.mql4.com/440

http://www.forex-tsd.com/metatrader-4/8512-matlab-mt4.html

Exporting tick data from MetaTrader

http://www.brokenpatterns.com/articles/mql4-export.html

Need I say more? Get hopping on this one.

Here is a video I just did:

 

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!