Reference an existing cell value to use for Stocks data

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3146813%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EReference%20an%20existing%20cell%20value%20to%20use%20for%20Stocks%20data%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3146813%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EI%20note%20that%20trying%20to%20set%20a%20cell%20to%20Stock%20Data%20doesn't%20work%20if%20the%20cell%20is%20a%20formula.%20As%20I%20want%20to%20prepend%20a%20ticker%20value%20in%20an%20already%20populated%20cell%20with%20the%20relevant%20exchange%20(ie.%20XASX%3ACAA)%20is%20there%20a%20way%20to%20do%20this%20and%20have%20Stock%20Data%20populate%20(another%20cell%3F)%20without%20typing%20into%20the%20cell%20manually%3F%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3146813%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EOffice%20365%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Contributor

I note that trying to set a cell to Stock Data doesn't work if the cell is a formula. As I want to prepend a ticker value in an already populated cell with the relevant exchange (ie. XASX:CAA) is there a way to do this and have Stock Data populate (another cell?) without typing into the cell manually?

2 Replies

@reggie2020 

To my knowledge - nope. 

I thought that might be the case. Seems a rather obvious exception for a spreadsheet.