question

Upvotes
Accepted
Bjorn8 avatar image
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.

1 Answer

· Write an Answer
Upvotes
Accepted
nick.zincone avatar image
18.7k ●85 ●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.