![]() ![]() AI + Google Sheets: Use Formula Builder to Automatically Generate GOOGLEFINANCE Formulas This is necessary because the formula used two separate cell references to create the ticker argument. You must use a concatenation operator (&) in the first parameter to list the exchange (B2), followed by a colon (:), and the reference containing the stock ticker symbol (B3). Now you can simply drag down the formula in E2 to fill in the rest of the cells. Using absolute references for the ticker parameter will streamline the rest of the formulas. The formula should return the stock’s real-time price. Your complete formula should look like this:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |