Tag Archives: Yahoo Finance

xlq 6.1 for Microsoft Excel market data with Yahoo Finance

xlq 6.1 for Microsoft Excel market data with Yahoo Finance

This Excel add in is one of the only reasons why I would hang on to Windows

xlq 6.1 is available for download from http://www.qmatix.com/XLQ_Download.htm

 

What’s new:

 

Coinmarketcap

 

New formula =xlqPriceInBitcoin(), which can be used with CoinMarketCap to also return their prices in bitcoin. xlqPrice continues to return their US Dollar value.

A crash that could occur requesting data from CoinMarketCap has been eliminated.

Duplicate symbols are now handled by appending a number to those lower on the list

 

Yahoo

 

Yahoo day data handling has been modified to better handle bad data. Although some requests for cryptocurrencies can end up corrupting all data returned. Xlq will now detect this and if possible make corrections, and if it cannot will document the problem in the status view. The problem does not occur if no cryptocurrencies are requested.

 

It also includes extra checks and cleaning of yahoo data for European and Asian historic data where their downloaded date references are incorrect, apparently converting the returned date to a different time zone. For example Australian day data being referenced as Sunday to Thursday, and monthly as the month before (US symbols return a date of the 1st of the month, Europe and Asia will return the same data referenced as the last day of the prior month). Xlq will now look for the different problems in the data and correct the dates.

 

Compatibility change: Yahoo’s old download service returned the Forward Earnings per Share, which was returned via =xlqEarningsPerShare, they also return EPS estimates which they no longer do.

Their new service now returns “eps trailing 12 month” and “eps forward”. To maintain compatibility with the old service “eps forward” was originally returned. For this version “eps trailing 12 month” will now be returned via =xlqEarningsPerShare, and “eps forward” will be returned via =xlqEPSEstCurrentYear.

 

Other

 

New formulae xlqhAveVolume (+ week and month) has been added, calculated based on the preference settings. To avoid the need to specifically calculate one using the available xlqxh versions.

 

New preference setting for DMI/ADX allowing you to choose the calculation method (weighted (default) or EMA) for the xlqxh calculated versions. A separate preference setting remains for the xlqh versions.

 

Added the possibility for xlq to display a popup message concerning information on some recent event. The message will be displayed up to 5 times, unless dismissed and the functionality  may be disabled under general preference settings by changing “Enable Information Alerts” to no. As emails are only sent for new major releases and not minor builds, this method can now be used to notify of such updates and possibly other events such as a source outage, a breaking change etc. Messages will be kept to a minimum.

 

This version also includes numerous internal updates as well as updated  supporting libraries.

 

Note, many historic google requests rely more on the exchange being provided, e.g. if msft does not return data, use msft:Nasdaq etc. Examples in xlqDemo have been updated accordingly.

 

Installation

 

Note: If your license has expired, you will need to renew it in order for this new version to function. Before downloading and installing you can verify your license by right clicking on the Q in the task bar (while xlq is running) and choosing “About”. If the “Good for updates through” date is earlier than the release date, you should renew your license from this page:http://www.qmatix.com/XLQ_Purchase.htm. If your license has expired and you would like to purchase a new license to work with the latest release, please contact me for a discount.

 

This version requires Microsoft Visual C++ 2017 Redistributable, i.e. version 14.12.25810 (same as xlq 6.0), which if not yet installed will automatically be downloaded and installed. In such a case the installation process will require an internet connection and a reboot.

If the runtime libraries are not already on your computer, you could alternatively install them from the links on the site.

 

If you visit the site and do not see the new download, your web browser would be showing cached pages. Click refresh in your web browser (pressing ctrl at the same time if needed) and your web browser will show the latest contents.

 

Please email me (leov@qmatix.com)  or reply to this email if:

  • You would like to receive notifications when beta versions of xlq are available.
  • There is anything you would like improved in xlq, or any feature you would like to see.
  • You no longer wish to be notified of new releases.

 

Thank you for your continued 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!

How to Build a historical database with Yahoo Finance

quantlabsnet

How to Build a historical database with Google or Yahoo Finance

For some reason I got an old post from two years ago that suddenly people were reading. It is currently about how to build out a historical trading database with Yahoo finance as your source. This is somewhat very limiting to implement. However, I have even a better solution which is part of my video described below.

 

If you want to read about a potential way to build out a historical trading base at nost cost, read this

Demo of automated trading Positions management Python Script

 

As said earlier, I have a new video that demonstrates how to automatically manage your trading positions with various ways of calculating your market exits. There are numerous metrics that you can use including the ones that I demonstrate. There’s a simple chart generated for the trading automated stop losses as well as interaction with my NoSQL MongoDB database.

 

