Hadda waxaan ognahay sida ay u fududahay in lacag loogu beddelo Microsoft Excel , laakiin ka waran Google Sheets ? Qalabku ma noqon karo mid qani ah sida Excel , laakiin waxa uu awood u leeyahay inuu sameeyo waxyaabo yar, taas oo ay ku jirto beddelka lacagta, wax yar maaha.

Beddel Lacagta^{(Convert Currency)} oo hel Xogta Kaydka^{(Stock Data)} Google -^(Google) ka

Si tan loogu sameeyo Google Sheets , waxaanu isticmaali doonaa shaqada GOOGLEFINANCE . Waxay ka faa'iidaysan doontaa xogta maaliyadeed ee saxda ah oo si toos ah Google lafteeda looga qaatay.

Waxaan jecelnahay shaqada GOOGLEFINANCE sababtoo ah waxay keeni kartaa wakhtiga dhabta ah iyo xogta maaliyadeed ee suuqyada aduunka. Haddii aad rabto inaad ogaato sicirka sarrifka ugu dambeeyay, markaa adeegsiga Google Sheets waa inaysan dhibaato noqon.

Kahor intaanan hore u socon, waxaan u baahanahay inaan tilmaamno in shaqadu ay cusbooneysiin doonto xaashida^(Sheet) 20 daqiiqo kasta.

1] Qaabka lagu heli karo sarifka hadda jira

OK, marka marka ay timaado in la ogaado heerka sarrifka hadda, waa in aad marka hore go'aamiso lammaane lacagta la isticmaali doono. Waxaan diirada saarnay doollarka Mareykanka iyo Jamaica sida lammaaneheena koowaad.

Si tan loo sameeyo, fadlan ku qor kuwan soo socda qaybta shaqada ka dibna ku dhufo furaha geli:

=GOOGLEFINANCE("Currency:USDJMD")

Iyadoo ku xiran baahidaada, waxaad ku bedeli kartaa labada lacag midna mid kale. Hadda, tusaalaha kore wuxuu muujinayaa USD ilaa JMD hadda .

2] Hel^(Get) xogta sarrifka taariikhda

Haa, waa suurtogal in la isticmaalo Google Sheets si loo helo macluumaadka sarifka lacagaha ee gadaalkii hore. Ma^(Were) aan hubin inta aan dib ugu noqon karno mana aynaan ogaan karin.

Shaqada su'aasha ah si loo helo xogta sarrifka taariikhda waa sida soo socota:

=GOOGLEFINANCE("CURRENCY:USDJMD", "price", DATE(2018,1,1))

Isbeddel ku samee^(Make) shaqada si ay ugu habboonaato baahiyahaaga halka ay suurtagal tahay.

3] Hel qiimaha saamiyada tooska ah

Haddii uu jiro wakhti aad u baahan tahay helitaanka qiimaha saamiyada nool, markaa tan waxaa laga samayn karaa gudaha Google Sheets si sahlan.

Si loo muujiyo xogta kaydka tooska ah, isticmaal shaqadan soo socota:

=GOOGLEFINANCE("NSE:RELIANCE","price")

Sida aad arki karto, NSE waxaa loo isticmaalaa sida suuqa kala iibsiga saamiyada ee doorashada, oo ay ka dhigan tahay National Stock Exchange of India Ltd , iyo calaamaduhu waa RELIANCE . Sida aad arki karto, sifadu waxay ku kooban tahay qiimaha kaliya.

4] Hel xogta qiimaha saamiyada taariikhiga ah

Hadda, kaliya ogaanshaha qiimaha maalinta ayaa laga yaabaa inaysan ku filneyn, markaa sidee ku saabsan barashada xogta taariikhiga ah ee la xiriirta calaamadeeyaha?

Wax walba ku samee adiga oo socodsiinaya amarka soo socda. Hubi inaad wax ka beddesho sidaad jeceshahay:

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

Shaqada kore waxay tusi doontaa xogta laga bilaabo muddada 2018/3/10 ilaa 2018/10/3 maalin kasta. Haddii aad rabto, MAALINTIIN^(DAILY) waxa loo beddeli karaa toddobaadle^(WEEKLY) ama xitaa bille^(MONTHLY) . Kaliya^(Just) la shaqee wax kasta oo adiga kuu shaqeeya.

Waxa aan halkan ku soo bandhignay waa uun aasaaska. Waxaa laga yaabaa in mustaqbalka, aan aad u yara sii qoto dheer si aad u fahamto.

Akhri soo socda^{(Read next)} : Sida loo sameeyo xiriir toos ah Google Sheets PDF isku xirka Google Drive^{(create a direct link to Google Sheets PDF link via Google Drive)} .

How to convert Currency and get Stock Data in Google Sheets

By now we know how easy it is to convert currency in Microsoft Excel, but what about Google Sheets? The tool may not be as feature-rich as Excel, but it is capable of doing quite a few things, and that includes converting currency, no less.

Convert Currency and get Stock Data in Google Sheets

To get this done on Google Sheets, we will be using the GOOGLEFINANCE function. It will take advantage of accurate financial data taken directly from Google itself.

We like the GOOGLEFINANCE function because it can deliver real-time and current financial data from markets around the world. If you want to know the latest exchange rate, then using Google Sheets shouldn’t be a problem.

Before going forward, we need to point out that the function will update the Sheet at an interval of every 20 minutes.

1] The formula to find the current exchange rate

OK, so when it comes down to knowing the current exchange rate, you must first determine which currency pairs will be used. Were going to focus on American and Jamaican dollars as our primary pair.

To get this done, please type the following into the function section and then hit the enter key:

=GOOGLEFINANCE("Currency:USDJMD")

Depending on your needs, you can replace either currency pair with another. Now, the example above shows the current USD to JMD rate.

2] Get historical exchange rate data

Yes, it is possible to use Google Sheets to gain access to exchange rate information from back in the past. Were not sure how far we can go back and were not about to find out.

The function in question to gain access to historical exchange rate data is as follows:

=GOOGLEFINANCE("CURRENCY:USDJMD", "price", DATE(2018,1,1))

Make changes to the function to fit your needs where possible.

3] Get live stock prices

Should there ever be a time when you need access to live stock prices, then this can be done from within Google Sheets with ease.

In order to showcase live stock data, use the following function:

=GOOGLEFINANCE("NSE:RELIANCE","price")

As you can see, NSE is used as the stock exchange market of choice, and it means the National Stock Exchange of India Ltd, and the ticker is RELIANCE. And as you can see, the attribute is limited to just price.

4] Get historical stock price data

Now, just knowing the price for the day might not be enough, so how about learning of the historical data relating to the ticker?

Get everything done by running the following command. Be sure to edit to your liking:

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

The above function will show data from the period of 2018/3/10 to 2018/10/3 on the daily. If you want, DAILY can be changed to WEEKLY or even MONTHLY. Just work with whatever works for you.

What we’ve laid out here are just the basics. Maybe in the future, we will go a little bit deeper for you to understand.

Read next: How to create a direct link to Google Sheets PDF link via Google Drive.

Related posts

• Sida qoraalka loogu beddelo abka shabakadda Google Sheets

• Sida loo sameeyo Koofida Dhibcaha ee Google Docs dhowr daqiiqo gudahood

• Hagaaji Google Docs Spellcheck oo aan si sax ah u shaqayn

• Sida loo geliyo sanduuqa qoraalka gudaha Google Docs

• Sida loo sameeyo Google Slides loop iyada oo aan la daabicin

• Sida loo rakibo oo looga saaro add-ons gudaha Google Docs

• Sida loo beddelo Margin iyo Midabka Google Docs

• Sida Loo Isticmaalo Qaabka Bilaashka Ah ee Kala-reebista ee Google Docs iyo Google Slides

• Sida PDF loogu tafatiro Google Docs ee shabakada

• Sida loo isticmaalo IF iyo Nsted IF shaqooyinka Google Sheets

• Sida loo beddelo hanuuninta bogga Google Docs

• Sideed ugu duubtaa qoraalka sawirka Google Docs

• Sida loogu daro Nambarada bogga Google Docs

• Sida loo barbar dhigo labada dukumeenti ee Google Docs

• Sida lakabka iyo kooxaynta Sawirada Google Docs

• Sida loo midoobo oo loo kala saaro unugyada Google Doc Table

• Sida had iyo jeer loogu muujiyo tirinta kelmadda Google Docs

• Sida Font loogu daro Google Docs

• Qaababka shaqo ee ugu wanaagsan ee Google Docs si loo abuuro CV xirfad leh

• Sida loogu isticmaalo Habka Madow gudaha Google Docs, Sheets, iyo Slides