question

Upvotes
Accepted
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 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvote
Accepted
23k 22 9 14

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 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea