EFAdrin: Boost your investment performance
EFADRIN is our buy-side SaaS platform. It sits at the heart of its customers’ front and middle office operations. It was born from the fact that every fund manager and family office creates and maintains a plethora of excel spreadsheets. Often these have been downloaded from other systems and then modified and then linked to real time data feeds using market data vendor add-ins. EFADRIN will take these spreadsheets and automate them for your team. We integrate directly with your prime broker collecting trade and custody data and help you reconcile it to your fund administrator on a daily or, more often, monthly basis. This reconciled trade data allows us to provide a shadow PMS from which we can help you track your ideas and target prices, analyze your performance, manage your risk better, and optimize your portfolio for enhanced performance.
Conversations with our customers often start with a particular problem spreadsheet. Maybe you have one which has some VBA code in it which was written by en employee who left and the code no longer works. Or you are in the process of putting together a new spreadsheet and it’s already taking you away from doing research and talking to brokers. And if you have analysts in your firm then for sure they have lots of spreadsheets which are hard to maintain. Now you have found the solution, it’s called EFADRIN.
End-to-end Investment Process
Every investment starts with an IDEA. EFADRIN begins its data capture & analysis at the idea generation stage of your investment process. Ideas are recorded in the system by your investment team when they are generated through a variety of user interfaces. Once an expected return has been calculated for the idea, this is also recorded in the system as a TARGET price and time frame. Ideas can be tagged with all attributes which are relevant to your specific investment process such as investment theme, strategy or framework allowing the platform to output performance and risk metrics a tailored to the needs of your team. EFADRIN also captures each TRADE, through direct integration with your prime broker and/or custodian, so it can track your portfolio as it evolves.
The foundation of good analysis is good data.
EFAdrin is built with a powerful “logic system” that validates all data it acquires in order to ensure correctness and consistency at all times.
Additionally, the data acquisition process is greatly simplified through integration with third party services, avoiding the need for multiple/ manual entries and the risk of errors that this incurs.
Whether you are using an off-the-shelf software solution to manage your orders and trades or you are doing it in a spreadsheet, EFAdrin will help you acquire good, clean:
- Trade Data
- Market Data
- Issuer Data
- Analyst Data
EASILY CAPTURE TRADE DATA
EFADRIN captures trade data through integration with your prime broker into its intelligent Trade Blotter tool. Once your middle office has verified the trade they book into a validated data store at the click of a button.
Our Validation process insures:
- internal consistency (eg: buying shares negatively impacts cash; the trade amount matches the quantity, price, exchange rates and fee entered)
- portfolio consistency (eg: you can’t sell stock you don’t have, and you can’t receive a dividend on it either)
- trade allocation by fund, strategy and any other attribute you prefer
SEAMLESSLY INCORPORATE MARKET DATA
Real-time market data from external sources such as BLOOMBERG is directly incorporated into EFAdrin modules in Excel.
Even if real-time data is not available (eg: you are viewing an EFAdrin module on the road, on a laptop without a Bloomberg Terminal) EFAdrin performs regular data retrievals from services such as Bloomberg Data Licence, so you can view your portfolio with only a short time delay.
If needed, you can trigger this price retrieval process directly from within any EFAdrin module, ensuring recent data even without a real-time connection.
EFADRIN allows easy portfolio monitoring and analysis with:-
- Portfolio Performance and P&L
- Risk Monitors
- Customizable Dashboards
- Any other spreadsheet you are currently using – we will automate it for you.
Adaptable To Existing Spreadsheets
EFAdrin was designed to be as flexible as possible and can therefore easily incorporate and work with your existing spreadsheets.
When your spreadsheets contain the required data, EFAdrin can be customized to fetch the necessary information, saving time and avoiding the process of having to manually input the information.
Live Data Update
Excel spreadsheets are populated and updated automatically with live market feeds such as Bloomberg.Tracking the fluctuations of the current portfolio is instant with EFAdrin and can help you make adjustments swiftly to meet portfolio objectives.
- Performance Attribution
- Return Decomposition Analysis
- Turnover Analysis
- Regression Analysis
- Stop Loss Analysis
- VAR Analysis
- Anything else you have previously created in a spreadsheet
At EFA, we believe that the power of good analytics is what drives performance.
The EFAdrin Performance Attribution Model reflects and explains performance decomposition in different markets and asset types. The system also allows users to evaluate the skills of management to provide added value relative to a benchmark.
Reconciliation + Reporting
Hedge Fund trading involves multiple parties,such as banks, brokers, custodians and administrators. EFAdrin can analyse and separate your data, providing reconciliation sheets fit to compare with your counter-party’s reports, for simplified comparison.
EFAdrin’s customization flexibility shines when it comes to preparing reports.
With EFAdrin, you can present the subset analysis that you want, the way you want it, over the time period that you desire.
- Daily Brokers Rec
- Daily Cash Rec
- Daily P&L
- Monthly P&L
- Administrator Rec
Who uses EFAdrin?