I am trying to find the last non zero entry in a column. The values are not sequential which makes it tougher. The column is the current profit margin on a group of stocks. I enter the value manually at the end of each day's trading. I want to use the number to create a therometer showing the profit as a relation to the overall value of the stock.
In order to show the relationship, I need to identify this variable. I have 5 entries per week.
Can anyone tell me how to identify this value?
In order to show the relationship, I need to identify this variable. I have 5 entries per week.
Can anyone tell me how to identify this value?
