I need a script(s) or functions for google spreadsheet as follows:
1) Column A has several stock symbols. I need to make these clickable links so that when any one of them is clicked, the symbol goes to Cell C3, where GoogleFinance provides other data in green section.
2) Column H items calculate price per share (Column B) times shares owned (Column G). I need Column I to show the highest figure ever shown in Column H
3) Cells F14 & F15 are not working with functions provided me. A copy of these functions are attached. I would like to make these work if possible.
Spreadsheet is stored on google Drive. Send me gmail address and I'll share it with you.