Two GOOGLEFINANCE formulae in one cell

Question

I am trying to incorporate a GOOGLEFINANCE formula in the GOOGLE SHEETS in one cell, say, F45, like the one in the following:

=GOOGLEFINANCE(A45)-=GOOGLEFINANCE(A45, "CloseYest")

The Cell A45 has a string, such as "GOOG". This gives Formula parse error. If I break them into 2 cells like:

=GOOGLEFINANCE(A45) in one cell and =GOOGLEFINANCE(A45, "CloseYest") works perfectly. No amount of ((( or ))) to separate the formula in the same cell works, and results in the same Formula parse error. For example, =(=GOOGLEFINANCE(F45))-(=googlefinance(F45, "CloseYest")) gives me parse error.

Is there any solution to this problem?

Answer 1

You need to remove extra = - it is necessary only in the beginning of the formula:

=GOOGLEFINANCE(A45)-GOOGLEFINANCE(A45, "CloseYest")

Where A45 is the cell with the name of a security.