|May 16th, 2013, 08:03 PM||#1 (permalink)|
Futures Experience: Beginner
Favorite Futures: forex
Posts: 1 since May 2013
Thanks: 0 given, 0 received
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?