# question

Accepted
1 1 2 2

## pull monthly time series using RHISTORY

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)

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

Hi,

Thank you for your participation in the forum.

If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question.

Thanks,

AHS

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

Thanks,

AHS

Accepted
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.```

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