![]() You can make some alterations to the GOOGLEFINANCE function to fetch Google Sheet exchange rates over a period of time, instead of just one day. Related Reading: How to Remove a Dollar Sign in Google Sheets How to Use GOOGLE FINANCE to Fetch Historical Exchange Rates For example, you can use it to display historical exchange rates too. However, there are other optional parameters that the GOOGLEFINANCE function lets you enter in order to get specifically what you need. Notice we simply multiplied the result of the GOOGLEFINANCE function with the cell value in column A, in order to convert the price to INR.Įntering your parameters along with just the general GOOGLEFINANCE function is enough to give you an accurate conversion rate.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |