Search
× Search
Saturday, December 21, 2024

Archived Discussions

Recent member discussions

The Algorithmic Traders' Association prides itself on providing a forum for the publication and dissemination of its members' white papers, research, reflections, works in progress, and other contributions. Please Note that archive searches and some of our members' publications are reserved for members only, so please log in or sign up to gain the most from our members' contributions.

Are Microsoft tabular cubes a common technology for developing or implementing trading algorithms?

photo

 Theo Koumis, Freelance BI Consultant & Sports Gambling Entrepreneur

 Saturday, December 27, 2014

Are Microsoft tabular cubes a common technology for developing or implementing trading algorithms?


Print

4 comments on article "Are Microsoft tabular cubes a common technology for developing or implementing trading algorithms?"

photo

 private private,

 Sunday, December 28, 2014



I had to look up "tabular cubes." My question would be what would you use as sources?

Thanks, David


photo

 Theo Koumis, Freelance BI Consultant & Sports Gambling Entrepreneur

 Sunday, December 28, 2014



Models using Powerpivot (an Excel plugin) cubes can pull in and mash up data from multiple sources including Azure, XML feeds and ODBC databases.


photo

 private private,

 Sunday, December 28, 2014



I am not familiar with Azure. Would you be looking at price histories of equities?

Thanks, David


photo

 Theo Koumis, Freelance BI Consultant & Sports Gambling Entrepreneur

 Sunday, December 28, 2014



Azure is Microsoft cloud hosting and data storage product. To build the initial model you would require historical pricing data but I do not recommend building the model in Powerpivot as it's statistical functions are very limited although I have done it for some simple sports betting algos - see http://goo.gl/eaanFN as an example. But once the model has been developed in say Matlab then a Powerpivot cube is great for implementing the model. You can set up the rules/alerts as filters and slicers on a pivot table so when the data is refreshed any qualifying bets are displayed in the table. As Powerpivot resides in Excel, you can then use VBA to place the trades. So Powerpivot cubes are a great rapid application method for testing out strategies.

Please login or register to post comments.

TRADING FUTURES AND OPTIONS INVOLVES SUBSTANTIAL RISK OF LOSS AND IS NOT SUITABLE FOR ALL INVESTORS
Terms Of UsePrivacy StatementCopyright 2018 Algorithmic Traders Association