If I want to pull just monthly time series, how do I change the following RHISORY formula?
RHistory(A4:D4,".Timestamp;.Close","START:"&$A$2&" END:"&$A$3&" INTERVAL:1D","FRQ:SNAP","SORT:ASC TSREPEAT:NO NULL:" &"SKIP" &" Transpose:N",A7)
1
●1 ●2 ●2
pull monthly time series using RHISTORY
Hi,
Thank you for your participation in the forum.
Is the reply below satisfactory in answering your question?
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
Hi @Salman.Khoja,
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
78.8k
●250 ●52 ●74
You can use the Excel Formula Builder to check valid values of parameters. For monthly data, the Interval is 1MO.
INTERVAL:1MO
According to the Eikon Excel Help page, the valid values of Interval are:
INTERVAL defines the interval between each data point retrieved. The list of available values is instrument and field-specific. It can have these values.
{TICK, TAS, TAQ, TASTAQ, 1M, 5M, 15M, 60M, 1D, 1W, 1MO, 1Y}
INTERVAL:TICK to retrieve data for each change in a particular price value (trade price, bid, ask, and so on) for the requested instrument
INTERVAL:TAS to retrieve historical time and sales data, that is, a historical record of trades for the requested instrument, sorted by time
INTERVAL:TAQ to retrieve historical time and quotes data, that is, a historical record of quotes for the requested instrument, sorted by time
INTERVAL:TASTAQ to retrieve time series data for trades and quotes, that is, a historical record of trades and quotes, sorted by time
INTERVAL:1M for 1 minute
INTERVAL:5M for 5 minutes
INTERVAL:15M for 15 minutes
INTERVAL:60M for 60 minutes
INTERVAL:1D for 1 day
INTERVAL:1W for 1 week
INTERVAL:1MO for 1 month
INTERVAL:1Y for 1 year
Default value: None.
You must define INTERVAL for RHistory.
