LSEG Financial Analytics (Preview)
The LSEG Analytics Power Platform connector is designed for financial services professionals such as traders, risk managers, and portfolio managers who want more integrations flexibility for their batch jobs or to create interfaces for filtering and aggregating data without needing to rely on development teams. The connector currently supports indicative data and pricing analytics on portfolios. You must have an LSEG Financial Analytics account to use this connector.
This connector is available in the following products and regions:
| Service | Class | Regions |
|---|---|---|
| Copilot Studio | Premium | All Power Automate regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Logic Apps | Standard | All Logic Apps regions except the following: - Azure Government regions - Azure China regions - US Department of Defense (DoD) |
| Power Apps | Premium | All Power Apps regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Power Automate | Premium | All Power Automate regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Contact | |
|---|---|
| Name | LSEG |
| URL | https://www.lseg.com/en |
| channels-powerplatform@lseg.com |
| Connector Metadata | |
|---|---|
| Publisher | LSEG Financial Analytics |
| Website | https://www.lseg.com/en |
| Privacy policy | https://www.lseg.com/en/policies/privacy-statement |
| Categories | Finance |
LSEG Financial Analytics Connector
The LSEG Financial Analytics Connector provides access to LSEG Financial Analytics inside Power Platform. The purpose of the connector is to make it easier for third-party citizen developers to access LSEG data and analytics exposed via LSEG Analytics APIs (e.g. YieldBook API).
Pre-requisites
- Access to Yield Book system
- Access to LSEG Financial Analytics system
- Access to Microsoft Power Automate
Supported Operations
Create job
Allows the creation of batch jobs.
Get job status
Add get job status action to the YB Job Automation connector.
Submit a bulk PY request
Add bulk PY action to the YB Job Automation connector.
Submit a bulk Indic request
Add bulk INDIC action to the YB Job Automation connector.
Upload securities list
Add upload securities list action to the YB Job Automation connector.
Close job
Add close job action to the YB Job Automation connector.
Retrieve bulk results
Retrieve bulk results for job.
Throttling Limits
| Name | Calls | Renewal Period |
|---|---|---|
| API calls per connection | 100 | 60 seconds |
Actions
| Close job |
Add close job action to the YB Job Automation connector. |
| Create job |
Create job. |
| Get job status |
Add get job status action to the YB Job Automation connector. |
| Retrieve bulk results |
Retrieve bulk results for job. |
| Submit a bulk Indic request |
Add bulk INDIC action to the YB Job Automation connector. |
| Submit a bulk PY request |
Add bulk PY action to the YB Job Automation connector. |
| Upload securities list |
Add upload securities list action to the YB Job Automation connector. |
Close job
Add close job action to the YB Job Automation connector.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Job name
|
Job name | True | string |
Name used to identify job. |
Create job
Create job.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Priority
|
priority | integer |
Value between -10 and 10 used to define the job priority. |
|
|
Job name
|
name | True | string |
Name used to identify job. |
Returns
- Body
- CreateJobResponse
Get job status
Add get job status action to the YB Job Automation connector.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Job name
|
Job name | True | string |
Name used to identify job. |
Returns
- Body
- JobStatusResponse
Retrieve bulk results
Retrieve bulk results for job.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Job name
|
Job name | True | string |
Name used to identify job. |
|
Output Format
|
Output Format | True | string |
Output Format. Allowed values: csv, json |
|
Fields
|
payload | True | string |
Fields to be included in results file. You can use json file content from 'Get file content'. |
Returns
Submit a bulk Indic request
Add bulk INDIC action to the YB Job Automation connector.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Job name
|
Job name | True | string |
Name used to identify job. |
|
Batch Size
|
Batch Size | True | integer |
Batch size |
|
Request ID
|
requestId | True | string |
ID generated when uploading securities list. |
Submit a bulk PY request
Add bulk PY action to the YB Job Automation connector.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Job name
|
Job name | True | string |
Name used to identify job. |
|
Batch Size
|
Batch Size | True | integer |
Number of securities to be processed concurrently. |
|
Request ID
|
requestId | True | string |
ID generated when uploading securities list. |
|
Curve type
|
curveType | True | string |
Yield Curve choice for the pricing setup. |
|
Currency
|
currency | string |
Currency choice for the Yield Curve. |
|
|
Pricing date
|
pricingDate | True | string |
The date that the prepayment model projections are based off of. |
|
Settlement type
|
settlementType | True | string |
The type of settlement used to define the settlement date. |
|
Prepay type
|
prepayType | True | string |
The type of prepayment model used. |
|
Prepay rate
|
prepayRate | integer |
The prepayment rate used. If default prepay type is used, default prepay rates will be used. |
|
|
Calculate partial durations (4pt)
|
calculatePartialDurations4pt | True | boolean |
Calculates partial durations for the 2, 5, 10, and 30 year points on the curve. |
|
Calculate partial durations (7pt)
|
calculatePartialDurations7pt | True | boolean |
Calculates partial durations for the 1, 2, 3, 5, 10, 20, and 30 year points on the curve. |
|
Retrieve model projections
|
retrieveModelProjections | True | boolean |
Retrieves the average CPR and PSA projected from the prepayment model used the price the bond. |
|
Retrieve OAS path
|
retrieveOas | boolean |
Retrieve OAS model path data. |
|
|
Option model
|
optionModel | string |
Select model for always returning OAS measures. OASEDUR is recommended, returns OAS and option adjusted measures. OAS returns CMO OAS only. |
Upload securities list
Add upload securities list action to the YB Job Automation connector.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Job name
|
Job name | True | string |
Name used to identify job. |
|
Securities list
|
securitiesList | True | string |
Securities in csv or json format. You can use file content from 'Get file contents'. |
Returns
Definitions
CreateJobResponse
| Name | Path | Type | Description |
|---|---|---|---|
|
Job name
|
name | string |
Name of the job created. |
|
Priority
|
priority | integer |
Priority of the job created. |
JobStatusResponse
| Name | Path | Type | Description |
|---|---|---|---|
|
Exit status
|
exitStatus | string |
Job status |
|
On hold
|
onHold | boolean |
Indicates whether the job is on hold |
RetrieveBulkResultsResponse
| Name | Path | Type | Description |
|---|---|---|---|
|
Results
|
results | string |
Result fields in csv or json format. |
UploadSecuritiesListDefaultResponse
| Name | Path | Type | Description |
|---|---|---|---|
|
Request ID
|
requestId | string |
ID generated when uploading securities list. |