I would like to have the list of broker's estimates for gold price this year and next year.
I have found the following TR field: TR.RealizedPriceGoldEstValue(Period=FY1) (definition: "The contributing broker's estimate (...). Realized Price - Gold is the average price received from sale of gold during the period")
How can I use this field?
Ideally the result should be something like this:
Estimate Units Period Brokers name Date estimate 1800 USD/troz CY0 ABC Securities 2021-06-25 1820 USD/troz CY0 XYZ Bank 2021-06-02 1900 USD/troz CY0 Bank of Country 2021-06-16 1910 USD/troz CY+1 ABC Securities 2021-06-25 1840 USD/troz CY+1 XYZ Bank 2021-06-02 1940 USD/troz CY+1 Bank of Country 2021-06-16
It can be either all estimates made in the last 30 days (including all estimates made by a certain broker if they have made more than one estimate in that period), or the latest estimates made by each of the available brokers.
I'm using Python.