A Comprehensive Data and Analysis Platform for a Global Hedge Fund

Philip Zecher

EQA Partners, LP

Legal Disclaimer

EQA Partners, LP (“EQA”) does not provide investment services of any kind to the public.  No investment advice or investment securities or other investment opportunities of any kind are intended to be offered in this document.  Investments in the Funds managed by EQA are offered only privately to qualified investors and only through a confidential Private Placement Memorandum or comparable document.  Any investment decision should be based on a careful review of such document which would contain a detailed description of EQA’s investment strategy and the applicable risk, fees and expenses.

The information contained in this presentation (including any expression of opinion or forecast) is hypothetical, is provided for informational purposes only and may be derived from sources which EQA reasonably believes to be reliable, but such data has not been independently confirmed and EQA makes no representation or warranty is made as to its accuracy or completeness.  To the fullest extent permitted by applicable law, EQA and its affiliates expressly disclaim any and all liability whatsoever for errors and omissions in any information, and for any use or interpretation by others of any information, contained herein.  

No part of this presentation may be redistributed in whole or in part or transmitted in any form or by any means without the express prior written consent of EQA.  © 2009, EQA Partners, LP.  All rights reserved.

Organization & Functions of a Hedge Fund

Organization & Functions of a Hedge Fund

Organization & Functions of a Hedge Fund

User Interaction

Traders, Risk Group, Research Group, Marketing, Back Office (Fund Administration), Senior Management, Administrative Staff, Marketing, Investor Relations, Clients -- Everyone

Traders, Marketing, Back Office, Markting, Investor Relations

Risk Group, Research Group, Back Office

The EQA Package

<<EQA`

Select[$Packages,StringMatchQ[#,"EQA`*"]&]//TableForm

Plus others that manage specific tasks, e.g. trading, back-office functions, web support

Business Objects

To query the current positions for a particular day in a portfolio requires:

2 SQL queries, from

5 different tables, with

5 table join conditions.

select futures_activity.contract_id, name, futures_activity.currency_code, net_position, avg_price, factor_code, future_contract.tick_size, future_contract.tick_value 
from position.futures_activity, instrument.future, model.factor_security, instrument.future_contract 
where futures_activity.exchange_code = future.exchange_code and 
futures_activity.symbol = future.symbol and 
futures_activity.exchange_code = factor_security.exchange_code and 
futures_activity.symbol = factor_security.symbol and 
futures_activity.contract_id = future_contract.contract_id and 
position_date = {d '2009-2-10'} and portfolio_code = 'Example'

ConnectToEQA[];

Get["EQA`Instruments`"]

EQAPortfolio["Example",{2009,2,10},"Trades"]  // TableForm

ValueSecurity[%,{2009,2,10}]

CurrencyRates["BMBG",{2009,2,10}]

%% /. %

EQAModel[{2009,2,10},"FUNDAMENTAL","Example"]

(Sqrt[52])(Sqrt[ModelWeights . ModelCovariance . ModelWeights])/.%

EQAPortfolio["Example", {2009,2,10}, "Factors"]

EQAPortfolio["Example",{2009,2,10},"Positions"]

EQAPortfolio["Example", {2009,2,10},"VAR"]