Tag Archives: XLQ

New  XLQ for Bitcoin and Cyrptocurrency with Coinmarketcap access 

New  XLQ for Bitcoin and Cyrptocurrency with Coinmarketcap access

This can help with the industry data fro crypto currency from coinmarketcap

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

 

What’s new:

 

Coinmarketcap

 

Coinmarketcap is now available as a day source for cryptocurrencies, with their data being updated every 5 minutes. It works differently to other sources, in that once any symbol has been requested it will request the data for all their symbols, allowing you to see them in the day list, sort by rank etc. and paste to and monitor further in excel. With the install there is now a xlqcryprocurrencies.xlsx in the program files directory showing the additional formulae returning data from them, i.e.

xlqRank

xlq24hVolume

xlqMarketCapVal

xlqAvailableSupply

xlqTotalSupply

xlqMaxSupply

xlqPercentChange1h

xlqPercentChange24h

xlqPercentChange7day

 

Under xlq preferences / data source specific / Coinmarketcap you have options to:

– disable them as a datasource in xlq.

– store the data on exiting xlq.

 

Breaking change:

xlqMarketCap and xlqMarketCapMkt which returned the market cap as a string have been removed and are now replaced by xlqMarketCapVal. Data is returned from IQFeed, Yahoo and Coinmarketcap.

 

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 an updated Microsoft Visual C++ 2017 Redistributable, i.e. version 14.12.25810, 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.

 

64 bit version Dukascopy Forex tips with Bitcoin crypto addition

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!

DotNET CSharp demo XLQ data server using IQFeed market data

DotNET CSharp demo XLQ data server using IQFeed market data

Here is a reasons why I am ‘stuck’ on Windows for now Get the source code project here

xlqtest

http://www.qmatix.com/XLQ.htm

Join my FREE newsletter here for other cool source projects for automated trading 

 

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!

Latest XLQ Excel for automated trading

Latest XLQ Excel for automated trading

Here is the latest news on this powerful software

Join my FREE newsletter to learn more about using this software for automated trading analysis 

The website, initially updated in June, now also has additional pages to reference formulae, symbols etc. Click Resources at the top of the web pages.

In addition to www.qmatix.com, it is now also possible to access the same site from www.xlqplus.com or www.xlq.fr.

 

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.

 

Installation

 

The installation process has changed. XLQ is now built using Visual C++ 2015 (except for the XP version). Starting with Visual C++ 2015 Microsoft will include the c++ runtime libraries as part of the operating system, and should be including them as a patch in the future, but until then they need to be installed.

The install process will now check if they are present, and if not, will download them from Microsoft and install them. In such a case the installation process will require an internet connection and a reboot.

Once the runtime libraries are installed they would not need to be installed again in the future for xlq or another program requiring them.

 

If the runtime libraries are not already on your computer and you prefer to not have to reboot as part of the install, you can install them first from here:

https://www.microsoft.com/en-us/download/details.aspx?id=48145

 

New excel addin

 

For the last couple of years, I have been working on a new design and completely re-written interface with excel which is included in this version. The new design opens up many new possibilities for future versions, and already includes a number of enhancements, all with ensuring compatibility with any existing work. Other than internal processing having been redesigned and optimized, xlq now also has its own ribbon (i.e. for excel 2010 and later). Earlier versions will still have the menu and excel 97 is no longer supported. The ribbon now also includes a link to the help file.

 

If you use excels ‘insert function’ option, xlq functions are now broken down by category allowing you to select only day / intraday / range / xlqxh / historic weekly etc. And when you select a formula, or press fx on any cell containing one, a lot more information on the formula will be provided, including description, named parameters, which sources are supported and the license of xlq required etc. In addition, if you now click “help on this function”, you will be taken to associated help pages on the website.

 

