Tag Archives: Microsoft

xlq 6.3 introducing xlq2 for Microsoft Excel with norgate data

This is from the vendor of this powerful software if you want access to various market data source. This includes Norgate data

 

xlq 6.3_2 is available for download from https://www.qmatix.com/XLQ_Download.htm

To learn more about xlq2 please visit: https://www.qmatix.com/xlq2.htm

 

This release has many new features, including 3 new sources (Norgate Data, IEX and Tiingo), a new subscription level and new data engine and well over 100 new formulae.

 

Introducing XLQ2

 

In addition to xlqPlus, xlq is now also available  as a new fully compatible data engine offered under a new subscription level called xlq2. Xlq2 has been in development since 2011. It was designed to handle more data and to allow for more to be done with the data simultaneously laying the groundwork for many new possibilities. Xlq2 is provided under a different license, requiring a valid license to run. xlqPlus will continue to be developed under the same pricing and licensing as before. Making use of the new engine, new data views etc. xlq2 supports 2 new data sources, Norgate Data (subscription) and IEX (free), with both bringing tons of new information.

 

Norgate Data brings a new level of reliable analysis with data back till the 1950’s, can be processed as adjusted for splits, or adjusted for splits and dividends, or unadjusted, or all 3 at the same time. Allowing you to work with delisted symbols, detailed dividend data, as well as with historic constituent information. In addition to covering US and Australian Equites and world wide indexes they also cover futures, forex and economic data. Their Norgate Data Updater manages the data on your computer. In addition to the historic data, over 150 extra data fields covering financials / fundamentals etc. are also available. (Norgate Data offer a free trial with limited data).

IEX

IEX data is free (historic and real-time snapshots), covers 5 years of data but brings many values previously unavailable including historic dividends, splits, earnings and financials, along with around 40 extra fields such as short interest, float, insider % etc.

 

COM interface has been updated to fully support xlq2. New request functions xlqHistString, xlqHistString1 and xlqHistNorgate have been added to cover requests returning string values or requiring additional string parameters.

 

There are around 50 new AAII custom  fields calculated on existing values and included in a new ‘xlq aaii custom formulae.xlsx’  with xlq2 (can also be applied for quarterly / yearly values).
It includes calculations such as for Net Operating Assets, Excess cash, NOPAT, NOPAT return on invested capital etc.

 

New views are available within xlq2 to cover the dividend data etc, as well as a NorgateData view offering quick access to their underlying data. A new historic period view allows for historic data to be viewed for multiple symbols for a specific period (day, week or month). Also for dividends or earnings for a given month. Filters may be applied to different columns.

 

Xlq2 remains fully compatible with all xlq functionality and all xlqPlus sources are also available.

 

If you would like to try xlq2 before upgrading or purchasing send me an email and I will provide a 3 week trial key.

 

Until the 31 December, a 50% discount will be provided to existing xlqPlus users allowing to purchase an upgrade for $70 instead of $140. (Enter XLQ270 in the discount / promotion fields when upgrading.) If you no longer have a valid xlqPlus license but wish to purchase xlq2, you may use the same discount code when purchasing and the $70 discount will be applied to the new license.

 

xlqPlus and xlq2

 

Tiingo is now available as a data source. Their data is either free or subscription depending on what and how much you need. In order to begin using Tiingo in xlq, you would need to have registered with them (free) and enter your token into xlq (via preferences). They provide real-time snapshots and historic data (adjusted for splits or splits and dividends back till 1960’s) covering US and Chinese equities and funds. They also provide cryptocurrency data (possible to view historic data covering only transactions for a specific pair).

 

IQFeed’s latest protocol is supported (requires iqconnect 6.0.0.4 or later)

 

Interactivebrokers, new preference setting for historic data to include or exclude extended trading hours. Separate setting for intraday backfill. (previously they were combined).

 

Yahoo new preference setting to ignore dates with 0 volume (other than indexes)

 

Supports CoinmarketCaps new interface (Since releasing this interface they have now chosen to stop supporting it as of December and have introduced a new pay for API. Given their change of policy and fees they demand, coinmarketcap will be removed when their current api stops working.)

 

Google has been removed as a source as they are no longer providing any download data.

 

Other

 

The website is now hosted on its own servers so there would be a performance improvement. It will also have a new SSL certificate, and the whole site has been moved over to being encrypted using https, including for crash reports. As a result crash reports from old versions will now be rejected. (crash reports from old versions are of little use due to code changes. It is recommended to use the latest version as the crash has likely already been fixed). The problem where larger crash reports fail to upload has also been eliminated.

 

I have now partnered with FastSpring for all order processing. Their secure processing, offering more local payment choices, is now better integrated with a more modern and sophisticated interface, allowing you to see pricing in local currency with taxes before selecting the order pages, as well as being able to choose to include an additional, or 2 additional years of updates with your purchase.

