Elevate Client Conversations with Model Portfolio Analytics from Your Digital Portal
In this recipe, we will demonstrate how FactSet’s APIs can be used to deliver dynamic meaningful analytics and high quality data from a vast content library to your digital portal.
First, we will translate any asset selection framework into a model portfolio. Next, we will calculate analytics including weights, characteristics, exposures, attribution, risk, and performance. Finally, we will enhance the derived analytics with your choice of relevant data including fundamentals, estimates, and pricing data from our Content APIs.
Steps
1Generate Model Portfolio
2Generate Analytics
3Enrich Analytics
4Populate Digital Portal
Recipe Details
1Generate Model Portfolio MODEL PORTFOLIO
Base URL: https://api.factset.com/analytics/accounts/v2/models
This family of APIs manages model holdings data for prospective portfolios.
- All Model Accounts will leverage FactSet’s Pricing and Analytics Sources
- The Model Portfolio API can only interact with Accounts generated from this API family
- You cannot modify an existing Model Account
PUT: /{Account Path}
Creates a new Model Portfolio Account. The request body can contain one or more date and symbol combinations. Optionally, you can include shares, prices and a currency ISO for each symbol.
DEL: /{Account Path}
Deletes the Model Account specified in the request URL.
2Generate Analytics PA ENGINE API
Base URL: https://api.factset.com/analytics
PA Engine API family allows you to request analytics with the flexibility to change accounts, benchmarks, groupings, columns, summary statistics and return periods from your request body.
- API request can be made asynchronously
- All tabular data is returned in FactSet’s Stach format
- All component ids are unique to each PA Document and report combination
POST: /engines/v2/calculations?
Request one or more calculations from FactSet’s PA Engine based on the parameters specified in the request body. The request can be made asynchronously by incrementing the request index inside of the body or you can submit multiple simultaneously. To retrieve analytics data from the PA Engine first, POST: the request JSON to the /calculations endpoint. Next, in a loop GET: the URL found in the location header. Once the request body status returns “Completed”, use the URL found in the pa/request index/result attribute to retrieve the analytics content.
GET: /lookups/v2/accounts/{Directory Path}
Returns all Account and Account Composites in the specified directory and its child directories.
GET: /lookups/v2/engines/pa/documents/{path}
Returns all PA3 documents in the specified directory and its child directories.
GET: /lookups/v2/engines/pa/components?document={Document}
Returns all Component Ids, names and categories for the PA3 Document.
GET: /lookups/v2/engines/pa/groups
Returns all available custom groupings.
GET: /lookups/v2/engines/pa/frequencies
Returns all available PA3 frequency ids.
3Enrich Analytics CONTENT APIS
Base URL: https://api.factset.com/content
FactSet’s suite of Content APIs are organized in a collection of content endpoints that enable you to quickly retrieve well defined and consistent data models. Our Content APIs include coverage from core company data such as fundamentals and estimates to unique data sets including supply chain and ownership.
POST: /factset-prices/v1/prices
Returns security prices, open, high, low, close, volume, and currency for a specified date range and frequency.
POST: /factset-prices/v1/dividends
Returns dividends paid out, received date and pay date for the specified date range.
POST: /factset-prices/v1/shares
Returns company level shares information. Commonly used with the prices endpoint to calculate market value.
POST: /factset-prices/v1/splits
Returns the date and split factor for the listed identifiers.
POST: /factset-estimates/v1/rolling-consensus
Provides consensus level estimates for income statement, balance sheet, cash flow, ratio and industry specific items for over 19,000 active companies globally.
POST: /factset-fundamentals/v1/fundamentals
Provides access to over 1,420 metrics sourced from annual and interim/quarterly data and detailed historical financial statements.
GET: /factset-fundamentals/v1/metrics
Returns the list of available metrics to be used with the FactSet Fundamentals endpoint.
4Populate Digital Portal
FactSet’s APIs returns data in concorded semi-structed JSONs. In addition, FactSet provides API Software Development Kits (SDK) in Java, .NET, Python and R. FactSet's SDKs simplify standard processes including creating authorization signatures, requests, error handling, and response parsing. Please refer to the FactSet Developer Portal for additional supporting documentation and sample code.