I have a question about the Eikon API and the way historical data requests are constructed using VBA.
It has to do with RIC/field combination. I have a sample sheet that requests historical data via VBA for all the RICS provided as long as I want the same field for all of them. I would like to use different fields for different RICS (eg EUROSTR=, Value and EURIBOR3MD=, Close) in the same request.
The code i was given creates a String of RICs contained in a range using the following loop:
For i = 1 To rngRICS.Count
RICList = RICList & rngRICS.Value2(1, i) & ";"
while the field is created as follows:
Fields = ".Timestamp;." & Range("Field").Value
I tried to create a Fields string the same way as the RICs field is created but it requests all the fields for all the RICS. In other words, it doesnt put Field1 in front of RC1, Field2 in front of RIC2 etc.
Could you help me strucure this the right way? Appologies if this is a basic question, I am new to Eikon.