Daily Archives: March 14, 2014


Simple functions

Paste_FunctionUse the power of Excel functions to build rich and complex reports in minutes.

qUtopic delivers a set of functions that enable power users to extract pieces of data right to the places where are needed. No more intermediary Query Tables, expensive VLOOKUPS, and extra Sheets.

Every function is fully documented and expanded with constant updates online.

 


Fast database querying

Speed

Runs up to 20 times faster than conventional VBA code. qUtopic.xll™ has been coded in fully portable C++, with no dependencies on .NET, that makes it very light and extremely fast.

Excel interprets VBA code in real time every time it runs. An XLL is an add-in precompiled in a language with a very modest overhead. Only the libraries used are included. However, qUtopic is the ideal companion to increase speed and portability of your VBA project.

An XLL is not macro but a compiled add-in, so once after installation, it doesn’t require the user to change settings or give approval every time is used.

XLL technology has been available for decades with a prominent use in trading floors with strong quantitative requirements.

 


Flexibly connect to databases locally or in the cloud

Flexible

 

With qUtopic.xll you can connect your spreadsheet to any database via ODBC using functions. That includes SQL Azure™, which is SQL in the cloud, Oracle®, MySQL™, MS Access®, and website data in many formats. We are continuously developing our product to easily include all popular sources.

You can request data from multiple data sources in a single spreadsheet as long you know your connections string and have the adequate clearance. No need to create a connection file.


Fully documented

HelpEach function is fully documented and seamlessly integrated with Excel. Just hit F1 and you will be brought the requested topic.

Additionally, qUtopic hosts an online forum where matters are discussed more in detail and new examples and templates are posted constantly.


Monthly report template “Blue”

Template_Blue

If you are a fund management company in need to communicate your investment products’ periodic performance your most cost-effective answer is Excel®. You can produce a high-quality eye-catching report with a professional look for your clients and prospects.

The report format should be stable enough to convey a branding message, but with certain flexibility to be a real useful communication tool.

You would probably like to add your comments, news, awards, and even cutting dates for new subscriptions, but most of the things will remain constant. Some data is repeated exactly every period. We call that static data. And some other data changes as time passes by. We call this dynamic data.

The great part of this Excel template is that uses “dynamic data” from an SQL Server database.  In this case, we have posted data in the cloud so you can test the report.

If you open this report, with qUtopic.xll installed, you will see only one sheet in your workbook. On the left how this report will look like in the classic WISWIG way and on the right all the data used.

We used blue to mark static input data, green locally calculated data, and orange data obtained from a database with qUtopic functions.

Take a look to the template! It’s free.


Cross-correlation template

CrossCorrelation01

Up to 250 x 250 instruments in a single correlation matrix. Each cell takes the value of the correlation between the instrument in the row and in the column displaying a numbers between -1 and 1. Then the matrix is coloured using red for 1 or high correlation, yellow for 0 or no-correlation, and green for -1 or uncorrelation.

 


Try Adventure Works with Azure

AdventureWorksAzure

In this example you can test how fast Excel could be dealing with 20,000 contact names coming from Azure. The spreadsheet uses a list of names obtained using the statement SELECT FirstName, LastName AS Name FROM Person.Person ORDER BY FirstName directly from then AdventureWorks2012 database.

Then using a ComboBox, which is a standard ActiveX control, you can choose one of those names to, in turn, feed another formula that gets details of that contact.


Technical specifications


Version of MS Excel® Excel 2007 (v12.0)  and newer
MS Excel® architecture 32-bit only
Windows® Windows Vista®
Windows XP®
Windows 7®
Windows 8®
Windows architecture 32-bit / 64-bit*
Disk space  Less than 1Mb
Connectivity ODBC
Web Services
Through ODBC MS SQL®, Oracle®, MS Access®
Data parsing String separator for columns and rows
JSON **
XML***
Execute views Yes
Execute Store Procedures Yes
Take Parameters Yes
Cache in memory Yes
Connection pooling Yes
* Requires admin rights to run installation.
** Limited to one level, no nesting.
*** Only lines to rows.