REDI API in Excel, Total Price

tinamurphy

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'

zoya faberov

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