Mukati
Ngatifungei kuti iwe wakaratidza bhizinesi pfungwa uye intuition uye wakatenga akati wandei zvikamu zveimwe cryptocurrency (iyo yakafanana bitcoin, semuenzaniso) munguva yakapfuura. Muchimiro chetafura yakangwara, yako "investment portfolio" inotaridzika seizvi:
Basa: kukurumidza kuongorora kukosha kwazvino kwekudyara kwako pachiyero chazvino che cryptocurrency. Isu tichatora kosi paInternet kubva kune chero saiti yakakodzera (exchange, exchanger) uye avhareji yekuvimbika.
Imwe yemhinduro - yemhando yewebhu chikumbiro - Ini ndatofunga zvakadzama ndichishandisa muenzaniso wekuunza mutengo wekuchinjana. Zvino ngatiedzei, kuitira shanduko, kushandisa imwe nzira - iyo Power Query add-in, iyo yakanakira kupinza data muExcel kubva kunze kwenyika, kusanganisira kubva kuInternet.
Kusarudza saiti yekuunza kunze
Kubva pane saiti yatinotora iyo data - izvi, zvakanyanya, hazvina basa. Yemhando yepamusoro Excel yewebhu mubvunzo inoda zvakanyanya pane chimiro uye dhizaini yemukati yewebhu peji inotengeswa kunze kwenyika uye dzimwe nguva haishande pane yega saiti. Power Query yakanyanya omnivorous munyaya iyi. Saka iwe unogona kutora avhareji yekutenga mutengo wekusarudza kubva:
- mune exchangers www.bestchange.ru - sarudzo yakakura yesarudzo, njodzi shoma, asi kwete ine mari yakawanda yekutsinhana.
- kubva pachikuva chekutengesa www.localbitcoins.net - njodzi shoma shoma, asi chiyero chiri nani
- kubva kune webhusaiti yekutsinhana - kana iwe uchitengeserana zvakananga pakutsinhana, saka hautomboda chinyorwa ichi 🙂
Kutanga, ngativhure saiti yatinoda mubrowser. Ngatitorei, kune kongiri, iyo yekutengesa chikuva localbitcoins.net. Sarudza iyo yepamusoro tab Kutengesa nekukurumidza uye sarudzo Transfers kuburikidza nebhangi chairo (kana chero chimwe chaunoda) uye tinya bhatani kutsvaka:
Zvino iwe unofanirwa kukopa kero yepeji inoonekwa kune clipboard, nekuti. ine ese maparameter ekukumbira atinoda:
https://localbitcoins.net/instant-bitcoins/?action=tengesa&country_code=RU&amount=¤cy=MAD&nzvimbo_nyika=RU& online_provider=SPECIFIC_BANK&find-offers=TsvagaZvadaro zviri kumusoro Power Query.
Kupinza kosi muExcel uchishandisa Power Query
Kana iwe uine Excel 2010-2013 uye Power Query yakaiswa seyakasiyana yekuwedzera-mukati, saka murairo watinoda uri pabhu rezita rimwe chete - Simba Query. Kana iwe uine Excel 2016, ipapo pane tab Data (Zuva) dzvanya bhatani Kubva paInternet (Kubva paInternet). Muhwindo rinoonekwa ipapo iwe unofanirwa kunamira iyo yakakopwa peji kero yewebhu kubva pandima yapfuura uye tinya OK:
Mushure mekupatsanura peji rewebhu, Power Query icharatidza hwindo rine runyoro rwematafura anogona kutengwa kunze kwenyika. Iwe unofanirwa kutsvaga tafura inodiwa mune runyorwa kuruboshwe (kune akati wandei), uchitarisa pane preview kurudyi, wobva wadzvanya bhatani riri pazasi. Kururamisa (Hodha):
Mushure meizvozvo, iyo hwindo guru reiyo Power Query query edhita ichavhura, umo isu tinogona kusarudza chete mitsara inodiwa uye nepakati chiyero chekutenga pamusoro pavo:
Ini ndinokurudzira nekukasira kutumidza zita rechikumbiro chedu mupaneru kurudyi, ndichichipa zita rakapusa:
Kusefa nekuchenesa data
Mune ramangwana, tichangoda makoramu ane tsananguro Payment nzira uye mutengo wekutenga Mutengo / BTC - saka iwe unogona kusiyanisa zvakachengeteka iwo ese ari maviri Ctrl uye nekudzvanya-kurudyi pavari, sarudza murairo Dzima mamwe makoramu (Bvisa mamwe makoramu) - makoramu ese achadzimwa kunze kweakasarudzwa.
Ngatitii tinoda kusarudza chete avo vatengesi vanoshanda kuburikidza neSberbank. Iyo sefa chinhu chakajairika, asi iyo nuance ndeyekuti iyo sefa iri muSimba Query inyaya inonzwa, kureva Sberbank, Sberbank uye Sberbank hazvina kufanana kwaari. Nokudaro, tisati tasarudza mitsara inodiwa, ngatiunze nyaya yezvitsanangudzo zvose kune imwe fomu. Kuti uite izvi, unofanirwa kusarudza mbiru Payment nzira uye pa tab Kuchinja sarudza timu Format - vadiki (Shandura - Format - Lower kesi):
Zvino sefa nechikamu Payment nzira kushandisa sarudzo Masefa Mavara - Ane (Masefa ezvinyorwa - Ane):
Muhwindo resefa, pakarepo chinja kubva kumusoro kuenda kumodhi Kuwedzerwa (Yakasimudzwa) uye suma mitemo mitatu yekusarudza:
As you might guess, by doing this we select all the lines where the word “sber” is present in or English, plus those who work through any bank. Don’t forget to set a logical link on the left Or (KANA) panzvimbo И (Uye) Zvikasadaro, mutemo haushande nemazvo. Mushure mekudzvanya pa OK Chete sarudzo dzatinoda dzinofanira kuramba dziri pachiratidziri:
Zvino bvisa mbiru Payment nzira tinya kurudyi pamusoro wekorona Delete column (Bvisa column) uye shanda mberi nekoramu imwe yasara yemakosi:
Dambudziko naro nderekuti ipapo, kunze kwenhamba, kune zvakare zita remari. Izvi zvinogona kucheneswa nyore nyore nekutsiva nyore nekudzvanya-kurudyi pane iyo column musoro uye kusarudza iwo murairo. Kutsiva tsika (Siva tsika):
Nhamba dzakawanikwa mushure mekubviswa kweRUB, chokwadi, hadzisati dzave nhamba, nekuti dzinoshandisa dzisiri-standard delimiters. Izvi zvinogona kurapwa nekudzvanya bhatani refomati mumusoro wetafura uye wozosarudza sarudzo Uchishandisa Locale (Shandisa vemunharaunda):
Nzvimbo yakanyatsokodzera ingave Shona (US) uye rudzi rwe data - Дnhamba yedesimali:
Mushure mekunge mavharidza OK isu tichawana huwandu hwakazara hwehuwandu hwemitengo yekutenga:
Inoramba ichiverenga avhareji kwavari pane tab Shanduko – Statistics – Average (Shandura — Statistics — Avhareji) uye rodha nhamba inoguma kune pepa nemurairo Imba - Vhara uye Rodha - Vhara uye Rodha mukati... (Kumba - Vhara & Rodha - Vhara & Rodha Ku ...):
Iye zvino isu tinokwanisa kuwedzera chinongedzo kune chiyero chakadhawunirwa mufomula kune yedu portfolio tafura uye kuverenga mutsauko mukukosha kwekudyara kwedu kwese panguva iripo:
Iye zvino unogona kuvhura iyi faira nguva nenguva, tinya-kurudyi pane kukurumidza uye sarudza rairo Gadziridza & Chengeta (Refresh), cherechedza shanduko dzinozoiswa otomatiki mutafura yedu.
PS
Sezvaunogona kufungidzira zviri nyore, nenzira imwecheteyo iwe unogona kupinza chiyero kwete chete bitcoin, asiwo chero imwe mari, stock kana chengetedzo. Chinhu chikuru ndechekutsvaga saiti yakakodzera uye kuvaka mubvunzo, uye ipapo smart Power Query ichaita zvese.
- Pinza mitengo yekuchinja kubva paInternet
- Basa kuti uwane mutengo wekuchinja kune chero zuva rakapihwa
- Kuunganidza matafura kubva akasiyana mafaera uchishandisa Power Query