Hi,
When I create a formula on excel (Mac) with the formula builder, it creates the formula but I do not obtain any result (even while pressing enter or refreshing).
Did it already happen to you ? how can I obtain results ?
Thank you for your help
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
21
●0 ●0 ●0
Just tried - I'm getting all the prices in Excel, example:
=RDP.Data("LVMH.PA","TR.PriceClose","Sdate=2005-01-01 EDate=2020-08-31 Curn=EUR CH=Fd RH=IN")
The best way to retrieve 44 equities is just cell reference them, here's an example of function:
=RDP.Data(U2:V2,"TR.PriceClose","SDate=2004-12-31 EDate=2020-10-31 Frq=D Curn=EUR CH=IN RH=date")
+ screen shot with results
21
●0 ●0 ●0
Hi Maxime,
can you please provide what instrument you have in that function? I've just tried to create the same function with MSFT.O and the data came through and I can see the Microsoft's share price.
1
●1 ●0 ●0
Hi Max, thanks for your answer.
it also works for me when I create the function for a single date or a time slot.I'm trying to obtain the closing price and market cap of LVMH.PA and 44 other stocks from the 1st of January 2005 to the 31st of August 2020.
Best
1
●1 ●0 ●0
It is the first time I use Eikon add-in on Mac... So, I'm sorry but it might be dumb
When I paste one or the other of those formula, I obtain this. What should I do?
Btw you can WhatsApp me +33647085072
21
●0 ●0 ●0
Can you please drop me a message to max.grigoryev@refinitiv.com? We can have a quick teams call.
