How do I reference the cell to the left of the current cell in Google sheets?

Question

I have to apply a function to every cell in column 2, which retrieves information about a symbol in column 1. I have 100 columns and don't want to individually plug each symbol in, so I need a way to reference the information in A2 in the function being used in B2

E.g. This is the spreadsheet I'm working on.

=GOOGLEFINANCE(SymbolDisplayedInTheCellToTheLeftOfThisCell, "price")

Thanks

Answer 1

While Ruben's answer is better for most calculation (and copy-paste should do the change for you). To get the cell to the left you can use ADDRESS function and ROW and COLUMN

If you write =ADDRESS(ROW(), COLUMN()-1, 4) on B4 for example, it will return A4

Then you can use INDIRECT to get the value in that cell