I need to convert 1 USD = INR on specified date (23/07/2017)


=D5*GoogleFinance("CURRENCY:USDINR", "price", "23/07/2017")

But it is throwing an error, where I am going wrong?

1 Answer 1




The error message seems clear enough to me: Function MULTIPLY parameter 2 expects number values. But 'Date' is a text and cannot be coerced to a number. Why 'Date'? ... because, as mentioned for GOOGLEFINANCE:

Historical data, even for a single day, will be returned as an expanded array with column headers.

[Try your formula without D5*.]

INDEX can be used to select a specific element from an array.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.