question

Upvotes
Accepted
tinamurphy avatar image
1 ●0 ●0 ●2

REDI API in Excel, Total Price

Hi, I am trying to use RediLinks to put my "Total Price" of a certain stock into excel. So if I sold 100 shares at 10 and 100 shares at 10.5, it would say 10.25. Does anyone know how to pull this into excel from REDI? I currently use code like this to get the position into excel: =RediLink|POS!'ACCNT;aapl;QuantityBought,QuantityShortSold,QuantitySold'

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

pimchaya.wongrukun01 avatar image   pimchaya.wongrukun01
@Olivier DAVANT

Could you help on this question?

wasin.w avatar image   wasin.w

Hello @tinamurphy

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

pimchaya.wongrukun01 avatar image   pimchaya.wongrukun01

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
Upvote
Accepted
zoya faberov avatar image
32.2k ●40 ●11 ●20

Hello @tinamurphy,

Believe you are looking for:

  =RediLINK|MSG!'SS;tp'

Topic: MSG = message

By: SS = by symbol and side

Fields: TP = Total Average Price

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.