How to get current holding & total investment

mastertrader21 · August 2017

pfa of image for clarification of my doubt

sujith · August 2017

Hi @mastertrader21,
Total investment is sum of (quantity * average_cost) and current value is (quantity * last price)

mastertrader21 · August 2017

how to get net chg. percent in above screen

tonystark · August 2017

Hi @mastertrader21,

Individual net change percentage = ((quantity * ltp) - (quantity * average_cost)) / (quantity * average_cost) * 100
Total net change percentage = (currentvalue - totalinvestment) / totalinvestment * 100

mastertrader21 · August 2017

Dear sujith

I want individual current value you had gave me the formula current value = (quantity * last price).
Example for above screen considering the first row (14*755.15)=10572.1 but the value shown on screen is 13592.70.

Please guide me for the same.

tonystark · August 2017

Hi @mastertrader21,

You forgot to add T1 quantity 4

mastertrader21 · September 2017

Dear sir,

I need to know the calculation behind chg. in open position module. please refer the below image

mastertrader21 · September 2017

I used the above mention formula by you ((quantity * ltp) - (quantity * average_cost)) / (quantity * average_cost) * 100 is it correct

Howdy, Stranger!

Categories

In this Discussion

How to get current holding & total investment