txheem
Cia peb xav tias koj tau pom kev lag luam kev nkag siab thiab kev xav thiab yuav ntau feem ntawm qee qhov cryptocurrency (piv txwv li bitcoin tib lub sijhawm) yav dhau los. Nyob rau hauv daim ntawv ntawm lub rooj ntse, koj "kev nqis peev portfolio" zoo li no:
Kev Ua Haujlwm: txhawm rau ntsuas tus nqi tam sim no ntawm koj cov peev txheej ntawm tus nqi tam sim no ntawm cryptocurrency. Peb yuav kawm cov chav kawm hauv Is Taws Nem los ntawm txhua qhov chaw tsim nyog (piv, exchanger) thiab nruab nrab rau kev ntseeg tau.
Ib qho ntawm cov kev daws teeb meem - qhov kev thov web classic - Kuv twb tau txiav txim siab hauv kev nthuav dav siv cov piv txwv ntawm kev hloov pauv tus nqi. Tam sim no cia peb sim, rau kev hloov pauv, siv lwm txoj hauv kev - Lub Zog Query add-in, uas yog qhov zoo tagnrho rau kev xa cov ntaub ntawv rau hauv Excel los ntawm lub ntiaj teb sab nraud, suav nrog hauv Is Taws Nem.
Xaiv ib qhov chaw los import
Los ntawm qhov chaw peb yuav coj cov ntaub ntawv - qhov no, los ntawm thiab loj, tsis muaj teeb meem. Cov lus nug ntawm Excel lub vev xaib classic yog qhov xav tau heev ntawm cov qauv thiab tsim sab hauv ntawm nplooj ntawv web thiab qee zaum tsis ua haujlwm ntawm txhua qhov chaw. Lub zog Query yog ntau ntau omnivorous hauv qhov teeb meem no. Yog li koj tuaj yeem coj tus nqi nruab nrab yuav xaiv los ntawm:
- nyob rau hauv exchangers www.bestchange.ru - ib tug loj xaiv ntawm kev xaiv, tsawg heev txaus ntshai, tab sis tsis yog ib tug heev profitable pauv tus nqi
- los ntawm kev lag luam platform www.localbitcoins.net - me ntsis kev pheej hmoo, tab sis tus nqi zoo dua
- los ntawm kev sib pauv lub vev xaib - yog tias koj pauv ncaj qha ntawm kev sib pauv, ces koj tsis xav tau tsab xov xwm no 🙂
Ua ntej, cia peb qhib qhov chaw peb xav tau hauv qhov browser. Cia peb ua, rau qhov tseeb, kev lag luam platform localbitcoins.net. Xaiv lub tab saum toj kawg nkaus Kev muag khoom sai thiab kev xaiv Hloov mus los ntawm ib lub txhab nyiaj tshwj xeeb (los yog lwm yam koj xav tau) thiab nias lub pob Nrhiav:
Tam sim no koj yuav tsum luam qhov chaw nyob ntawm nplooj ntawv uas tshwm rau hauv daim ntawv teev npe, vim. nws muaj tag nrho cov kev thov uas peb xav tau:
https://localbitcoins.net/instant-bitcoins/?action=muag&country_code=RU&tau=¤cy=tshiav&place_country=RU& online_provider =SPECIFIC_BANK&find-offers=NrhiavTom qab ntawd nws mus txog Power Query.
Importing ib chav kawm rau hauv Excel siv Power Query
Yog tias koj muaj Excel 2010-2013 thiab Lub Hwj Chim Query tau teeb tsa raws li kev sib cais ntxiv, tom qab ntawd cov lus txib peb xav tau yog nyob ntawm tab ntawm tib lub npe - Lub Zog Lus Nug. Yog tias koj muaj Excel 2016, tom qab ntawd hauv tab Cov ntaub ntawv (Hnub) nias lub pob Los ntawm Internet (Los ntawm Internet). Nyob rau hauv lub qhov rais uas tshwm ces koj yuav tsum tau muab tshuaj txhuam qhov web page chaw nyob los ntawm cov kab lus dhau los thiab nias OK:
Tom qab txheeb xyuas cov nplooj ntawv web, Power Query yuav tso saib lub qhov rais nrog cov npe ntawm cov ntxhuav uas tuaj yeem raug xa tawm. Koj yuav tsum nrhiav cov lus xav tau hauv cov npe ntawm sab laug (muaj ob peb ntawm lawv), tsom mus rau saib ua ntej ntawm sab xis, thiab tom qab ntawd nyem lub pob hauv qab no kho (Kho kom raug):
Tom qab ntawd, lub qhov rais tseem ceeb ntawm Lub Hwj Chim Query query editor yuav qhib, uas peb tuaj yeem xaiv tsuas yog cov kab tsim nyog thiab nruab nrab tus nqi yuav khoom dua lawv:
Kuv pom zoo kom tam sim renaming peb qhov kev thov nyob rau hauv lub vaj huam sib luag ntawm sab xis, muab nws lub npe zoo:
Lim thiab ntxuav cov ntaub ntawv
Nyob rau yav tom ntej, peb tsuas yog xav tau kab nrog cov lus piav qhia txoj kev them nyiaj thiab tus nqi yuav khoom Nqe / BTC - yog li koj tuaj yeem paub qhov txawv ntawm lawv ob qho tib si Ctrl thiab los ntawm txoj cai-nias ntawm lawv, xaiv cov lus txib Tshem tawm lwm kab (Tshem tawm lwm kab) - Txhua kab yuav raug tshem tawm tshwj tsis yog rau cov uas tau xaiv.
Cia peb hais tias peb xav xaiv tsuas yog cov tub luam uas ua haujlwm los ntawm Sberbank. Cov lim dej yog qhov paub zoo, tab sis qhov nuance yog tias cov lim hauv Power Query yog cov ntaub ntawv nkag siab, piv txwv li Sberbank, Sberbank thiab Sberbank tsis zoo ib yam rau nws. Yog li ntawd, ua ntej xaiv cov kab tsim nyog, cia peb nqa cov ntaub ntawv ntawm tag nrho cov lus piav qhia rau ib daim ntawv. Ua li no, koj yuav tsum xaiv ib kem txoj kev them nyiaj thiab ntawm lub tab transformation xaiv ib pab neeg Hom ntawv - tus lej qis (Transform — Format — Lower case):
Tam sim no lim los ntawm kab txoj kev them nyiaj siv kev xaiv Text Filters – Muaj (Text filters — Muaj):
Nyob rau hauv lub qhov rais lim, tam sim ntawd hloov los ntawm saum toj no mus rau hom Ntxiv rau (Tshaj) thiab qhia peb txoj cai rau kev xaiv:
Raws li koj tuaj yeem twv, los ntawm kev ua qhov no peb xaiv tag nrho cov kab uas lo lus "sber" muaj nyob rau hauv lossis lus Askiv, ntxiv rau cov neeg ua haujlwm hauv lub txhab nyiaj. Tsis txhob hnov qab teeb tsa qhov kev sib txuas lus ntawm sab laug Or (LOSSIS) es tsis txhob И (Thiab) Txwv tsis pub, txoj cai yuav tsis ua haujlwm raug. Tom qab nias rau OK Tsuas yog cov kev xaiv uas peb xav tau yuav tsum nyob twj ywm ntawm qhov screen:
Tam sim no tshem cov kab txoj kev them nyiaj txoj nyem rau ntawm kab ntawv header Rho tawm kab (Tshem tawm kab) thiab ua hauj lwm ntxiv nrog rau seem ib kem ntawm cov kev kawm:
Qhov teeb meem nrog nws yog tias muaj, ntxiv rau tus lej, kuj tseem muaj kev tsim txiaj. Qhov no tuaj yeem ntxuav tau yooj yim nrog kev hloov pauv yooj yim los ntawm txoj cai-nias ntawm kab ntawv kab lus thiab xaiv cov lus txib Hloov cov nqi (Hloov cov nqi):
Cov lej tau txais tom qab tshem tawm ntawm RUB, qhov tseeb, tseem tsis tau muaj tus lej, vim tias lawv siv cov txheej txheem tsis raug cai. Qhov no tuaj yeem kho tau los ntawm nias lub pob hom hauv lub rooj header thiab tom qab ntawd xaiv qhov kev xaiv Siv Thaj Chaw (Siv cov neeg hauv zos):
Qhov chaw tsim nyog tshaj plaws yuav yog Lus Askiv (Tebchaws Asmeskas) thiab hom ntaub ntawv - Дtus zauv pes tsawg:
Tom qab txhaj rau OK peb yuav tau txais tus lej tag nrho ntawm tus nqi yuav khoom:
Nws tseem yuav suav qhov nruab nrab rau lawv ntawm lub tab Hloov pauv - Txheeb cais - nruab nrab (Transform — Statistics — Nruab nrab) thiab upload tus lej tshwm sim rau daim ntawv nrog cov lus txib Tsev - Kaw thiab Load - Kaw thiab Load hauv… (Tsev — Kaw & Load — Kaw & Load To…):
Tam sim no peb tuaj yeem ntxiv qhov txuas mus rau tus nqi rub tawm hauv cov qauv rau peb cov ntaub ntawv portfolio thiab suav qhov sib txawv ntawm tus nqi rau tag nrho peb cov peev txheej tam sim no:
Tam sim no koj tuaj yeem qhib cov ntaub ntawv no ib ntus, right-click ntawm qhov tam sim ntawd thiab xaiv cov lus txib Hloov tshiab & Txuag (Refresh), saib cov kev hloov pauv uas yuav tau txais kev thauj mus los rau hauv peb lub rooj.
PS
Raws li koj tau yooj yim xav, raws nraim tib txoj kev koj tuaj yeem import tus nqi tsis yog bitcoin xwb, tab sis kuj muaj lwm yam txiaj, Tshuag lossis kev ruaj ntseg. Qhov tseem ceeb tshaj plaws yog nrhiav qhov chaw tsim nyog thiab tsim cov lus nug, thiab tom qab ntawd ntse Power Query yuav ua txhua yam.
- Ntshuam pauv tus nqi los ntawm Internet
- Muaj nuj nqi kom tau txais tus nqi pauv rau ib hnub twg
- Sib sau cov rooj los ntawm cov ntaub ntawv sib txawv siv Power Query