Also within xlq from the About dialog, you can now click renew (or upgrade if applicable) to go to the order page with your registration name and code pre-filled (with the information currently in xlq on your computer) avoiding the need to find the information beforehand.

 

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: https://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 version 14. 15.26706, 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.

 

Regards

 

Leo

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!

Microsoft Visual Studio Code enhanced for better Python programming

COUNTING DOWN TO THE LAST FEW DAYS!

I am winding down the LIMITED number of slots I will allow to get the current rate of my Python Algo Infrastructure Trading.

It is currently listed at $247 but may double going into EARLY next week.
Some have asked me about the content I will be adding to this:

Crypto currency additions learned lately including funding wallets and exchanges

Confirming your automated market or limit order

Confirming your Oanda connection for both Forex and CFD
trading (will work USA residents!)

JOIN Now
<<First Name>>,

This is how serious Microsoft is taking Python now to mebed it into Visual Studio.

 

https://www.theregister.co.uk/AMP/2018/07/20/microsoft_visual_studio_code_python/

 

I hardly see any languages from supporting Microsoft or any of their technology like .NET or SQL Server anymore on social media! I do think they are slowly becoming irrelevant compared to open source and their cloud competitors like Amazon AWS. Also, I have not even dare to mention any of their weird lockdown, backdoor potential with Windows 10, or any other bad corporate practices.

In order to enhance your future, you might want to look at Python as well especially if you are interested in topics like machine learning or algo/systematic trading.

Have I got a solution for you. We are entering into the last few days of this offer I explain above. My inteventory is getting low for this deal before I double the price!

We are coming down to the Wire over the LAST days
Promo Code
No expiration date
Shop 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!

Difference between debugging Python in FREE Microsoft Visual Code Studio versus Pycharm

Difference between debugging Python in FREE Microsoft Visual Code Studio versus Pycharm

Visual Studio Code advantages

Both IDEs (Integrated Development Environments) are free but PyCharm has bugs with no simple help. Just go with the Microsoft Visual Code Studio just for the Intellisense or debugging capabilities. I still prefer my Sublime and running the Python interpreter for quicker development.

Both IDEs will run on all operating systems including Linux, Windows, and Mac OS

 

Algo trading with forex and crypto currency using Python

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 create a Microsoft Office Word document from Python 3

How to create a Microsoft Office Word document from Python 3

Install this package called python-docx which is now available for Python.

Useful links I used

http://python-docx.readthedocs.io/en/latest/user/documents.html

http://python-docx.readthedocs.io/en/latest/user/quickstart.html

 

Chart Director trading 38 minute video added to Python 3 infrastructure course

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!
Microsoft

Do a code walkthrough on your operating system? Microsoft will have a Linux version

Do a code walkthrough on your operating system? Microsoft will have a Linux version

It looks like Microsoft is trying to create a small Linux for some cloud solution on Azure. Do you really still trust this software maker? They seem to embed all kinds of backdoors into their latest Windows 10. Ugh. There are all kind of security breaches if you looked on Youtube.

Hackers want to know you

If you are trying to trade live money on an account, I can assure you that hackers would love to know about you. As a result, I have always recommended better operating systems like a BSD (free UNIX) or Linux. I made a video about a week on this topic.

You can visit here to get more info on this topic.

https://quantlabs.net/blog/2018/04/intro-secure-os-openbsd-sexiest-manjaro-deepin-linux/

It will demonstrate Open BSD which is one of the most secure operating systems out there. The second most popular Linux distribution called Manjaro with a sexy graphical user interface like DeepIn is pretty to use. The distribution package manager looks very easy to use.

Lastly, I am quite surprised on how well my old legacy R course was quite popular. In case you missed it, here are the details:

I just posted this old legacy R course if you are interested. This include R code walkthrough. I have many posted on this language here 

Purchase here if interested

http://quantlabs.net/academy/buy-all-of-our-r-courses/

To be quite honest, I am quite surprised on how popular this seems to be among my site visitors.

Note that this is older version of R using version 2.15!

Here are the details with a video at this location

R Course with Technical Analysis

R Course with Technical Analysis

 

Module 1

Technical Analysis in R

 

Technical Analysis in R

Unit 1

30 day moving average function

Unit 2

2 sided moving average for mean rolling window

Unit 3

R Code Walkthrough Improved Moving Average using intra day for Forex data

Unit 4

The improved moving average

Unit 5

R Code Wakthrough Simple Moving Averag Strategy with Volatility Filter

Unit 6

Love level Improved Moving Average functions with testing code

Unit 7

R source code for trading script with update portfolio, position size, MA, cross over, SMA, optimize parameters pt 2

Unit 8

R source code for trading script including MACD, Omega performance, RSI, and Bollinger Band measuring strategy and portfolio performance with plots Pt 3

GARCH 

Module 1

Quant trading in R

 

Quant trading in R

Unit 1

Walthrough Parallel R Model Prediction Building and Analytics

Unit 2

Intro to GARCH forecasting with various R packages

Unit 3

