Server side error in Excel for VWAP function on Nasdaq

Question

Question by gerald · Jan 18, 2019 at 03:42 AM · eikon eikon-com-api excel

Hello,

In Excel with Eikon, we try to get the vwap for a list of RIC on the Nasdaq and we get all the time "server side error".

Here is the function used:

=TR(A8:A77;"TR.VWAPALL";"StartTime=#1 EndTime=#2 TZ=#3 CH=Fd RH=IN";L7;"2019-01-02T17.01.00";"2019-01-02T22.00.00";"PAR")

We don't think to have change anything. Any idea on where to investigate or better on how to fix it?

Thanks

0

10 |1500 characters needed characters left characters exceeded

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

Answer 1 · 2019-01-18T04:04:57Z

Best Answer

Answer by marcin.bunkowski · Jan 18, 2019 at 04:04 AM

That case should be opened with the local Refinitiv helpdesk and they will be able to assist you further.

The formula that you have posted above has references to other cells and that would be also required to investigate.

0 · Share

10 |1500 characters needed characters left characters exceeded

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

Answer 2 · 2019-01-18T04:10:27Z

Answer by gerald · Jan 18, 2019 at 04:10 AM

@marcin.bunkowski

the reference is just a list of RICs on Nasdaq

For example:

ADBE.O

AAPL.O

AMZN.O

0 Show 1 · Share

10 |1500 characters needed characters left characters exceeded

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

Zhenya Kovalyov ♦♦ · Jan 18, 2019 at 04:58 AM 0

Share

@gerald as Marcin has noted the best way to tackle any product issue not pertaining to the APIs is to bring in the help desk.

Answer 3 · 2019-01-18T05:07:53Z

Answer by gerald · Jan 18, 2019 at 05:07 AM

Thanks, but when the helpdesk is not helpful and we have this issue reported to them for weeks now, the only solution is...

0 Show 1 · Share

10 |1500 characters needed characters left characters exceeded

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

Zhenya Kovalyov ♦♦ · Jan 18, 2019 at 05:10 AM 0

Share

@gerald I will send you an email