Yes. I can do it in Excel.

What you suggested me has prompted me to try different dates in Data API function. I have found this: if end_date is to be less than today (I am in GMT+8, Singapore/China timezone), I can retrieve the data. If it is more than today, I would be prompted by the TSINotPermissioned error.

Example:

At GMT+8 10:28 AM,

Code that returns error

get_timeseries(rics = list("PCAAT00"), fields = list("*"), start_date = "2010-01-01T00:00:00", end_date = "2019-02-22T00:00:00", interval = "daily", debug = TRUE)

Working Code

get_timeseries(rics = list("PCAAT00"), fields = list("*"), start_date = "2010-01-01T00:00:00", end_date = "2019-02-19T00:00:00", interval = "daily", debug = TRUE)

Working RIC for both 2-19 and 2-22 (in the future)

get_timeseries(rics = list("MSFT.O"), fields = list("*"), start_date = "2010-01-01T00:00:00", end_date = "2019-02-19T00:00:00", interval = "daily", debug = TRUE) 
get_timeseries(rics = list("MSFT.O"), fields = list("*"), start_date = "2010-01-01T00:00:00", end_date = "2019-02-22T00:00:00", interval = "daily", debug = TRUE) 

I think the cause for this error is PCAAT00 is a Platts Index. Without PGA (Platts Global Alert) subscription, Eikon only provides delayed access. If I request for more up-to-date data, Eikon server would regard the request for un-permissioned data, which is the error. I hope this could be better handled, i.e. server would not return an error but only the delayed data.

Are you able to retrieve timeseries into Excel using the following function?
=RHistory("PCAAT00",".Timestamp;.Close","INTERVAL:1D")