Maitiro ekutevera mastock uchishandisa Google Sheets:
Rimwe remabasa mashoma anozivikanwa mu Google Mapepa ndeye GOOGLEFINANCE, iyo inokutendera kuti utarise zvazvino kana zvenhoroondo stock data mumusika wemasheya. Heino maitiro ekuishandisa.
Chii chinonzi Google Finance?
Zvemari ndicho cheGoogle-chaiyo-nguva chishandiso chinoratidza ruzivo rwemusika iripo uye inounganidza nhau dzebhizinesi. Iko zvino yakabatanidzwa neGoogle Kutsvaga, saka kana iwe ukatsvaga chiratidzo cheticker yeimwe kambani paGoogle senge WMT yeWalmart kana AAPL yeApple, iwe unobva waona ikozvino mitengo yemasheya uye nhoroondo data yechengetedzo iyoyo. Unogona kudzvanya pane chimwe chezvitokisi izvi kuti uende kuGoogle Finance peji rekambani, iro rinoratidza mari yekambani uye nhau dzine hukama, uye inoita kuti uzvienzanise nezvimwe zvinhu.
Nepo kune mamwe maturusi ane simba aunogona kushandisa kuronda chengetedzo, Google Finance ndiyo yega inogona kubatanidza zvinobudirira neGoogle Sheets. Kunyangwe iwe uri muchengeti wemasheya kana mutengesi ane ruzivo, iyi yekubatanidza ndiyo nzira iri nyore yekuunza nekutarisa stock data muspredishiti.
Nenzira, kubatanidzwa kweGoogle Finance Sheets kunongowanikwa muChirungu uye hakusanganisire kuchinjisa kwakawanda kwenyika. Saka kana iwe uchida kubata paAsia kana European stock exchanges, iyi inogona kunge isiri iyo yakanakira sarudzo kwauri.
Kuita kweGoogle Finance
Basa rinodhonza stock data rinonzi GOOGLEFINANCE. Syntax yebasa iri nyore uye inoshandisa nharo shanu, ina dzadzo dzinenge dziri dzesarudzo.
Nharo yekutanga ndiyo chiratidzo chekunongedza. Aya ndiwo maratidziro ane makambani paanonyora pamusika wemasheya, seGOOG yeGoogle kana BAC yeBank of America. Iwe unogona zvakare kutsanangura shanduko iyo yako yakasarudzwa stock yakanyorwa kuti udzivise kusawirirana. Sezvo Bank of America yakanyorwa paNew York Stock Exchange, nyora "NYSE: BAC".
Kuti uwane zviratidzo zvemasheya uye mastock exchanges aunoda, uchafanirwa kuita tsvagiridzo. Unogona kuitsvaga muGoogle Finance kana yako yakasarudzwa portfolio manejimendi chishandiso.
Nharo yechipiri ndiyo hunhu hwaunoda kuratidza. Nekumisikidza, inoiswa ku "mutengo" kana iwe ukaisiya isina chinhu. Heano mamwe ehumwe hunhu hwaunogona kuburitsa nebasa racho:
- mutengo: Chaiyo stock mutengo munguva chaiyo.
- saizi: ikozvino kutengesa vhoriyamu.
- kumusoro: Mutengo wepamusoro wezuva razvino kana rakasarudzwa.
- Pazasi: Ikozvino kana kusarudzwa mutengo wakaderera wezuva.
- saizi: Avhareji yemazuva ese yekutengesa huwandu.
- semuenzaniso: mutengo-kune-mubairo reshiyo.
- eps: Mihoro pamugove wega wega.
Ziva kuti hunhu hwaunokwanisa kuona hunosiyana zvichienderana nekuti uri kushandisa zvazvino here kana zvenhoroondo data. Pazasi Runyoro rwakazara rwezvinhu kuti iwe unogona kushandisa kune nharo. Zvakakosha kuyeuka kuti data iripo inovandudzwa maminitsi gumi nemashanu, saka haisi nguva chaiyo-chaiyo.
Nharo yechitatu izuva rekutanga, rinoshanda chete kana uri kushandisa nhoroondo data. Unogona kunyora "TODAY()" kana kuisiya isina chinhu kuti utarise data-nguva chaiyo. Nharo yechina inotsanangura zuva rekupedzisira kana nhamba yemazuva kubva pazuva rekutanga. Kana ikasiiwa isina chinhu, basa racho rinodzosa data kubva pazuva rimwe.
Nharo yekupedzisira ndiyo nguva, iyo inokubvumira kutsanangura kuwanda kwe data. Iwe unogona kuiisa ku "zuva nezuva" kana "vhiki nevhiki".
Chinhu chimwe chekucherechedza ndechekuti Google Sheets inobata chiratidzo checursor uye hunhu nharo semavara, saka ita shuwa kuti unoisa makotesheni pavari, kana iwe unowana kukanganisa.
Inventory tracking muchiito
Mumuenzaniso uyu, ngatiti iwe unoda kutsvaga mutengo uripo weFacebook stock. Facebook yakanyorwa paNASDAQ ine ticker chiratidzo FB. Muchiitiko ichi, iwe waizonyora nharo yekutanga se "NASDAQ:FB" pamwe chete ne "mutengo" sehunhu. Saka formula yeiyi ingave =GOOGLEFINANCE("NASDAQ:FB","price").
Kana iwe waida kuratidza mitengo yemazuva ese yekuvhara kwevhiki chaiyo, senge svondo rinotanga Gumiguru 15, 2018, iwe unotsanangura zuva renji munharo dzechitatu nechina. inova mucherechedzo wayo =GOOGLEFINANCE("NASDAQ:FB","price",DATE(2018,10,15),DATE(2018,10,20)). Ziva kuti iyo Historical Data view inowedzera ruzivo rwakagadzirwa kuita array data, inogara maseru ari pedyo.
Iwe unogona zvakare kushandisa basa racho kugadzira otomatiki data kune stock list. Nyora zviratidzi mukoramu, wobva washandisa maseru munharo yako yekutanga. Sezvo chiratidzo checursor chiri muchitokisi C4, iwe unochinyora =GOOGLEFINANCE(C4,"price"). Pazasi pane rondedzero yemasheya ane mitengo yazvino inowirirana.
Kana iwe uchida kuchengeta rondedzero yehunhu, unogona kuinyora mumaseru akasiyana sepamufananidzo uri pamusoro. Zvadaro, unosunga nharo yechipiri kune sero ine zita rehunhu. Kune sero remutengo weNYSE:IBM mumuenzaniso pazasi, fomula yacho ingave =GOOGLEFINANCE(C$2,$B5).
Kurisa Google Sheets
Chikamu chakanakisa chekuve nemasheya ako paGoogle Sheets ndechekuti iwe unogona kushandisa... Data processing tools zvakasiyana pazviri.
Semuyenzaniso, ngatitii unoda kushandisa Google Sheets kuona kukosha kwezvinhu zvako zvese zvemari, zvakaita semastock, maakaundi ekuchengeta, madhipoziti enguva, nezvimwe. Nekupa mari, mutengo wemasheya ako uchagadziridzwa munguva chaiyo, saka iwe unowana mufananidzo wakazara wechinzvimbo chako chero nguva.
Shandura mari nemapepa
Rimwe basa rakakura reGoogle Sheets nderekuti rinogona kushandura mari munguva chaiyo. Unogona kuita izvi nekunyora mustock bar "CURRENCY:" inoteverwa nezviratidzo zvemari mbiri dzaunoda kushandura, senge "USDGBP" kana "EURJPY". Iwe unogona zvakare kuona nhoroondo yemari data nekusarudza zuva.
Semuyenzaniso, kana uchigara kuEurope uye uchida kushandura mamwe madhora ekuAmerica kuita maEuro, unotofanira kutaipa =GOOGLEFINANCE("CURRENCY:USDEUR")Nhamba iyi inowedzerwa nehuwandu hwemadhora ekuAmerica auri kutamisa.
Izvi zvine akawanda ekushandisa kesi kunze kwekutengesa kwe forex. Semuenzaniso, kana mutsara webhizinesi rako uchisanganisira kubhadharwa neimwe mari, unogona kuseta inivhoisi inoshandura iyo mari yaunogamuchira mumari yako yemuno.
