Pehea e ʻimi ai i nā waihona me ka Google Sheets:
ʻO kekahi o nā hana i ʻike ʻole ʻia ma Nā Pepa Google ʻo ia ʻo GOOGLEFINANCE, kahi e hiki ai iā ʻoe ke hahai i ka ʻikepili o kēia manawa a i ʻole ka mōʻaukala ma ka mākeke kūʻai. Eia pehea e hoʻohana ai.
He aha ka Google Waiwai?
ʻO ke kālā ka mea hana manawa maoli a Google e hōʻike ana i ka ʻike mākeke o kēia manawa a hōʻiliʻili i nā nūhou ʻoihana. Ua hui pū ʻia me Google Search, no laila inā ʻoe e ʻimi i kahi hōʻailona ticker no kahi hui kikoʻī ma Google e like me WMT no Walmart a i ʻole AAPL no Apple, e ʻike koke ʻoe i nā kumukūʻai kumukūʻai o kēia manawa a me ka ʻikepili mōʻaukala no kēlā palekana. Hiki iā ʻoe ke kaomi ma luna o kekahi o kēia mau waihona e hele i ka ʻaoʻao Waiwai Google o kahi hui, e hōʻike ana i ka ʻoihana kālā a me nā nūhou e pili ana, a hiki iā ʻoe ke hoʻohālikelike me nā waiwai ʻē aʻe.
ʻOiai aia nā mea hana ʻē aʻe, ʻoi aku ka ikaika e hiki ai iā ʻoe ke hoʻohana e nānā i nā palekana, ʻo Google Waiwai wale nō ka mea hiki ke hoʻohui pono me Google Sheets. Inā he mea kūʻai hou ʻoe a i ʻole he mea kūʻai aku i ʻike ʻia, ʻo kēia hoʻohui ʻana ke ala maʻalahi loa e hoʻokomo a nānā i ka ʻikepili waiwai i loko o kahi pālahalaha.
Ma ke ala, loaʻa wale ka Google Waiwai Sheets hoʻohui i ka ʻōlelo Pelekania a ʻaʻole i hoʻokomo i ka hapa nui o nā hoʻololi honua. No laila inā makemake ʻoe e hana i nā hoʻololi kūʻai kālā ʻAsia a ʻEulopa, ʻaʻole paha kēia ke koho maikaʻi loa iā ʻoe.
Nā hana kālā Google
ʻO ka hana e huki ana i ka ʻikepili waiwai i kapa ʻia ʻo GOOGLEFINANCE. He maʻalahi loa ka syntax o ka hana a hoʻohana ʻo ia i ʻelima mau manaʻo, ʻehā o ia mau koho.
ʻO ka hoʻopaʻapaʻa mua ka hōʻailona kuhikuhi. ʻO kēia nā hōʻailona i loaʻa i nā hui ke papa inoa lākou ma ka mākeke kūʻai, e like me GOOG no Google a i ʻole BAC no Bank of America. Hiki iā ʻoe ke kuhikuhi i ka hoʻololi ʻana i helu ʻia ai kāu waiwai i koho ʻia e pale aku i nā like ʻole. No ka mea ua helu ʻia ʻo Bank of America ma New York Stock Exchange, e ʻano "NYSE: BAC".
No ka loaʻa ʻana o nā hōʻailona waiwai a me nā hoʻololi waiwai āu e makemake ai, pono ʻoe e hana i kahi noiʻi. Hiki iā ʻoe ke ʻimi iā ia ma Google Finance a i ʻole kāu mea hana hoʻokele kōpili koho.
ʻO ka hoʻopaʻapaʻa ʻelua ke ʻano āu e makemake ai e hōʻike. Ma ka paʻamau, ua hoʻonohonoho ʻia i "kumukūʻai" inā waiho ʻoe i ka hakahaka. Eia kekahi mau hiʻohiʻona hiki iā ʻoe ke huki me ka hana:
- kumu kūʻai: Kūʻai kūʻai pololei i ka manawa maoli.
- ka nui: ka nui kālepa o kēia manawa.
- kiʻekiʻe: ʻO ke kumukūʻai kiʻekiʻe no kēia lā a i koho ʻia paha.
- Haʻahaʻa: ʻO ke kumu kūʻai haʻahaʻa i koho ʻia i kēia manawa no ka lā.
- ka nui: Awelika ka nui kālepa o kēlā me kēia lā.
- e laʻa: ʻO ka lakio kumu kūʻai.
- eps: Loaʻa i kēlā me kēia mahele.
E hoʻomaopopo he ʻokoʻa nā hiʻohiʻona āu e ʻike ai ma muli o ka hoʻohana ʻana i ka ʻikepili o kēia manawa a i ʻole ka mōʻaukala. Malalo Ka papa inoa piha o nā hiʻohiʻona hiki iā ʻoe ke hoʻohana no ka hoʻopaʻapaʻa. He mea nui e hoʻomanaʻo e hoʻonui ʻia ka ʻikepili o kēia manawa i kēlā me kēia 15 mau minuke, no laila ʻaʻole ia i ka manawa maoli.
ʻO ke kolu o ka hoʻopaʻapaʻa ʻo ia ka lā hoʻomaka, pili wale nō inā ʻoe e hoʻohana nei i ka ʻikepili mōʻaukala. Hiki iā ʻoe ke paʻi i ka "TODAY()" a i ʻole e waiho hakahaka e ʻike i ka ʻikepili manawa maoli. Hōʻike ka manaʻo ʻehā i ka lā hopena a i ʻole ka helu o nā lā mai ka lā hoʻomaka. Inā waiho hakahaka, e hoʻihoʻi ka hana i ka ʻikepili mai ka lā hoʻokahi.
ʻO ka hoʻopaʻapaʻa hope ʻo ia ka wā, kahi e hiki ai iā ʻoe ke kuhikuhi i ke alapine o ka ʻikepili. Hiki iā ʻoe ke hoʻonohonoho iā ia "i kēlā me kēia lā" a i ʻole "weekly".
Hoʻokahi mea e hoʻomaopopo ai, ʻo ka Google Sheets e mālama i ka hōʻailona cursor a me nā manaʻo hoʻopaʻapaʻa ma ke ʻano he kikokikona, no laila e ʻike pono ʻoe e kau i nā huaʻōlelo a puni lākou, a i ʻole e loaʻa iā ʻoe kahi hewa.
Ka hoʻokolo ʻana i nā waihona i ka hana
Ma kēia laʻana, e ʻōlelo mākou makemake ʻoe e ʻimi i ke kumukūʻai o kēia manawa o kahi waihona Facebook. Ua helu ʻia ʻo Facebook ma ka NASDAQ me ka hōʻailona ticker FB. I kēia hihia, e kākau ʻoe i ka hoʻopaʻapaʻa mua ʻo "NASDAQ:FB" me ka "kumukūʻai" ma ke ʻano he ʻano. No laila ʻo ke kumu no kēia =GOOGLEFINANCE("NASDAQ:FB","price").
Inā makemake ʻoe e hōʻike i nā kumukūʻai pani i kēlā me kēia lā no kahi pule kikoʻī, e like me ka pule e hoʻomaka ana ʻo ʻOkakopa 15, 2018, e kuhikuhi ʻoe i ka pae lā ma ke kolu a me ka hā. lilo i hoailona o ia mea =GOOGLEFINANCE("NASDAQ:FB","price",DATE(2018,10,15),DATE(2018,10,20)). E hoʻomanaʻo, hoʻonui ka ʻike ʻikepili Historical i ka ʻike i hana ʻia i loko o ka ʻikepili array, e noho ana i nā cell kokoke.
Hiki iā ʻoe ke hoʻohana i ka hana no ka hoʻopuka ʻana i ka ʻikepili no ka papa inoa o nā waihona. E kākau wale i nā hōʻailona ma kahi kolamu, a laila e hoʻohana i nā cell i kāu hoʻopaʻapaʻa mua. No ka mea aia ka hōʻailona cursor i loko o ke kelepona C4, e kikokiko ʻoe =GOOGLEFINANCE(C4,"price"). Aia ma lalo iho kahi papa inoa o nā waihona me ko lākou mau kumukūʻai kūpono i kēia manawa.
Inā makemake ʻoe e mālama i ka papa inoa o nā hiʻohiʻona, hiki iā ʻoe ke kākau iā lākou i loko o nā keena ʻokoʻa e like me ke kiʻi ma luna. A laila, hoʻopaʻa ʻoe i ka hoʻopaʻapaʻa ʻelua i ke kelepona me ka inoa ʻano. No ke kelepona kumu kūʻai no NYSE:IBM i ka laʻana ma lalo nei, ʻo ia ke kumu =GOOGLEFINANCE(C$2,$B5).
Hoʻonui i nā palapala Google
ʻO ka hapa maikaʻi loa o ka loaʻa ʻana o kāu mau waihona ma Google Sheets ʻo ia ka hiki iā ʻoe ke hoʻohana ... Mea hana hoʻoili ʻikepili ʻokoʻa ma luna.
No ka laʻana, e ʻōlelo mākou makemake ʻoe e hoʻohana i ka Google Sheets e nānā i ka waiwai o kāu mau waiwai kālā āpau, e like me nā waihona, nā waihona mālama kālā, nā waihona manawa, a me nā mea hou aku. Me ke kālā, e hoʻonui ʻia ke kumukūʻai o kāu mau ʻāpana i ka manawa maoli, no laila e loaʻa iā ʻoe ke kiʻi piha o kou kūlana i kēlā me kēia manawa.
E hoʻololi i nā kālā me nā pepa
ʻO kekahi hana nui a Google Sheets hiki iā ia ke hoʻololi i nā kālā i ka manawa maoli. Hiki iā ʻoe ke hana i kēia ma ke kaomi ʻana i ka pahu waihona "CURRENCY:" a ukali ʻia e nā hōʻailona o nā kālā ʻelua āu e makemake ai e hoʻololi, e like me "USDGBP" a i ʻole "EURJPY". Hiki iā ʻoe ke nānā i ka ʻikepili kālā mōʻaukala ma ke koho ʻana i kahi lā.
No ka laʻana, inā noho ʻoe i ʻEulopa a makemake ʻoe e hoʻololi i kekahi mau kālā US i Euro, pono ʻoe e paʻi =GOOGLEFINANCE("CURRENCY:USDEUR")Hoʻonui ʻia kēia helu me ka nui o nā kālā US āu e hoʻoili nei.
He nui nā hihia hoʻohana ma waho o ke kālepa forex. No ka laʻana, inā pili kāu laina o ka ʻoihana i ka loaʻa ʻana i kahi kālā ʻē aʻe, hiki iā ʻoe ke hoʻonohonoho i kahi invoice e hoʻololi aunoa i nā uku āu e loaʻa ai i kāu kālā kūloko.
