Tag Archives: query

Contact me now though Zenadesk for support or query only for this reason

Contact me now though Zendesk for support or query only for this reason

 

I get overwhelmed easily from too many queries. There are numerous choices now here for you

https://quantlabs.net/analytics/analytics-support/

 

 

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!

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!

Answers to a Deficient trading database query

Answers to a Deficient trading database query

I sent out my trading database with a mention in a recent Meetup webinar I hosted. A query came up from a Meetup follower:

I reviewed your test database and I have few comments.
1) have you considered normalizing the various security tables into a single table? The benefit will be realized once you need to deal with a common object which contains multiple instrument/security type. for example portfolio table. I have the design and I can send you the high level schema.
First, as I mentioned in my Meetup, this database is a lazy quick & dirty way to implement something to get it working so keep that in mind. I have seen quite a number of database schemas but please send it out.
2) How do you deal with the variety of tickers assigned to the same security. Example: Google or Yahoo can assign different ticker to the same index.
The best way to treat each security in its own table for optimal performance
3) can you point me o a sample code which provide new ticker for IPO.  Currently I use a process which inserts into the database new tickers only at the End of trading day. This is done only once my program realizes that a new ticker is in the daily feed, but does not exist in the ticker list.   I prefer to be pre-emptive and detect IPO ahead of time, not after the fact.
These are hard to find. As mentioned, I would think maybe IQFeed has it in their news where you need to filter. I am sure there maybe there are some online databases if you search via Google.
You mentioned that IB is providing such an IPO feed.  However, I’m looking for a free feed.
Thanks to him for asking

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!

ARIMA math query on forecasting rainfall

ARIMA math query on forecasting rainfall

I got this comment on a video which is below

i have 10 year rainfall data. and have categorized it as high rainfall, low rainfall, av. rainfall. can u tell me how to predict rainfall for next year or next few year

Answer at my Facebook groups:

https://www.facebook.com/groups/quantlabsnet/

or

https://www.facebook.com/quantlabsnet

Join my FREE newsletter group to get math questions answered like 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!

Whao. New Facebook open source C++ osquery database looks cool to query your Apple Mac OSX or Linux OS in real time

Whao. New Facebook open source C++  osquery database looks cool to query your Apple Mac OSX or Linux OS in real time

This includes a full exlanation, C++ source code and even video

Smart, I even been hearing how you can even use DLLs for real time and dynamic generation. Very cool stuff indeed.

Facebook open sources project that lets you view your OS as a relational database

https://code.facebook.com/posts/844436395567983/introducing-osquery/

https://code.facebook.com/projects/658950180885092

http://osquery.io/

Join my FREE newsletter to see some neat programming tricks like 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!

Matlab query of PostGreSQL SQL database will generate long and short of spread trading idea

Matlab query of PostGreSQL SQL database to generate long and short of spread trading idea

Hooray another milestone is upon us.

IMPORTANT: The limiting factor is that Yahoo could limit the number of queries I run using this method so I may be forced to used a pro subscriber news data feed.
Watch this video to understand how you should be able to use database queries (and at the same generate your market metrics queries from Yahoo Finance) to sort the long and short. This should work in theory depending on the number of trading ideas I use and the number of assets requested within a certain market sector. – See more

I also posted the SQL and Excel files here but do not that this is more my members. I will save you at least 6 hours even if you were considered an expert at SQL and databases.

Go here for that if interested.

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!

Matlab query of PostGreSQL SQL database to generate long and short of spread trading idea

Matlab query of PostGreSQL SQL database to generate long and short of spread trading idea

Hooray another milestone is upon us.

IMPORTANT: The limiting factor is that Yahoo could limit the number of queries I run using this method so I may be forced to used a pro susbcriber news data feed.

Wathc this video to understand howy you should be able to use database queries (and at the same generate your market metrics queries from Yahoo Finance) to sort the long and short. This should work in theory depending on the number of trading ideas I use and the number of assets requested within a certain market sector.

Join my FREE newsletter to see how this gets accomplished

NOTE: I have posted the SQL and original Excel file to get you started to save probably 6 hours of my own time researching this

whole process

Join here to get access

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!

Video on Matlab query of parallel computing with RSI and Moving Average using High frequency trading HFT tick data

Video on Matlab query of parallel computing with RSI and Moving Average using High frequency trading HFT tick data

Question from a visitor:

Hi there, I watched you Youtube video, and you referred to the Mathworks webinar (algorithmic trading webinar). You said it takes couple of seconds using parallel computing, however on a quad core machine for HFT data, like you were talking about it would take several days for optimization using RSI or even mov avg

Best answer from:

http://quantlabs.net/quant-member-benefits/hot-hft-high-frequency-trading-tips-and-tricks/

My answer is:

 

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!

Help this guy out resolve his big data set query for quant purposes

Help this guy out resolve his big data set query for quant purposes

Can you give this reader a hand in finding an answer for his query:

Hi Nagendra,

I think a chunk is a piece of data in the over all file. For ex: a 100 MB file can be split into a 10 chunks of data with each chunk containing 10 MB. Second part of your question, even I am not sure and I have the same question as well.

Looking forward to Hadoop experts help us in understanding this.

Regards,
Phani

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!