All formulae can be used as per earlier versions, but there is now also a new way of entering a formula, i.e. with =xlqfx. Xlqfx allows you to wrap a request for any xlq formula, allowing you to pass the formulae itself as a cell reference. The format is =xlqfx(formula name, symbol, source, parameters…) with the parameters depending on the formula entered and the order being that of the formula itself.

e.g.

=xlqFx(“xlqprice”,”msft”,”yahoo”)

=xlqFx(“xlqhclose”,”msft”,”yahoo”,-1)

Used with a cell reference, i..e =xlqFx(R1,”msft”,”yahoo”,-1) allows you to quickly change columns of data to different formulae.

 

In addition to xlqfx, there is also xlqfxStatic. It is used in exactly the same way, i.e. =xlqFxStatic(“xlqhclose”,”msft”,”yahoo”,-1), but the data will only be re-requested again when alt-ctrl-f9 is pressed (or from vba when Application.CalculateFull is called). This can potentially be used in many different ways. e.g.

Complex workbooks can avoid unneeded calculations on data that rarely changes.

You can now have the data only update when you want.

Used with a timer and comparing xlqfxstatic results to xlqfx you could compare snapshot data with real-time data for example every 30 seconds etc., or compare changes since a specific moment.

A workbook that is opened containing xlqfxstatic formulae will not update them unless alt-ctrl-f9 is pressed which allows you to continue working with the old data, or if the workbook contains only xlqfxstatic formulae it will not try and connect with xlq until the refresh is requested.

Due to the way xlqfxstatic works it is also the recommended way of calling xlq formulae from vba. The VBA examples in the help file and aaiiMacro.xls have been updated to use xlqfxStatic.

 

XLQ Bridge

 

Working along with the new addin in excel is a new program, the xlqBridge, which will run in the background, being started and closed by excel as needed. It allows for a 3-way communication between excel and the xlq data engine allowing for a better workload distribution and avoids potential bottlenecks. Apart from the overall improvements and workbook load time (the workbook would need to be save with this version) it also virtually eliminates potential “server busy” errors or many reasons for #xlq being shown.

 

XLQ Engine

 

