Search Results for :


Download Free Trial

 

Download qUtopic.xll, the help file and the license validation form, all compressed in a zip file, from the link below. You can try for free a fully functional version for 7 days. Or you can purchase a license here now.

 

Download Free Trial of qUtopic.xll

 

To install the qUtopic.xll, just extract all files to a folder, open Excel, add the file as an Add-In (File/Options/Add-ins/Excel Add-ins /Browse to find qUtopic.xll). If you are asked to make a copy say no (not big deal, but easier to uninstall). Or watch this 3-minutes  Video.


Help

Welcome to qUtopic XLL online help!

Here are some examples that we designed to test performance under different environments. They are simple but use intentionally complex queries to stress the add-in.

 


Functions to connect Excel with databases

excel2013-logo

qUtopic is a platform designed to help analysts and portfolio managers invest into hedge-funds and other actively managed funds. qUtopic is also a set of Excel functions designed to seamlessly include information from a database into your spreadsheet. Just leverage your expertise in using formulas to quickly grab the pieces of data you need. There is no need to use code or macros behind your spreadsheets. You only need to know your connection string and your query statement.

Create fund reports and connect them live to your data sources using just functions using qUtopic.

qUtopic is available as an Add-in for Microsoft Excel.

 

Follow us!



Flexible

We are ready to connect to any database via ODBC. That includes SQL Azure™.

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

Data_Flow2

 

 

 


Fast

Runs up to 20 times faster than conventional VBA code. qUtopic.xll™ has been coded in fully portable C++ 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.

Excel does not consider an XLL a macro, so 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.

 

 


Simple

Use the power of Excel function 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 place are needed. No more intermediate Query Tables, expensive VLOOKUPS, and extra Sheets.

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

Paste_Function


About

The idea

We decided to make qUtopic because we believe in an interconnected world.

The future is today. And we struggle to understand why in a world where planes and cars can be driven by themselves we still need to copy/paste from one window to another. Life is too valuable to spend it doing mechanical work that could be automated and simply avoided.

We believe in communication. We believe that talking is the basic way to connect. And we decided to make Excel talk to databases, affordably for everybody. Flexibly, fast and simply using “functions”, with 2 basic parameters: your connection string and your query.

You would probably appreciate if you are like one of us, who have been using spreadsheets to solve most of real life problems when you feel the pressure and the job needs be done no matter what.

If you also noticed that despite spreadsheets being the “de factokiller application since the PC was born, many vendors systematically attack them saying that are unsecure or data is in danger.

Perhaps.

Actually, it boils down on how we use spreadsheets. If you are careful enough to store your data in databases and use spreadsheets to only “consume” this data, you are going to have a clear advantage.

 

Our headquarters

We are a Swiss based company, and the product has been fully designed and programmed here under the highest standards and requirements. Our environment of excellence, peace and order have been extremely favourable in sparking creativity to find alternatives to well deserved costly manual work.

If you would like to have a chat with us, just contact using the following form. We are super busy working on our next release, but we will try to contact you as soon as possible.

Thank you for your interest!