Step 4:<\/strong> Now drag the formula applied cells to other cells where you want to convert the currency.<\/li>\n<\/ul>\n<\/p>\n
To convert the price to INR, we simply multiplied the output of the GOOGLEFINANCE function by the cell value in column A.<\/p>\n
Google Finance Currency Historical Data<\/h3>\n
You can modify the GOOGLEFINANCE function to obtain exchange rates for a longer period of time rather than just one day.<\/p>\n
The GOOGLEFINANCE function can be modified to retrieve historical exchange rates using the following syntax:<\/p>\n
GOOGLEFINANCE(“CURRENCY:<source_currency_symbol><target_currency_symbol>”, [attribute], [start_date], [number_of_days|end_date], [interval])<\/span><\/strong><\/p>\nThe steps to fetch historical data currency conversion are given below:<\/p>\n
\n- Step 1:<\/strong> Choose the cell where you want to fetch the historical currency exchange rate.<\/li>\n
- Step 2:<\/strong> Now type the formula: =GOOGLEFINANCE(\u201cCURRENCY:USDINR\u201d, \u201cprice\u201d, DATE(2021,10,10), DATE(2021,10,20), \u201cDAILY\u201d)<\/strong><\/li>\n
- Step 3:<\/strong> Press the \u201cEnter<\/strong>\u201d button and you will start seeing the results as shown below.<\/li>\n<\/ul>\n
<\/p>\n
How to use GOOGLEFINANCE to Fetch Currency Exchange Rates Over the Past Week?<\/h3>\n
Instead of using the DATE method, you can use the TODAY function to dynamically display exchange rates for the past, say one week, based on the day the sheet is opened.<\/p>\n
Consider the following scenario: we want to dynamically display exchange rates for the preceding 10 days, regardless of the day the sheet is opened on. The steps to get this done are given below:<\/p>\n
\n- Step 1:<\/strong> Open the spreadsheet where you want to fetch the currency conversion rates.<\/li>\n
- Step 2:<\/strong> Now enter the formula =GOOGLEFINANCE(\u201cCURRENCY:USDEUR\u201d, \u201cprice\u201d, TODAY()-10, TODAY(), \u201cDAILY\u201d)<\/strong><\/li>\n
- Step 3:<\/strong> Press the \u201cEnter<\/strong>\u201d button and you will see results as shown below.<\/li>\n<\/ul>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
With the help of the Google Finance function, we can easily convert the currency in Google Spreadsheet. The finance feature of Google Sheets lets users convert currency rates automatically without any manual calculations since Google Sheets fetches updated currency rates automatically as and when we enter the formulas. Also Read: Java Program to Convert Kilogram … Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":2072,"url":"https:\/\/sheetstips.com\/how-to-track-stocks-in-google-sheets\/","url_meta":{"origin":1464,"position":0},"title":"How To Track Stocks in Google Sheets? – Stock Analysis Using Google Finance","author":"Varsha","date":"May 22, 2022","format":false,"excerpt":"Google Finance is one of the most useful functions that was recently introduced. With the Google Sheets Finance function, we can easily track stock prices are earnings per share. Using this function in Spreadsheet will help us to retrieve current or historical stock market data from Google Finance.\u00a0 However, to\u2026","rel":"","context":"In "Google Sheets"","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"track stocks in google sheets1","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2022\/01\/track-stocks-in-google-sheets.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":363,"url":"https:\/\/sheetstips.com\/convert-text-to-numbers-google-sheets\/","url_meta":{"origin":1464,"position":1},"title":"How To Convert Text to Numbers in Google Sheets: String to Text Conversion","author":"Varsha","date":"December 6, 2022","format":false,"excerpt":"Convert String to Number Formula: When you are working in Google Sheets, you can easily perform the mathematical operations when you are dealing with numbers. However, the same mathematical operations couldn't be performed when it comes to the text nature of numbers. Thus to overcome this issue, we should convert\u2026","rel":"","context":"In "Google Sheets"","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"convert-text-to-numbers-google-sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/08\/Screenshot-2021-08-05-103542.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1657,"url":"https:\/\/sheetstips.com\/how-to-set-the-default-currency-in-google-sheets\/","url_meta":{"origin":1464,"position":2},"title":"How to Set Default Currency in Google Spreadsheet – Change Currency Settings in Google Sheets","author":"Varsha","date":"May 13, 2022","format":false,"excerpt":"Google Sheets is a great tool that is also used for performing financial calculations. When performing financial calculations in Google Spreadsheets, we might need to change the currency settings as per the county we are residing in. Google Sheets comes with various currency options with the help of which we\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"how to change currency symbol in google sheets1","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/11\/how-to-change-currency-symbol-in-google-sheets1-1.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1664,"url":"https:\/\/sheetstips.com\/how-to-change-the-currency-symbol-in-google-sheets\/","url_meta":{"origin":1464,"position":3},"title":"How to Change Currency Symbol in Google Sheets? (Set Custom Currency Symbol)","author":"Varsha","date":"May 13, 2022","format":false,"excerpt":"Nowadays Google Sheets are widely used by businesses for day to day expense tracking and budget analysis. Since it is widespread across the world by various businesses, there might be a need to change the currency symbol as per the country or the place he\/she residing in. To help with\u2026","rel":"","context":"In "Google Sheets"","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"how to change currency symbol in google sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/11\/how-to-change-currency-symbol-in-google-sheets.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":144,"url":"https:\/\/sheetstips.com\/convert-excel-to-google-sheets\/","url_meta":{"origin":1464,"position":4},"title":"How to Convert Excel to Google Sheets: Saving Excel Sheet in Google Drive","author":"Varsha","date":"May 20, 2022","format":false,"excerpt":"Conversion of Excel to Google Sheets: There are many instances, where you would like to convert the excel files into Google sheets. Conversion of excel into Google sheets acts as a great advantage, if you want to collaborate with fellow mates or others easily. Also, Google sheets have amazing features\u2026","rel":"","context":"In "Google Sheets"","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"excel sheets to google sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/07\/excel-sheets-to-google-sheets-5.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":997,"url":"https:\/\/sheetstips.com\/convert-formula-to-value-google-sheets\/","url_meta":{"origin":1464,"position":5},"title":"How to Convert Formula to Value in Google Sheets?","author":"Varsha","date":"May 16, 2022","format":false,"excerpt":"When working with Google Sheets, we use n number of formulas and functions. However, when we are copying formula applied cells from one cell to another cell, the Google Sheets will show up an error. This error will be shown due to the difference in cell reference numbers that we\u2026","rel":"","context":"In "Google Sheets"","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"convert-formula-to-value-google-sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/09\/convert-formula-to-value-google-sheets4.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/1464"}],"collection":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/comments?post=1464"}],"version-history":[{"count":6,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/1464\/revisions"}],"predecessor-version":[{"id":4877,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/1464\/revisions\/4877"}],"wp:attachment":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/media?parent=1464"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/categories?post=1464"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/tags?post=1464"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}