|
miami florida
Posts: 1 since May 2013
Thanks Given: 0
Thanks Received: 0
|
hello
First, English is not my mother language, so i might have some mistakes..
i try to make a column that will show me the gap stocks as percentage.
for example: last night the close of some stock was 90.34. today the stock opens with 100.51.
then the calculation will be: (100.51/90.34)-1=0.1125=11.25%
(last night close)/(today's open) - 1 = (gap as percentage)
how can i make a column that calculating the stocks gap as percentage?
thanks
|
