We are currently integrating LSEG data into Power BI and would appreciate your assistance in confirming the correct system field names required to retrieve the expected values.
At present, we are only able to retrieve RIC and TR.Close. However, we require the correct field identifiers for the following data points:
- Currency = CF_CURR
- Net Change = CF_CHNG
- Percentage Change = PCTCHNG
- Last Price (Spot) = CF_LAST
- Name = CF_NAME
The values we are currently retrieving in Power BI do align with the expected outputs (as shown in the screenshots we have). It would be helpful if you could confirm:
- The correct field names to use for each of the above data points
- Whether additional permissions, packages, or syntax are required to access these fields via Power BI
- Any documentation or guidance on best practices for pulling these fields
Please let us know if you need any additional details from our side.
Thank you in advance for your support.
Expected fields:
What's retrievable: