Uzilandelela njani izitokhwe usebenzisa amashidi kaGoogle:
Omnye wemisebenzi encinci eyaziwayo kwi AmaSpredishithi eGoogle yi GOOGLEFINANCE, ekuvumela ukuba ulandelele idatha yangoku okanye yembali yesitokhwe kwimarike yemasheya. Nantsi indlela yokuyisebenzisa.
Yintoni iGoogle Finance?
Ezemali sisixhobo sikaGoogle sexesha lokwenyani esibonisa ulwazi lwemarike yangoku kwaye siqokelela iindaba zoshishino. Ngoku idityaniswe noPhendlo lukaGoogle, ke ukuba ukhangela isimboli yeticker yenkampani ethile kuGoogle efana neWMT yeWalmart okanye iAAPL yeApple, uyakubona ngoko nangoko amaxabiso esitokhwe kunye nedatha yembali yokhuseleko. Ungacofa kwenye yezi zitokhwe ukuya kwiphepha lezeMali likaGoogle lenkampani, elibonisa imali yenkampani kunye neendaba ezinxulumeneyo, kwaye ikuvumela ukuba uthelekise nezinye iimveliso.
Ngelixa kukho ezinye, izixhobo ezinamandla ngakumbi onokuzisebenzisa ukulandelela izibambiso, iMali kaGoogle kuphela kwesixhobo esinokuthi sidityaniswe ngokufanelekileyo neeSpredishithi zikaGoogle. Ingaba ungumfundi we-stock novice okanye umthengisi onamava, oku kuhlanganiswa yindlela elula yokungenisa kunye nokubeka iliso kwidatha yesitokhwe kwi-spreadsheet.
Ngapha koko, ukudityaniswa kwaMashidi eZimali zikaGoogle kufumaneka kuphela ngesiNgesi kwaye akubandakanyi utshintshiselwano lwamazwe ngamazwe okwangoku. Ke ukuba ufuna ukujongana notshintshiselwano lwesitokhwe saseAsia okanye saseYurophu, oku akunakuba yeyona ndlela ilungileyo kuwe.
Ukusebenza kwezeMali zikaGoogle
Umsebenzi otsala idatha yesitoko ubizwa ngokuba yi-GOOGLEFINANCE. I-syntax yomsebenzi ilula kakhulu kwaye isebenzisa iingxoxo ezintlanu, ezine kuzo ezikhethwayo.
Ingxoxo yokuqala luphawu lwesalathi. Ezi ziimpawu zeenkampani xa zibeka uluhlu kwimarike yemasheya, njenge-GOOG yeGoogle okanye i-BAC yeBhanki yaseMelika. Unokuphinda uchaze utshintshiselwano apho isitokhwe sakho esikhethiweyo sidweliswe ukuphepha ukungafani. Ekubeni iBhanki yaseMelika ibhalwe kwiNew York Stock Exchange, chwetheza "NYSE: BAC".
Ukufumana iisimboli zesitokhwe kunye notshintshiselwano lwesitokhwe oyifunayo, kuya kufuneka wenze uphando. Unokuyikhangela kwiMali kaGoogle okanye isixhobo sakho solawulo lwepotfoliyo oyikhethileyo.
Ingxoxo yesibini luphawu onqwenela ukulubonisa. Ngokungagqibekanga, imiselwe "kwixabiso" ukuba uyishiya ingenanto. Nazi ezinye iimpawu onokuthi uzitsale kunye nomsebenzi:
- ixabiso: Ixabiso lesitokhwe kanye ngexesha lokwenyani.
- ubukhulu: umthamo worhwebo wangoku.
- phezulu: Ixabiso eliphezulu losuku lwangoku okanye olukhethiweyo.
- Phantsi: Ixabiso eliphantsi langoku okanye elikhethiweyo losuku.
- ubukhulu: I-avareji umthamo worhwebo wemihla ngemihla.
- umzekelo: Umlinganiselo wexabiso ukuya kwimivuzo.
- eps: Umvuzo ngesabelo ngasinye.
Qaphela ukuba iimpawu onokuzijonga ziyahluka ngokuxhomekeke ekubeni usebenzisa idatha yangoku okanye yembali. Ngezantsi Uluhlu olupheleleyo lweempawu onokuyisebenzisa kwingxoxo. Kubalulekile ukukhumbula ukuba idatha yangoku ihlaziywa rhoqo ngemizuzu eyi-15, ngoko ayiloxesha lokwenyani ngokupheleleyo.
Ingxoxo yesithathu ngumhla wokuqala, osebenza kuphela ukuba usebenzisa idatha yembali. Ungachwetheza "TODAY()" okanye uyiyeke ingenanto ukujonga idatha yexesha lokwenyani. Ingxoxo yesine ikhankanya umhla wokugqibela okanye inani leentsuku ukusuka kumhla wokuqala. Ukuba kushiywe kungenanto, umsebenzi uya kubuyisela idatha ukusuka kusuku olunye.
Ingxabano yokugqibela lithuba, elikuvumela ukuba uchaze ukuphindaphinda kwedatha. Unokuyimisela "imihla ngemihla" okanye "ngeveki".
Inye into ekufuneka uyiqaphele kukuba amashidi kaGoogle aphatha isimboli yekhesa kunye neengxoxo zophawu njengesicatshulwa, ke qiniseka ukuba ubeka iikowuti ngeenxa zonke kuzo, okanye uya kufumana impazamo.
Ukulandelela uluhlu lwezinto ezikhoyo
Kulo mzekelo, masithi ufuna ukufumana ixabiso langoku le-stock ye-Facebook. I-Facebook idweliswe kwi-NASDAQ kunye nophawu lweticker u-FB. Kule meko, uya kubhala ingxabano yokuqala njenge "NASDAQ: FB" kunye "nexabiso" njengophawu. Ngoko ifomula yale nto iya kuba =GOOGLEFINANCE("NASDAQ:FB","price").
Ukuba ubufuna ukubonisa amaxabiso emihla ngemihla okuvala kwiveki ethile, njengeveki eqala nge-15 ka-Okthobha 2018, ungakhankanya uluhlu lomhla kwiingxoxo zesithathu nezesine. iba ngumfuziselo wayo =GOOGLEFINANCE("NASDAQ:FB","price",DATE(2018,10,15),DATE(2018,10,20)). Qaphela ukuba imboniselo yeDatha yeMbali yandisa ulwazi olwenziweyo kwidatha eluhlu, ehlala kwiiseli ezikufutshane.
Unokusebenzisa umsebenzi ukuvelisa ngokuzenzekelayo idatha yoluhlu lwesitokhwe. Bhala ngokulula izikhombisi kwikholamu, emva koko usebenzise iiseli kwingxoxo yakho yokuqala. Kuba isimboli yekhesa ikwiseli C4, uya kuyichwetheza =GOOGLEFINANCE(C4,"price"). Ngezantsi uluhlu lweempahla kunye namaxabiso azo ahambelanayo angoku.
Ukuba ufuna ukugcina umkhondo woluhlu lweempawu, ungazibhala kwiiseli ezahlukeneyo njengakumfanekiso ongentla. Emva koko, ubophelela impikiswano yesibini kwiseli enegama loyelelwano. Ngexabiso leseli ye-NYSE:IBM kumzekelo ongezantsi, ifomula iya kuba =GOOGLEFINANCE(C$2,$B5).
Yandisa i-Google Sheets
Elona candelo lilungileyo lokuba nesitokhwe sakho kuMashidi kaGoogle kukuba ungasebenzisa... Izixhobo zokucwangcisa idatha eyahlukileyo kuyo.
Umzekelo, masithi ufuna ukusebenzisa i-Google Sheets ukulandelela ixabiso lazo zonke ii-asethi zakho zemali, ezifana nezitokhwe, ii-akhawunti zokulondoloza, iidiphozithi zexesha, kunye nokunye. Ngenkxaso-mali, ixabiso lezabelo zakho liya kuhlaziywa ngexesha lokwenyani, ukuze ufumane umfanekiso opheleleyo wesikhundla sakho nangaliphi na ixesha.
Guqula iimali ezinamaphepha
Omnye umsebenzi omkhulu weGoogle Sheets kukuba unokuguqula iimali ngexesha langempela. Unokwenza oku ngokuchwetheza kwibar yesitokhwe "IMALI:" elandelwa ziisimboli zeemali ezimbini ofuna ukuziguqula, njenge "USDGBP" okanye "EURJPY". Unokujonga kwakhona idatha yemali yembali ngokukhetha umhla.
Umzekelo, ukuba uhlala eYurophu kwaye ufuna ukuguqula iidola zaseMelika zibe zii-Euro, kuya kufuneka uchwetheze =GOOGLEFINANCE("CURRENCY:USDEUR")Eli nani liphinda-phindwe ngesixa seedola zase-US ozithumelayo.
Oku kuneendlela ezininzi zokusetyenziswa ngaphandle korhwebo lwe-forex. Umzekelo, ukuba ishishini lakho libandakanya ukuhlawulwa ngemali eyahlukileyo, unokuseta i-invoyisi eziguqula ngokuzenzekelayo iintlawulo ozifumanayo zibe yimali yasekhaya.
