question

Upvotes
Accepted
5 1 1 5

Server side error in Excel for VWAP function on Nasdaq

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

eikoneikon-com-apiexcel
icon clock
10 |1500

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

Upvotes
Accepted
3.8k 4 4 6

@gerald

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.

icon clock
10 |1500

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

Upvotes
5 1 1 5
@marcin.bunkowski

the reference is just a list of RICs on Nasdaq

For example:

ADBE.O

AAPL.O

AMZN.O

icon clock
10 |1500

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

@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.

Upvotes
5 1 1 5

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

icon clock
10 |1500

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

@gerald I will send you an email

Click below to post an Idea Post Idea