Silver Dollar Stock Club Post

To get the sum for F4 you multiply D4 and E4, that should give you the total of the initial cost, and do the same thing for D4 through F12.

To Current Value you will need to add the Initial Cost and the Current Price Per Share and that is going to give the the total to get the Current Value.

To get the Gain/Loss you subtract the Current Value from the Initial Cost and that will give you your Gain/Loss.

To get the Percent of the Gain/Loss you would have to take the Gain/Loss and subtract the Initial Cost from that.