How to use GARCH for predict market movements

Unit 4

How to use GARCH to predict distributions

Unit 5

GARCH trading R script walkthrough with a rolling window

R Course with Quant

R Course with Quant

 

Module 1

Intro

 

Intro

Unit 2

An ARMA model R code walkthrough

Unit 3

Checklist of forecasting with ARIMA: is time series stationary, differentiate, ARIMA(p,d,q), and which AMRA model to use?

Unit 4

R code walkthrough: Detrend to use Auto ARIMA modelling and forecast with statistical data and Ljung BoxTest

Unit 5

My first version of ARIMA R script with Forex data and Equity 1 and 5 min frequency

Unit 6

Bayesian analysis to Compare algorithms with Gibbs

Unit 7

Markov Chain R source code walkthrough

Unit 8

Monte Carlo R Walkthrough Demo

Unit 9

An alternative to running a Monte Carlo simulation

Unit 10

R code walkthrough Mean Absolute Deviation with Efficiency Frontiers Demo

R Course with Mean Reversion and Pair Trading

 

Module 1

Mean Reversion in R

 

Mean Reversion in R

Unit 1

Backtesting a Strategy with Mean Reversion

Unit 2

Mean Reversion Euler with Ornstein Uhlenbeck process

Unit 3

Pairs trading R source code walkthrough with mean reverting logic, spread and beta calculation

Module 2

Pair Trading in R

 

Pair Trading in R

Unit 1

Poor mans Pair Trading with Cointegration R Walkthrough

Unit 2

Pair trading with S&P 500 companies

Unit 3

Pairs trading with testing cointegration

Unit 4

Seasonal pair trading

Unit 5

 

Unit 6

Pairs Trading R Code Walkthrough

Unit 7

Pairs trading with a Hedge Ratio Demo

Unit 8

R Code Walkthrough Back testing with trading pair with CAPM

Unit 9

Gold versus Fear in Cointegration test

R Course with Arbitrage and Volatility

Arbitrage and Volatility

 

Module 1

Arbitrage in R

 

Arbitrage in R

Unit 1

Beating a random walk with arbitrage

Unit 2

Beating a random walk with arbitrage

Unit 3

Time Based Arbitrage Opportunities in Tick Data: Why low latency is needed in HFT?

Unit 4

Building a currency graph with arbitrage

Unit 5

Arbitrage: Modelling returns with CAPM APT aka Abritrage Pricing Theory

Unit 6

Indian equity market index NIFTY anaysis with CAPM vs APT aribitrage pricing theory using PCA and moment analysis

Module 2

Volatility in R

 

Volatility in R

Unit 1

R Code Walkthrough Adding a volatility filter with VIX

Unit 2

R Code Wakthrough Simple Moving Averag Strategy with Volatility Filter

Unit 3

Mean Reverting with Volatility Spike

Unit 4

Trading with GARCH volatility R script walkthrough demo

Unit 5

Jeff Augen volatility spike code

 

Reminder from yesterday. This closes out TONIGHT as well:

 

 

 

This is the your chance to learn about behind the scenes of these trading patterns I presented on Monday night. I have made this replay video now private which means it is only available to my Quant Elite Members. This is a very limited and exclusive offering to access it! I even revealed the source of how the Python code was created to generate them, This will never be seen again after this Friday! It is way too valuable that I don’t need the world to know how these work.

 

This posting will be removed this Friday night Eastern Standard Time (same as NYC)!

 

I Want To Learn Trading Patterns Now

Get your access to this via my 3 month Quant Elite Membership if interested!

 

Please find the upcoming new items I will be adding the next few months for this membership:

 

1. Live Q&A workshop bootcamp for the Python 3 Infrastructure Course for a Primitive Algo/Automtated Trading System

2. Packaged up course of using Dukascopy JForex API for automated forex and CFD trading. (this is partially done now with access for this membership)

3. Daily charting within the Quant Analytics service.

 

Here are the details with benefits of this trial membership

http://quantlabs.net/academy/introduction-quant-elite-membership/

 

REMEMBER: My patterns talk will be removed forever as of Friday!!!

 

Always remember I just created the online store for all other product and services.

I Want to Learn Trading Patterns Now

Please find the upcoming new items I will be adding the next few months for this membership:

 

1. Live Q&A workshop bootcamp for the Python 3 Infrastructure Course for a Primitive Algo/Automtated Trading System

2. Packaged up course of using Dukascopy JForex API for automated forex and CFD trading. (this is partially done now with access for this membership)

3. Daily charting within the Quant Analytics service.

 

Here are the details with benefits of this trial membership

http://quantlabs.net/academy/introduction-quant-elite-membership/

 

RMEMEBER: My patterns talk will be removed forever as of Friday!!!

 

Always remember I just created the online store for all other product and services.

P.S. Let me know if you are interested in an annual term as well.

Introducing trading patterns that work 50 to 60 percent with stop loss

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!

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.

 

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!