Hello.
In my first sheet, I want to automatically populate the last column:
Annotation 2019-12-01 181545.png
In another sheet, I have a model which requires the ticker as input, and outputs the Up- / downside.
Annotation 2019-12-01 214329.png
I want to use this model to populate the last column for all tickers. How can I do this? The thing is the model on the "model sheet" is larger than the screenshot shows. The column Up- / downstate could be calculated by just writing the formula in the cell in the table. That would, however, make it very hard to follow along the calculations and manipulate / change the model.
Very thankful for help. See attached file.
Bookmarks