question

Upvotes
Accepted
1 1 2 3

Best way Receiving 4000 BID/ASK via Excel API

I am using Excel to see the BID/ASK price of 4.000 US Equities. Row A contians the ISIN and Row B contains the RIC. What is the best way to receive the BID/ASK and clsong (post market) price in row C, D and E?


Greetings

exceleikon-desktop-data-api
icon clock
10 |1500

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

Hi @Bjorn8,

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?

If so please can you click the 'Accept' text next to the appropriate 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


1 Answer

· Write an Answer
Upvotes
Accepted
17.2k 82 39 63

Hi @Bjorn8

Might help if you provide what you have done so far, or an example of what you've done. Within Excel, you can use the Formula Builder to generate your desired result. For example:

ahs.png


ahs.png (67.2 KiB)
icon clock
10 |1500

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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