Reuters code that i can use to build a macro on all the good trade dates for USDJPY?

Question

I am posting this query on behalf of a Workspace For FX Trading user.

Could you kindly assist with the below query?

Description

hi is there a reuters code that i can use to build a macro on all the good trade dates for USDJPY?

for example monthly 15th roll - 36 fixings, i want to build a macro that shows the usdjpy roll for the 15th

Jirapongse · Answer

Please share the formula in the Workspace Excel that can pull this data. Then, I can check if the same data can be pulled by the LSEG COM Library.

DarrylBC_1 · Answer

I have circled back to our Trading Specialists for further consultation.

Meanwhile, I received this following additional details from the client.

VERBATIM:

"Ok pls ignore the roll part.

How do I get a calendar for JPY, USD and other currency pairs?

So I can make a macro to avoid those dates myself."

Jirapongse · Answer

If it is about Macros in the Workspace Excel, please contact the Workspace Excel support team directly.

Otherwise, the client can use LSEG COM Library for Workspace to pull data. However, we need to check if the required data can be pulled by this LSEG COM Library.

Please share the formula in the Workspace Excel that can pull this data. Then, I can check if the same data can be pulled by the LSEG COM Library.

EXPLORE OUR SITES