combining multiple stocks prices sprarklines into single sparkline from googlesheet

  Kiến thức lập trình

I am trying to combine multiple sparkline generated from googlefinance with this code

=SPARKLINE(QUERY({GOOGLEFINANCE(“AMZN”,”price”,TODAY()-365,TODAY(),”daily”),GOOGLEFINANCE(“MSFT”,”price”,TODAY()-365,TODAY(),”daily”)},”select Col1, Col2+Col4″,1))

and now i want to add stock quantity to this code like “AMZN”=25qty, “MSFT”=30qty

New contributor

Aniket Mankar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

LEAVE A COMMENT