-
PLVApi.Dll
Hi, I'm trying to run VBA code written by someone else, in Excel. I have the Workspace Add In running, and logged in. When I run the VBA code, I get this error message: This dll indeed does not exist in the path indicated in the error window. I thought it might be elsewhere, but I cannot find it in my PC. I looked in the…
-
How to calculate historical Forward Rates for SOFR with RDP in Python?
Currently the client is using AdRateConv on EIKON Excel, however, this formula is not supported on Workspace. The client requests replacement either WS Excel or Python. Could you kindly suport it?
-
How to translate adfin formula for previous coupon date in API?
How to translate adfin formula for previous coupon date in API? =CpnPrev(TODAY(),TR($B3,"TR.ADF_MATDATE"),TR($B3,"TR.ADF_BONDSTRUCTURE")) B3 is the Bond e.g. XS1970549561
-
Can python to download TR.YieldtoCallDateAnalytics & TR.DiscountMarginAnalytics?
Hi team, Can python to download TR.YieldtoCallDateAnalytics & TR.DiscountMarginAnalytics? If so, could provide sample code. If no, is it any workaround it codebook? thanks. Regards, Sunny
-
Excel function AdFxSwpToDep equivalent in EMAJ
I am migrating the excel application to a java application, the Refinitive API part I am using EMAJ in my application. However I have no idea how to use EMAJ to replace the below function call in Excel. Anyone has any ideas please ? =AdFxSwpToDep(CalcDate, PeriodArray, Cur1Cur2, Spot1BA, Spot2BA , Swp1Array, Swp2Array,…
-
Hi, anyone familiar with execution error: DfaddPeriod method of "AdxDateModule" object failed? Th...
...anks! Error is after upgrading to eikon 4.0.57. Still works on 4.0.53. execution error: DfaddPeriod method of "AdxDateModule" object failed Anyone familiar with this error? Thanks!
-
Get RIC for the largest 10 companies in each stock market
I was trying to get the largest 10 companies with respect to the market cap each year for a list of countries over a particular time period. I use a loop like this: country = ["IR","NL"] for i in country: for j in range(2000,2006,5): Start=str(j)+'-12-31' instruments = 'SCREEN(U(IN(Equity(active or…
-
How to add missing AdxRtHistory library VBA?
Hi, I did nothing else but downloaded the Tutorial 5 - AdxRtHistory.xlsm. It used to work last week, but now I get an Error "MISSING: AdfinX Real Time 6,0 Library". I tried to add smth like "adfin" from Program Files (86), but nothing helps. Could you please suggest how I add this library to my VBA so that a basic Example…
-
Adfinx Real Time returns nothing
Hi, I want to retrieve historical time series and real time data using Excel VBA. I downloaded the "Complete Microsoft Office APIs Tutorial Samples". Adfinx Real Time functions such as AdxRtList, AdxRtHistory are not working. It is returning "Run time error 91: Object variable or With block variable not set". Other…
-
how to use and test local mode of EikonDesktopDataAPI
I'm reading the COM API about how to handle the connection to Thomsen Reuters Platform and found the following information about local model. Since I only use some calculation functions of AdfinX and would like use it to avoid system outage. The question is how to use, test or "simulate" the case? EEikonStatus This…
-
Adfin function DfAdjustToWD doesn't refresh
I have a sheet which has in-cell formula calls to adfin functions eg. =DfAdjustToWD(A2,TDY,-1). When the sheet is opened and it starts a automatic logging in, the adfin cell shows "Not Singed In" and doesn't refresh even after logging in. This "Not Singed In" doesn't go away even after going to "Thomson Reuters Tab" and…
-
Eikonn AdfinXAnalytics volatility error
Hello : Im trying to calculate a volatility using Interop.AdfinXAnalytics with one of the exercise in the developer's book in c# When i try to Attach the Volatility to the Asset object i get the following error: System.Runtime.InteropServices.COMException: 'Undefined error : missing or invalid resource' i can't figure out…
-
Adfin Real-Time Source guide
Hello, i am using AdfinX Real Time connection for fetching some fund values like CF_DATE. The default source is the "IDN" when i try to get the specific value for fund RIC like this LP60099809^C19 it is not working, but if i try to get one without the ^** it is working. Can you tell me if there is another better source to…
-
What is the 140 / "Adfin" application in DACS / TREP
I see some TREP connections identifying as application 140 ("Adfin" which DACS database describes as "Eikon Excel or PowerPlus Pro"), but other Excel add-in connections seem to use 56 "Eikon/Kobra". What's the difference, and can I make all Eikon components identify as 56? I'm planning to implement MIP, and it's a lot of…
-
VBA AdfinX Real Time Error Message ERROR #360f
I'm using VBA and the COM API to retrieve closing prices (CL_CLOSE). Here is a code snippet: With myRTList .ErrorMode = DialogBox .Source = "IDN" .RegisterItems ricString, "CF_CLOSE" .StartUpdates RT_MODE_ONUPDATE End With The variable ricString is a string with many instrument RICs (e.g "DBKGn.DE,BMWG.DE,BMWG_p.DE") It…