Check it out all here

 

Also, don’t forget I have a detailed source code walk-through on the script which is my longest one yet for this new upcoming automated trading system. All my Quant Elite members can get access to the source code as well as his video by going here.

 

I would say I am about 75% done for Phase 1 of this automated trading system course series. I’ll also be working out an itinerary later in the week. Due to time constraints that I have over the next while, I will be only most likely doing this a “one time” LIVE event. It will be recorded for those that do miss it but considering the value that you will receive, it is the most affordable that you will not get anywhere else online. As a result, I would highly encourage you to get my Quant Elite membership now!

 

Go here for immediate access

 

Thanks for reading

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!

Free Yahoo Finance options chain and World Bank data via Python

Free Yahoo Finance options chain and World Bank data via Python

I just discovered this interesting Pandas package for retrieving:

  1. Option chain data from Yahoo Finance
  2. World Bank economic data

If this works, I would consider it highly prized but I have not verified that yet

http://pandas.pydata.org/pandas-docs/version/0.15.1/remote_data.html

Join my FREE newsletter to learn more about using Yahoo Finance with Python

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!

Yahoo Finance option trading chain data via R

Yahoo Finance option trading chain data via R

Let’s hope this works since it says it was verified to work for this month

(I will verify with a video)

http://stackoverflow.com/questions/26537257/quantmod-getoptionchain-subscript-out-of-bounds-error

Missed code for the above example so don’t waste your time!

Update: http://finance.yahoo.com/q/op?s=AAPL+Options (http://www.reddit.com/r/algotrading/comments/2kq0qz/has_anyone_here_used_yql_to_download_yahoos/)

Still on the hunt to scrape

Join my FREE newsletter to learn about R and options 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!

Bitcoin was added as a forex asset for Yahoo Finance

Bitcoin was added as a forex asset for Yahoo Finance

CHeck it out as it was recently added under the symbol of

Bitcoin (BTCUSD=X)

Does it make it mainstream now?

Join my FREE newsletter to see if we would ever trade this currency 

 

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!

Intro to Card Stock for Real Time Yahoo Finance with database

Intro to Card Stock for Real Time Yahoo Finance with database

Be on the lookout for my ONE TIME ULTRA CHEAP Flash Sale of this with source code and video code walk through! It will happen early next week Mar 23 or 24 for 48 hours!

Get near Real-Time Stock Data From Yahoo Finance

Join my FREE newsletter when I announce this my community

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!

Dr Ernie Chan Answers to rank or weight a long or short of out this market sector according to Yahoo Finance

Dr Ernie Chan Answers to rank or weight a long or short of out this market sector according to Yahoo Finance

Question was asked at:

https://quantlabs.net/blog/2015/01/how-would-rank-or-weight-a-long-or-short-of-out-this-market-sector-according-to-yahoo-finance/

His answer was:

Hi Bryan,
There are various methods of including a subset of predictive
variables for returns prediction.
You can try stepwise regression, which picks successively the most
predictive variable in a linear regression, and stops when an
additional variable does improve R^2.
You can also try a regression tree, with a similar principle.
Both are available from Matlab Statistics toolbox.
Hope this helps!
Best,
Ernie

We won’t know a priori which piece of information is important, and what weight it should have.

 

Join my FREE newsletter to learn more about trading analytics

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!

According to Yahoo Finance, is this a fascinating explanation for why stocks are going higher

According to Yahoo Finance, is this a fascinating explanation for why stocks are going higher

From the NYC Contact but let me know what you think

http://finance.yahoo.com/blogs/talking-numbers/here-s-a-fascinating-explanation-for-why-stocks-are-going-higher-212653736.html

Join my FREE newsletter to learn what the best what way to learn

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!

From Yahoo Finance: This rare indicator is pointing to disaster

From Yahoo Finance: This rare indicator is pointing to disaster

I keep seeing these so now I am starting to think Chicken Little

From the NYC Contact so thanks to him: A warning not a guarantee!

http://finance.yahoo.com/blogs/talking-numbers/this-rare-indicator-is-pointing-to-disaster-225834766.html

Join my FREE newsletter to learn more about these Chicken Little moment indicators

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!

New video: Hooray I can finally get implied volatility from Yahoo Finance through Matlab

New video: Hooray I can finally get implied volatility from Yahoo Finance through Matlab

Finally I can calculate it via pure option chain data

Join my FREE newsletter to see my progress on this ystem internal system for 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!