Reference Guide - Intelligence Reports

From SRP API Docs

You can use additional arguments for the following report queries:

/v1/intelreport/annualsales

/v1/intelreport/assetclass

/v1/intelreport/bestselling

/v1/intelreport/capitalprotection

/v1/intelreport/maturity

/v1/intelreport/monthlysales

/v1/intelreport/payoff

/v1/intelreport/topproducts

/v1/intelreport/topunderlying

/v1/intelreport/wrapperdetails

argument values default value include_non_retail yes; no no include_leverage yes; no no include_flow_and_others yes; no no

Single argument can be used:

e.g. https://api.structuredretailproducts.com/v1/intelreport/koproducts?market=MARKET_FILTER&include_non_retail=yes

Or multiple arguments:

e.g. https://api.structuredretailproducts.com/v1/intelreport/koproducts?market=MARKET_FILTER&include_non_retail=yes&include_leverage=yes

https://api.structuredretailproducts.com/v1/intelreport/koproducts?market=MARKET_FILTER&include_non_retail=yes&include_leverage=yes&include_flow_and_others=yes

Running the report queries without the additional arguments will provide a default result set (i.e. "no" value for include_non_retail; include_leverage; include_flow_and_others)

Please note: following reports do not use arguments, so are not applicable.

/v1/intelreport/koproducts

/v1/intelreport/maturingproducts




The API calls for the intelligence reports return aggregate numbers to give an overview of market trends for the previous month. Only market ID can be parametized. The volume sold - where visible - are all in USDm. The following reports are available:


Knockout products: https://api.structuredretailproducts.com/v1/intelreport/koproducts?market=MARKET_FILTER

The format of the XML response is as follow:

<maturing>

<status code="200">Success</status>

<list>

<maturing_product>

<product_id>5433936</product_id>

<provider_name>Meteor Asset Management</provider_name>

<product_name>FTSE Annual Income Kick-Out Plan - March 2013</product_name>

<maturity_date>2016-03-01</maturity_date>

</maturing_product>

</list>

</maturing>




Maturing products: https://api.structuredretailproducts.com/v1/intelreport/maturingproducts?market=MARKET_FILTER

The format of the XML response is as follow:

<maturing_next_6_months>

<status code="200">Success</status>

<list>

<maturing_product>

<strDatMaturityStrike>2016-03-01</strDatMaturityStrike>

<product_id>1454698</product_id>

<provider_name>Barclays Wealth</provider_name>

<product_name> Defined Returns Plan - Capital Protected Options - January 2010 Edition (6yr) </product_name>

<maturity_date/>

</maturing_product>

</list>

</maturing_next_6_months>




Top products: https://api.structuredretailproducts.com/v1/intelreport/topproducts?market=MARKET_FILTER

The format of the XML response is as follow:

<best_selling_last_2_months>

<status code="200">Success</status>

<list>

<best_selling_products>

<provider_name>Investec</provider_name>

<id_number>11741814</id_number>

<product_name> Dual Index Step Down Kick Out Plan 7 (Collateralised, Financial Institution Option) </product_name>

<volume_sold_usdm>9.41</volume_sold_usdm>

<strike_date>2016-01-04</strike_date>

</best_selling_products>

</list>

</best_selling_products>



Most popular wrappers: https://api.structuredretailproducts.com/v1/intelreport/wrapperdetails?market=MARKET_FILTER

The format of the XML response is as follow:

<wrapper_sales_volume_last_2_years>

<status code="200">Success</status>

<list>

<wrappers>

<wrapper_name>Medium Term Note, NISA, Pension</wrapper_name>

<year>2015</year>

<volume_sold_usdm>1036.67</volume_sold_usdm>

</wrappers>

</list>

</wrapper_sales_volume_last_2_years>



Best selling products: https://api.structuredretailproducts.com/v1/intelreport/bestselling?market=MARKET_FILTER

The format of the XML response is as follow:

<best_selling_products_last_2_years>

<status code="200">Success</status>

<list>

<best_selling_product>

<year>2015</year>

<provider>Standard Bank Offshore</provider>

<product_name>Deposit PLUS Issue 2 (AUD)</product_name>

<volume_sold_usdm>Not Public</volume_sold_usdm>

<strike_date>2015-05-27</strike_date>

</best_selling_product>

</list>

</best_selling_products_last_2_years>


Capital protection: https://api.structuredretailproducts.com/v1/intelreport/capitalprotection?market=MARKET_FILTER

The format of the XML response is as follow:

<capital_protection_last_5_years>

<status code="200">Success</status>

<list>

<capital_protection>

<capital>Equal to 100%</capital>

<year>2012</year>

<volume_sold_usdm>4038.62</volume_sold_usdm>

</capital_protection>

</list>

</capital_protection_last_5_years>




Most popular payoffs: https://api.structuredretailproducts.com/v1/intelreport/payoff?market=MARKET_FILTER

The format of the XML response is as follow:

<payoff_type_volume_last_3_years>

<status code="200">Success</status>

<list>

<payoffs>

<payoff_type>Knock Out, Protected Tracker</payoff_type>

<year>2014</year>

<volume_sold>1224.00</volume_sold>

</payoffs>

</list>

</payoff_type_volume_last_3_years>



Product terms: https://api.structuredretailproducts.com/v1/intelreport/maturity?market=MARKET_FILTER

The format of the XML response is as follow:

<volume_last_5_years>

<status code="200">Success</status>

<list>

<maturity>

<term_name>Medium Term (>2 and <=6 years)</term_name>

<year>2012</year>

<volume_sold>5679.28</volume_sold>

</maturity>

</list>

</volume_last_5_years>



Most popular underlyings: https://api.structuredretailproducts.com/v1/intelreport/topunderlying?market=MARKET_FILTER

The format of the XML response is as follow: <top_10_underlying_last_2_years>

<status code="200">Success</status>

<list>

<underlyings>

<underlying_name>FTSE100</underlying_name>

<year>2015</year>

<volume_sold_usdm>2025.98</volume_sold_usdm>

</underlyings>

</list>

</top_10_underlying_last_2_years>




Most popular asset classes: https://api.structuredretailproducts.com/v1/intelreport/assetclass?market=MARKET_FILTER

The format of the XML response is as follow:

<asset_class_last_2_years>

<status code="200">Success</status>

<list>

<asset_class>

<year>2015</year>

<asset_class>Equity (Single Index)</asset_class>

<volume_sold>2352.60</volume_sold>

</asset_class>

</list>

</asset_class_last_2_years>



Monthly sales: https://api.structuredretailproducts.com/v1/intelreport/monthlysales?market=MARKET_FILTER

The format of the XML response is as follow:

<monthly_sales_last_2_years>

<status code="200">Success</status>

<list>

<monthly_sales>

<striking_in>2014-Feb</striking_in>

<sales_usdm>211.26783442497</sales_usdm>

<no_of_products>33</no_of_products>

</monthly_sales>

</list>

</monthly_sales_last_2_years>



Annual sales: https://api.structuredretailproducts.com/v1/intelreport/annualsales?market=MARKET_FILTER

The format of the XML response is as follow:

<annual_sales_last_5_years>

<status code="200">Success</status>

<list>

<annual_sales>

<year>2012</year>

<type>Growth</type>

<issues>614</issues>

<volumes>7948.9966969517</volumes>

</annual_sales>

<annual_sales>

</list>

</annual_sales_last_5_years>