Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
aleksei.shvetsov avatar image
1 ●2 ●3 ●3

How do I get data for holidays and weekends in Excel VBA via RHistoryAPI

Hi,

I use the Basic AdxHistory.xlsm Makro in order to download daily closing price for some instrument. I get only the dates, when the price was published. However, I need the complete time series, where holidays and weekends are also present. What do I do? I would expect the .Mode property, but it does not help. Small example how I want to see it:

Friday - 100

Saturday - NA

Sunday - NA

Monday - 110

Instead I see:

Friday - 100

Monday - 110


Here is the macro.


Option Explicit

Dim WithEvents myAdxRtHist As AdfinXRtLib.AdxRtHistory

'*********INTERDAY*********************
Private Sub cmdGetInterday_Click()
Dim arrFlds() As Variant

ActiveCell.Select

' Note the use of CreateReutersObject - function in the PLVbaApis module.
If myAdxRtHist Is Nothing Then Set myAdxRtHist = CreateReutersObject("AdfinXRtLib.AdxRtHistory")

On Error GoTo errHndlr
With myAdxRtHist
.FlushData
.ErrorMode = EXCEPTION ' EXCEPTION, DialogBox, NO_EXCEPTION
.Source = "IDN"
.ItemName = [C7].Value
.Mode = [H8].Value
.RequestHistory ("DATE,CLOSE") 'NOTE USE OF OLD FIELD NAMES, NOT ("TRDPRC_1.TIMESTAMP,TRDPRC_1.CLOSE,TRDPRC_1.VOLUME")

'arrFlds = Array("DATE","CLOSE","VOLUME")
'.RequestHistory ()arrFlds
'.RequestHistory ("*") ' "*" requests all fields.
End With
Exit Sub

errHndlr:
[F13].Value = Err.Number & " " & Err.Description
End Sub

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apieikon-com-apivba
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

pimchaya.wongrukun01 avatar image   pimchaya.wongrukun01

Hello @aleksei.shvetsov

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?

If yes, please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

AHS

Alex Putkov.1 avatar image   Alex Putkov.1

@aleksei.shvetsov

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

-AHS

3 Answers

· Write an Answer
Upvote
Accepted
Richard.Lyons1 avatar image
42 ●1 ●0 ●2

@aleksei.shvetsov

Your code is referencing the AdfinX history module. I think you need to use the RHistory API, which has the same parameters and arguments as the RHistory function; you can then specify NULL:NA and DAY:A to get a table like this (which is, I think, what you want to achieve):


1592996225969.png (30.8 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvote
SupDev1 avatar image
4.1k ●4 ●7 ●12

Hi @aleksei.shvetsov,

For RHistory function you can add 'DAY:A' as display parameters in formula to shows all days including the weekend. I don't know if it works for AdxRtHistory but you can try in .Mode.

What you can add to .Mode (and maybe it will work):

NULL:NA ->The Null attribute dictates how empty entries should be handled. The NULL keyword defines the action taken only where date entries with null data are encountered. Dates before the start date or following the end date of the time series are always ignored.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
aleksei.shvetsov avatar image
1 ●2 ●3 ●3

Hi, here is my RequestMode:

START:060120 END:061720 SORT:ASC FRQ:D NULL:NA


The DAY:A returns me an error "invalid keyword"


You can pick up any underlying, for Example .SPX


So I basically do not get empty cells at all. Is there any solution to this? I do not want to guess, whether it was a holiday, but retrieve the data directly from Reuters.


Thank you!

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.