question

Upvotes
Accepted
1 0 0 0

How to get the value of field "TR.FundLaunchDate" via API PLAYGROUND using searchlight or lookup or another endpoint ?

How to get the value of field "TR.FundLaunchDate" via API PLAYGROUND using searchlight or lookup or another endpoint ?


For example I use this EndPoint :

https://api.refinitiv.com/discovery/searchlight/v1/

with this Body Request

{

"View": "FundQuotes",

"Filter": "(AssetState ne 'DC' and (RCSIssuerDomicileCountry xeq 'G:5M' and {0}(ExchangeName xeq 'Lipper')))",

"Boost": "AssetState ne 'DC'",

"Select": "IssuerCommonName,IssueISIN,IssuerCountry,Currency,FundLaunchDate,IssuerAdvisorCommonName,RIC,SEDOL,TickerSymbol,AssetStateName,InstrumentPermID",

"Top": 100000

}


The result is :

{

"Warnings": [

"1 invalid 'select' entry was ignored: [FundLaunchDate]"

],

"Total": 8030,

"Hits": [

{

"IssuerCommonName": "Ofi Invest ESG European Convertible Bond RC",

"IssueISIN": "FR0013275138",

"IssuerCountry": "FRA",

"Currency": "EUR",

"IssuerAdvisorCommonName": "Ofi Invest Asset Management",

"RIC": "LP68574282",

"AssetStateName": "Active",

"InstrumentPermID": "18068574282"

},

.......


BUT I don't have the FundLaunchDate field value ?


Can you help me?





#technologyfieldsendpointapi-playground
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
Accepted
7.2k 18 2 8

Hi @FR-SVC-RefinitiveTST ,

The field you are looking is not available under FundQuotes view. You can check available fields via this endpoint -https://api.refinitiv.com/discovery/searchlight/v1/metadata/views/FundQuotes

Once you have the RICs of the funds from Search request, then you may use Datagrid endpoint here - API Playground (refinitiv.com) to get the TR.FundLaunchDate.

Hope this helps.


Best regards,

Haykaz

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Hello Haykaz

thank you for your quick reply


I saw that the field was not available in the "FundQuotes" view


BUT


When I try the "datagrid" entry point it looks like execution is disabled????


Would I have a contract problem?


Can I find this field value in another End Point?


Sorry for poor English word

Best Regards

Thierrycapture.png

capture1.png

capture.png (90.2 KiB)
capture1.png (25.8 KiB)
Upvotes
7.2k 18 2 8

HI @FR-SVC-RefinitiveTST ,


That typically means you don't have access to that endpoint, you may need to speak to you Account manager around that.

On a different note, why not you using our Python libraries for your request? See an example workflow with Refinitiv Data Libraries for Python:

1. Get the fund RICs using Search

df = rd.discovery.search(
    view = rd.discovery.Views.FUND_QUOTES,
    filter  = "AssetState ne 'DC' and (RCSIssuerDomicileCountry xeq 'G:5M' and (ExchangeName xeq 'Lipper'))",
                   boost  = "AssetState ne 'DC'",
                   select=  "IssuerCommonName,IssueISIN,IssuerCountry,Currency,FundLaunchDate,IssuerAdvisorCommonName,RIC,SEDOL,TickerSymbol,AssetStateName,InstrumentPermID",
    top = 10000)
df

screenshot-2024-07-09-at-150716.png

2. Get the launch date:

rd.get_data(universe = df['RIC'].to_list()[:10], fields = 'TR.FundLaunchDate')

screenshot-2024-07-09-at-150731.png

You can also use Codebook app inside LSEG Workspace for a QuickStart and examples.


Hope this helps and let me know if any further questions.


Best regards,

Haykaz


icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.