Ungalandelela kanjani izitoko usebenzisa i-Google AmaSpredishithi:
Omunye wemisebenzi eyaziwa kancane ku Google AmaSpredishithi yi-GOOGLEFINANCE, ekuvumela ukuthi ulandelele idatha yesitoko yamanje noma yomlando emakethe yamasheya. Nansi indlela yokuyisebenzisa.
Yini i-Google Finance?
Ezezimali iyithuluzi lesikhathi sangempela le-Google elibonisa ulwazi lwamanje lwemakethe futhi liqoqe izindaba zebhizinisi. Manje isihlanganiswe noSesho lwe-Google, ngakho-ke uma usesha uphawu lwethikha lwenkampani ethile ku-Google njenge-WMT ye-Walmart noma i-AAPL ye-Apple, uzobona ngokushesha izintengo zesitoko kanye nedatha yomlando yalokho kuphepha. Ungachofoza kwesinye salezi zitoko ukuze uye ekhasini Lezezimali lenkampani le-Google, elibonisa izindaba zezezimali zenkampani kanye nezindaba ezihlobene, futhi likuvumela ukuthi uqhathanise nezinye izimpahla.
Nakuba kukhona amanye, amathuluzi anamandla kakhulu ongawasebenzisa ukuze ulandelele izibambiso, i-Google Finance iyona kuphela engahlanganisa ngempumelelo ne-Google AmaSpredishithi. Noma ngabe ungumfundi wesitoko noma ungumhwebi ongumakad' ebona, lokhu kuhlanganiswa kuyindlela elula yokungenisa nokuqapha idatha yesitoko kuspredishithi.
Nokho, ukuhlanganiswa kwe-Google Finance AmaSpredishithi kutholakala kuphela ngesiNgisi futhi akubandakanyi ukushintshana kwamazwe ngamazwe okwamanje. Ngakho-ke uma ufuna ukubhekana nokuhwebelana kwesitoko sase-Asia noma saseYurophu, lokhu kungase kungabi inketho engcono kakhulu kuwe.
Ukusebenza Kwezezimali ze-Google
Umsebenzi odonsa idatha yesitoko ubizwa ngokuthi GOOGLEFINANCE. I-syntax yomsebenzi ilula kakhulu futhi isebenzisa izimpikiswano ezinhlanu, ezine kuzo ozikhethela zona.
Ingxabano yokuqala uphawu lwesikhombi. Lawa amathokheni izinkampani ezinawo uma zifaka ohlwini emakethe yamasheya, njenge-GOOG ye-Google noma i-BAC ye-Bank of America. Ungaphinda ucacise i-exchange lapho isitoko osikhethile sifakwe ohlwini ukuze ugweme ukungafani. Njengoba iBank of America isohlwini lweNew York Stock Exchange, bhala "NYSE: BAC".
Ukuze uthole izimpawu zesitoko nokuhwebelana kwesitoko oyifunayo, kuzodingeka wenze ucwaningo oluthile. Ungayisesha ku-Google Finance noma ithuluzi olikhethile lokuphatha iphothifoliyo.
I-agumenti yesibili isibaluli ofisa ukusibonisa. Ngokuzenzakalelayo, isethwe kokuthi "inani" uma uyishiya ingenalutho. Nazi ezinye zezibaluli ongazikhipha ngomsebenzi:
- intengo: Intengo yesitoko yangempela ngesikhathi sangempela.
- usayizi: ivolumu yokuhweba yamanje.
- phezulu: Intengo ephezulu yosuku lwamanje noma olukhethiwe.
- Phansi: Intengo ephansi yamanje noma ekhethiwe yosuku.
- usayizi: Isilinganiso somthamo wokuhweba wansuku zonke.
- isb. isilinganiso senani kuya-kumaholo.
- eps: Iholo ngesheya ngalinye.
Qaphela ukuthi izibaluli ongazibuka ziyahlukahluka kuye ngokuthi usebenzisa idatha yamanje noma yomlando. Ngezansi Uhlu olugcwele lwezici ongayisebenzisela ukuphikisana. Kubalulekile ukukhumbula ukuthi idatha yamanje ibuyekezwa njalo ngemizuzu engu-15, ngakho-ke akusona isikhathi sangempela ngokuphelele.
Impikiswano yesithathu idethi yokuqala, esebenza kuphela uma usebenzisa idatha yomlando. Ungathayipha okuthi "TODAY()" noma ukushiye kungenalutho ukuze ubuke idatha yesikhathi sangempela. I-agumenti yesine icacisa idethi yokugcina noma inombolo yezinsuku kusukela ngedethi yokuqala. Uma kushiywe kungenalutho, umsebenzi uzobuyisela idatha kusukela ngosuku olulodwa.
I-agumenti yokugcina isikhawu, esikuvumela ukuthi ucacise imvamisa yedatha. Ungayisetha kokuthi "nsuku zonke" noma "njalo ngeviki".
Into eyodwa okufanele uyiqaphele ukuthi i-Google AmaSpredishithi iphatha uphawu lwekhesa nezimpikiswano zesibaluli njengombhalo, ngakho qiniseka ukuthi ubeka izingcaphuno eduze kwazo, noma uzothola iphutha.
Ukulandelela i-inventory kuyasebenza
Kulesi sibonelo, ake sithi ufuna ukuthola intengo yamanje yesitoko se-Facebook. I-Facebook isohlwini lwe-NASDAQ enophawu lwethikha u-FB. Kulokhu, uzobhala impikiswano yokuqala ngokuthi “NASDAQ:FB” kanye “nenani” njengesibaluli. Ngakho-ke ifomula yalokhu ingaba =GOOGLEFINANCE("NASDAQ:FB","price").
Uma ubufuna ukubonisa izintengo zokuvala zansuku zonke zeviki elithile, njengeviki eliqala ngo-Okthoba 15, 2018, ungacacisa ibanga ledethi kuma-agumenti wesithathu nowesine. iba wuphawu lwaso =GOOGLEFINANCE("NASDAQ:FB","price",DATE(2018,10,15),DATE(2018,10,20)). Qaphela ukuthi ukubuka Kwedatha Yomlando kunweba ulwazi olukhiqiziwe lube idatha yamalungu afanayo, ethatha amaseli aseduze.
Ungasebenzisa futhi umsebenzi ukukhiqiza ngokuzenzakalelayo idatha yohlu lwesitoko. Vele ubhale izinkomba kukholamu, bese usebenzisa amaseli kumpikiswano yakho yokuqala. Njengoba uphawu lwekhesa likuseli C4, uzoluthayipha =GOOGLEFINANCE(C4,"price"). Ngezansi uhlu lwezitoko ezinezintengo ezihambisanayo zamanje.
Uma ufuna ukulandelela uhlu lwezibaluli, ungazibhala ngamaseli ahlukene njengasesithombeni esingenhla. Bese, ubopha i-agumenti yesibili kuseli ngegama lesibaluli. Ngeseli lentengo le-NYSE:IBM esibonelweni esingezansi, ifomula izoba =GOOGLEFINANCE(C$2,$B5).
Khulisa i-Google AmaSpredishithi
Ingxenye engcono kakhulu yokuba nesitoko sakho ku-Google AmaSpredishithi ukuthi ungasebenzisa... Amathuluzi okucubungula idatha ezahlukene kuwo.
Ngokwesibonelo, ake sithi ufuna ukusebenzisa i-Google AmaSpredishithi ukuze ulandelele inani lazo zonke izimpahla zakho zezezimali, njengezitoko, ama-akhawunti okulondoloza, amadiphozithi esikhathi, nokuningi. Ngoxhaso lwezimali, intengo yamasheya akho izobuyekezwa ngesikhathi sangempela, ukuze uthole isithombe esiphelele sesikhundla sakho noma kunini.
Guqula izinhlamvu zemali ngamaphepha
Omunye umsebenzi omuhle we-Google AmaSpredishithi ukuthi ingakwazi ukuguqula izimali ngesikhathi sangempela. Ungakwenza lokhu ngokuthayipha kubha yesitoko ethi “CURRENCY:” elandelwa yizimpawu zezinhlobo zemali ezimbili ofuna ukuziguqula, njengokuthi “USDGBP” noma “EURJPY”. Ungakwazi futhi ukubuka idatha yemali yomlando ngokukhetha idethi.
Isibonelo, uma uhlala e-Europe futhi ufuna ukuguqula amanye amadola ase-US abe ama-Euro, kuzomele uthayiphe =GOOGLEFINANCE("CURRENCY:USDEUR")Le nombolo iphindwe ngenani lamadola ase-US owadluliselayo.
Lokhu kunamacala amaningi okusetshenziswa ngaphandle kokuhweba kwe-forex. Isibonelo, uma ulayini wakho webhizinisi ubandakanya ukukhokhelwa ngohlobo lwemali oluhlukile, ungasetha i-invoyisi eguqulela ngokuzenzakalelayo izinkokhelo ozitholayo zibe yimali yasendaweni yangakini.