There are now new preference settings for each source (right click the Q and choose preferences, select data source specific and choose the source. Previous versions of xlq would maintain all symbols for ‘day data’ until deleted in the stock manager. You may now choose per source whether you would like the data kept or not. By default, the data is no longer kept, so if you would like it to work as per prior versions of xlq you would need to change these settings after installation. These settings are for day data / real-time symbols only and not for historic data.

 

In xlq preferences under general settings there are 2 new options

Delete all data on exit – once and delete all data on exit – always.

Previously if there was a data corruption or for housekeeping purposes you needed to manually delete the data files. You may now choose the ‘once’ option to delete the files on exit automatically whenever needed.

The Always option is not recommended but if you require that every time you start xlq there is no existing data stored, it is now possible.

 

Previously if excel crashed, or for whatever reason you needed to ‘kill’ the xlq engine you had to do so from the windows task manager, now it is possible to do a forced exit by right clicking the Q and pressing ctrl. If exit is greyed, it will be changed to ‘Force Exit!’ and enabled. It allows for xlq to be shut down properly even if there are connections to it, or a prior connection has crashed. It should only be used as needed.

 

“insufficient memory” error using the com interface has been fixed.

 

YieldLowAve7Y was missing from the AAII field list and is now supported

 

IQFeed

 

The real-time data from IQFeed has included ‘odd lot’ or non-qualifying data, which other sources would exclude. For example, small quantities that would not alter the last price or be included in volume.

This data is now excluded from xlqPrice etc. by default, but you can include them via a new xlq preference setting for iqfeed.

Regardless of whether you include or exclude them it is now possible to see the information separately with 3 new formulae

xlqPriceNonQualifying, xlqSizeNonQualifying and xlqTimeNonQualifying

If you now include the non-qualifying trades, they will also be included in the intraday (not backfill) which was not the case previously.

There is now also a new preference setting for iqfeed intraday that allows you to only update the intraday on new trades only, rather than on bid / ask changes etc. which is the default.

 

InteractiveBrokers

 

The following new formulae are supported:

xlqVolumeRate being volume per minute

xlqTradeRate being trades per minute

xlqNoOfTradesToday (also supported by IQFeed)

 

Google

 

Working with a different interface xlq can now request historic data for more than US equities. Any historic request including an exchange as part of the symbol will use this interface, allowing you to request data for indexes and non US stocks, e.g. for the dow DJI:INDEXDJX, Danske Bank Copenhagen DANSKE:CPH, Haseko Corporation Tokyo 1808:TYO

 

xlqCompanion

 

New column and field ‘Days G/(L)’ showing the $ amount gained or lost for a held symbol for the current day. To add the column, select it from the field chooser and drag it to where you want.

 

Additional Formulae

 

In addition to the new formulae mentioned above, xlqhValidDateOrNext has been added. This formula allows you to test a date to see if there is market data for that date. If the same date is returned it is a valid date, if not the following trading date is returned. Xlqhdate would return the prior trading day

e.g. =xlqhValidDateOrNext(“msft”,”1/1/2015″,”yahoo”) would return 2 January 2015 whereas

=xlqhDate(“msft”,”1/1/2015″,”yahoo”) would return 31 December 2014.

This allows you to easily determine the first trading day for a given week, month etc.

 

The money flow index is now supported with xlqhMoneyFlowRaw, xlqhMoneyFlowRatio and xlqhMoneyFlowIndex, along with xlqxh and intraday versions.

 

Other Changes

 

The original range formulae, i.e. xlqhHighestClose, LowestClose, HighestHigh, LowestLow, HighestCloseDate, LowestCloseDate, HighestHighDate, LowestLowDate, HighestVolume, LowestVolume, HighestVolumeDate, LowestVolumeDate have been renamed to correspond with newer range formulae, i.e. starting with xlqrh. If you are using these, you would need to do a global replace in your projects to change the name.

 

The help file and sample spreadsheets have been updated.

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!

Demo to stream Excel XLQ forex data into Matlab via FREE Yahoo Finance

Demo to stream Excel XLQ forex data into Matlab via FREE Yahoo Finance

This is pretty awesome and very very flexible but powerful for lazy people like me

Instructions :
Record your Excel macro
https://support.office.com/en-sg/article/Create-or-delete-a-macro-f3eb0fa3-4c18-498a-9235-c66ba8e78149

Start MATLAB from within the Excel Add in (see next link but can be automated)

http://www.mathworks.com/help/exlink/add-in-setup.html#bsu1116-1

Work with the Microsoft Visual Basic Editor
To enable Spreadsheet Link EX as a Reference in the Microsoft Visual Basic® Editor:
1. Open a Visual Basic session.
• If you are running Excel 2003, select Tools > Macro > Visual Basic Editor.
• If you are running Excel 2007 and later, click the Visual Basic button on the Developer tab, or press Alt+F11.
Note: For instructions about displaying the Developer tab, see Excel Help.
2. In the Visual Basic toolbar, select Tools > References.
3. In the References — VBA Project dialog box, select the SpreadsheetLinkEX or SpreadsheetLink2007_2010 check box.
4. Click OK.

VBA Code under Developer-Edit macro with automated scheduling every x seconds with refresh!:

Sub FXUpdateMatlab()
'
' FXUpdateMatlab Macro
' This runs FX check on list to populate into MATLAB

‘run every x seconds with refresh ozgrid.com/forum/showthread.php?t=77908
Application.OnTime Now + TimeValue(“00:00:10”), “FXUpdateMatlab”

ActiveWindow.ScrollWorkbookTabs Sheets:=1
ActiveWindow.ScrollWorkbookTabs Sheets:=1
Sheets(“Currency”).Select
Range(“A6:C13”).Select
MLPutMatrix “a”, Range(“A6:C13”) ‘http://www.mathworks.com/help/exlink/work-with-matlab-functions-in-microsoft-excel.html#bq8llit-1

ActiveWorkbook.RefreshAll

End Sub

Schedule the Macro to automatically run every x seconds or minutes via
http://www.ozgrid.com/forum/showthread.php?t=182559
http://stackoverflow.com/questions/24129613/using-excel-vba-macro-to-be-run-through-windows-schedule-task

Join my FREE if you are interested in learning other tricks with Matlab and Excel

YouTube Preview Image 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!

Using XLQ to get Yahoo Finance Bid and Ask in DotNet CSharp

Using XLQ to get Yahoo Finance Bid and Ask in DotNet CSharp

This is a very good tool to retrieve data so search it on my youtube.com/quantlabs channel.   You can retrieve multiple data sources including Yahoo Finance. Also, the coding is much simpler and cleaner than something like TWSLink or the Interactive Brokers API.

The Visual Studio solution package with source code is availabe to my Quant Elite members 

http://www.qmatix.com/

Join my FREE newsletter to learn more about how to retrieve data simply 

HIgher resolution version but you still need to make full screen.

YouTube Preview Image

Bad low resolution:

 

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 get free MSN Money with new data source with Morningstar newsfeed through XLQ and Excel for dot Net

How to get free MSN Money with new data source with Morningstar newsfeed through XLQ and Excel for dot Net

This is kind of exciting! More reasons on using XLQ. A message from the vendor:

SN rolled out a new version of their website yesterday (http://money.msn.com/common/now-on-msn-money-new-quote-data-pages), now supporting data from Morningstar.

 

This has not impacted historic data, but has broken the interface for day data. I am still working on the different changes and will announce a new release of xlq as soon as it is ready. There will also be other changes with the data, as symbols for currencies and options and some indexes are different.

Learn more how use MSN Money as your data source from my FREE newsletter

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!

I am currently putting XLQ on hold to be replaced with IQFeed developer C++ examples for market data inflow

I am currently putting XLQ on hold to be replaced with IQFeed developer C++ examples for market data inflow

These are more in depth as examples in XLQ are not detailed enough. I am not saying XLQ cannot do the job, the Excel front end is worth the money no doubt. It just seems the IQFeed developer examples in Visual C++ is more specific to my needs. So this IQFeed developer set will be the NEW inflow piece!

This is for my HFT system

Join QuantLabs.net Premium Membership for the last updates on my HFT system

or get my updates on my HFT development through my FREE newsletter 

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!

Youtube video Demo of Inflow XLQ for real time market data with IQFEED for Excel or Microsoft .NET and C#

Youtube video Demo of Inflow XLQ for real time market data with IQFEED for Excel or Microsoft .NET and C#

Join QuantLabs.net Premium Membership now to see these links

or get my updates on my HFT development through my FREE newsletter 

YouTube Preview Image

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!

Youtube video Demo of XLQ for Matlab Simulink inflow of real time market data from Yahoo, MSN, IQFeed with Excel, C++, C#

Youtube video Demo of XLQ for Matlab Simulink inflow of real time market data from Yahoo, MSN, IQFeed with Excel, C++, C#

Get on my free newsletter to see what I plan to do with this software

YouTube Preview Image

 

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 is the answer to stream data into my live trading HFT C++ environment with Excel or Microsoft .NET COM front end with IQFeed

Is XLQ the answer to stream data into my live trading HFT C++ environment with Excel or Microsoft .NET COM front end with IQFeed?

This thing looks pretty powerful for live trading with live market data coming in from IQFeed. This may work instead of developing my own code to get stuff working for a live trading environment. It could also save a lot of time and hassle as I have already experienced in the last week.

You may want to check it out at: http://www.qmatix.com/index.htm

See how I may implement this thing into my trading environment! Sign up to the free newsletter 

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!