Home OS Windows How to convert Currency and get Stock Data in Google Sheets

How to convert Currency and get Stock Data in Google Sheets

By now we all know how simple it’s to transform foreign money in Microsoft Excel, however what about Google Sheets? The software will not be as feature-rich as Excel, however it’s able to doing fairly just a few issues, and that features changing foreign money, no much less.

Convert Currency and get Stock Data in Google Sheets

To get this completed on Google Sheets, we will likely be utilizing the GOOGLEFINANCE perform. It will reap the benefits of correct monetary information taken immediately from Google itself.

We just like the GOOGLEFINANCE perform as a result of it will possibly ship real-time and present monetary information from markets around the globe. If you wish to know the most recent change price, then utilizing Google Sheets shouldn’t be an issue.

Before going ahead, we have to level out that the perform will replace the Sheet at an interval of each 20 minutes.

1] The components to seek out the present change price

OK, so when it comes right down to figuring out the present change price, you need to first decide which foreign money pairs will likely be used. Were going to give attention to American and Jamaican {dollars} as our major pair.

To get this completed, please kind the next into the perform part after which hit the enter key:


Depending in your wants, you possibly can exchange both foreign money pair with one other. Now, the instance above exhibits the present USD to JMD price.

2] Get historic change price information

Yes, it’s doable to make use of Google Sheets to achieve entry to change price data from again up to now. Were undecided how far we are able to return and weren’t about to seek out out.

The perform in query to achieve entry to historic change price information is as follows:


Make modifications to the perform to suit your wants the place doable.

3] Get reside inventory costs

convert Currency and get Stock Data in Google Sheets

Should there ever be a time once you want entry to reside inventory costs, then this may be completed from inside Google Sheets with ease.

In order to showcase reside inventory information, use the next perform:


As you possibly can see, NSE is used because the inventory change market of alternative, and it means the National Stock Exchange of India Ltd, and the ticker is RELIANCE. And as you possibly can see, the attribute is proscribed to only worth.

How to create a direct hyperlink to Google Sheets PDF hyperlink through Google Drive

4] Get historic inventory worth information

Now, simply figuring out the value for the day may not be sufficient, so how about studying of the historic information regarding the ticker?

Get every little thing completed by working the next command. Be certain to edit to your liking:

=GOOGLEFINANCE("NSE:RELIANCE", "open", DATE(2018,3,10), DATE(2018,10,3), "DAILY")

The above perform will present information from the interval of 2018/3/10 to 2018/10/Three on the day by day. If you need, DAILY could be modified to WEEKLY and even MONTHLY. Just work with no matter works for you.

What we’ve laid out listed below are simply the fundamentals. Maybe sooner or later, we’ll go somewhat bit deeper so that you can perceive.

Most Popular

Recent Comments