Chat with us, powered by LiveChat SwissBorg assets are very dynamic and in constant change due to the high rate of transactions and the volatility of the markets. As so it is fundamental to monitor the live balance - EssayAbode

01 Aug SwissBorg assets are very dynamic and in constant change due to the high rate of transactions and the volatility of the markets. As so it is fundamental to monitor the live balance

Posted at 15:38h in Business & Finance / Accounting by
  1. here are 2 questions in the shared Google Sheet file
    1. For Q1, you can provide the answer directly in the file.
    2. For Q2, please feel free to use VBA/Python/Excel/Google Sheet to solve
      it. If you use VBA/Python, please send us the script.

Questions

Question 1
SwissBorg assets are very dynamic and in constant change due to the high rate of transactions and the volatility of the markets. As so it is fundamental to monitor the live balances of our assets both in Fiat and Crypto. Using the table of assets in columns A & B , please present in Swiss Francs (CHF) a summary of: – the 5 top fiat assets, and – the 20 top crypto assets Note: the price of crypto currencies are provided in column G & H, assuming this is live rate. Please create a solution that is dynamic to future asset changes and helps to have less effort to maintain in the future.
Question 2
The table in Question 2 shows a list of the transactions from different wallets. We need to identify the transactions that are transfers between wallets as currently they appear as DEPOSIT and WITHDRAW For the transactions that meet all of the below criteria please change "Operation" column to "TRANSFER" (You can use VBA/Python/Excel/Google Sheet to do it): – same hash – same asset – one transaction is "DEPOSIT" and the other is "WITHDRAW" – same units with opposite side

Question 1

Assets Total balance (in units of fiat/crypto referenced) Crypto currencies Price in USD (per token)
AAVE 30 AAVE 398.26
ADA 311650 ADA 1.23
BAT 608706 BAT 0.82
BCH 1389 BCH 533.47
BCHA 688632 BCHA 16.68
BNB 5300 BNB 244.83
BTC 10 BTC 50701
BUSD 334300 BUSD 1
CAD 602421 CHP 0.01
CHF 165262 CHSB 1.15
CHP 963372 COMP 501.04
CHSB 12450300 CRO 0.15
COMP 150 DAI 1
CRO 80164 DASH 225.52
DAI 612919 EDO 0.12
DASH 27 ENJ 1.11
DKK 961895 EOS 3.88
EDO 908978 ETC 11.32
ENJ 64478 ETH 1593.64
EOS 62801 GRT 1.89
ETC 904441 KCS 4.69
ETH 130 KNC 1.81
EUR 883948 LINK 30.41
GBP 806954 NU 0.7
GRT 179832 OMG 4.86
HKD 330233 PAX 1
ILS 322787 PAXG 1722.73
JPY 52852 REN 1.12
KCS 971336 SRM 5.32
KNC 634464 SXP 2.58
LINK 136940 TRX 0.05
NU 681557 UNI 25.9
OMG 753797 USDC 1
PAX 89548 USDT 1
PAXG 35 VET 0.05
PLN 286981 XLM 0.42
REN 300603 XMR 219.34
RON 298445 XRP 0.45
SEK 562345
SGD 916102
SRM 297
SXP 132663
TRX 582222
UNI 103
USD 818778
USDC 570892
USDT 830420
VET 88801
XLM 940785
XMR 321
XRP 747582

Question 2

Date (UTC) Hour Operation Asset Units Unit Price (USD) Value Account Fee (Units) Fee (Asset) Fee (USD) Tx Hash Hash check Units check
01.09.20 8":"03" "PM DEPOSIT USDC 110,089.80 Kraken 2 0 USDC 0x977504e539ab023a873843a0dcf9ae9c40391ab896e1120ae17bcfb193d08747 1 FALSE
01.10.20 6":"42" "PM WITHDRAW BUSD -667.26 1.001048423 -667.9587312 HitBTC 1 0.05 BUSD 0.050052421 0x0811bed9149542a2d4415f3aff30529c2db0731c861ca31c934ce8f4e4852d1f 2 TRUE
01.10.20 6":"45" "PM DEPOSIT BUSD 667.26 Kraken 3 0 BUSD 0x0811bed9149542a2d4415f3aff30529c2db0731c861ca31c934ce8f4e4852d1f 2 TRUE
01.10.20 5":"44" "PM DEPOSIT CREAM 12.94 52.52091071 679.620478 HitBTC 1 0 0x9593fe7a69fa3b9d3b3c50ecad99a7bb03994323f7d348185e064a7e28381c6d 1 FALSE
01.10.20 12":"40" "AM DEPOSIT BNB 0.00 29.26385899 0.029263859 HitBTC 1 0 BNB 0xca0a8e1b1d958f3dc9ba5cb6ae0c07d7a9483eae7a3ffb9ab0a943a71ef952f4 1 FALSE
01.10.20 12":"42" "AM DEPOSIT BNB 2,084.91 29.26385899 61012.62251 HitBTC 1 0 BNB 0x3b6486c0d634ee9e0908bd5c91d992982c9edb3dc59f280d0a530a6bd13f1be4 1 FALSE
01.10.20 1":"42" "AM DEPOSIT KNC 9,992.49 0.984322475 9835.832483 HitBTC 1 0 ETH 0x4886b9fd455087e05352822848d456cbadd2cced498d03f0d5bfc5bb41649115 1 FALSE
01.10.20 1":"43" "AM DEPOSIT AAVE 29,985.13 0.537032262 16102.9822 HitBTC 1 0 ETH 0xc623e63d38566d81d71aa0cbb17cb6dc2e6065bef3d3d46c3b00d226d77e8599 1 FALSE
01.12.20 1":"33" "AM WITHDRAW CHSB -200,390.10 0.11000687 -22044.28773 Kucoin 4 109.9 CHSB 12.08975504 0x0840aba3cb549c4251ff858bf5800b1716ea872c8d5e4ae70af8484100475a08 1 FALSE
02.03.20 12":"55" "AM WITHDRAW CHSB -199,642.40 0.02345871 -4683.353165 Uniswap 2 357.6 CHSB 8.388834696 0xbffb6566bf4d2ec0c050341bb5545a75c248020c98fb78e75cbb9ba966286b12 1 FALSE
02.09.20 12":"48" "AM WITHDRAW ETH -3.00 HitBTC 1 0.007 ETH 0x5271895097b505a7be74bf0bc5ea18fe263c1b72257373ba19930b7deb080fa1 2 TRUE
02.09.20 12":"36" "AM DEPOSIT ETH 2.99 Kraken 4 0.0133 ETH 0x5271895097b505a7be74bf0bc5ea18fe263c1b72257373ba19930b7deb080fa1 2 FALSE
02.09.20 12":"42" "AM WITHDRAW USDC -9,000.00 HitBTC 1 4.7 USDC 0x2bfd82a4c8fed70c4115f5e9f4aa8bcbdee5e50f5ca38a3393f236abf070b5fa 2 TRUE
02.09.20 12":"42" "AM DEPOSIT USDC 9,000.00 Kraken 4 0 USDC 0x2bfd82a4c8fed70c4115f5e9f4aa8bcbdee5e50f5ca38a3393f236abf070b5fa 2 TRUE
02.10.20 9":"04" "PM DEPOSIT ETH 0.07 346.7285176 23.38743786 Kucoin 3 0 ETH 0x19dd5df8cc37bdfaace4e450a8bce9075affc85760321e0f0f9eb35624f749ae 1 FALSE
02.10.20 8":"29" "PM WITHDRAW CHSB -144,373.70 0.077308582 -11161.32609 Kucoin 4 126.3 CHSB 9.764073963 0x7bc9012a647b729eb0d665d8a8fcbd9ed164c8b56eaa769b3d3c775a14a85aa6 1 FALSE
02.10.20 4":"07" "PM DEPOSIT BTC 2.00 10526.25577 21052.51153 Kucoin 4 0 BTC 0x5cbdc1604e96a9ca5ae725515e7343fbbabe68469739532663b58985e1d14552 1 TRUE
02.11.20 7":"07" "PM WITHDRAW USDC -6,094.90 1.000101225 -6095.513755 HitBTC 1 3.19 USDC 3.190322907 0xf4a63aef758870df11c90e6acb112b337e30babc9a439d97d0548fed1d979a20 1 FALSE
02.11.20 6":"57" "PM WITHDRAW USDC -502.12 1.000128266 -502.1881053 HitBTC 1 3.19 USDC 3.190409168 0x8c2e62e5d259421cd9f292b021ff8af44a8a8a3a1887b5d363036194544d05e8 1 FALSE
02.11.20 7":"11" "PM WITHDRAW USDC -226.21 1.000101225 -226.2372985 HitBTC 1 3.19 USDC 3.190322907 0xcba49e9cb7c2d48969af5d6344140c0569576a6809f1a13dc6954540a9226043 1 FALSE
02.11.20 7":"06" "PM WITHDRAW USDC -1,159.33 1.000101225 -1159.451053 HitBTC 1 3.19 USDC 3.190322907 0x191030ab0e446277d34fcd9e7f2ce2362a2ada010925488ec2a871d46ed835ee 1 FALSE
02.11.20 7":"10&quo

Related Tags

Academic APA Assignment Business Capstone College Conclusion Course Day Discussion Double Spaced Essay English Finance General Graduate History Information Justify Literature Management Market Masters Math Minimum MLA Nursing Organizational Outline Pages Paper Presentation Questions Questionnaire Reference Response Response School Subject Slides Sources Student Support Times New Roman Title Topics Word Write Writing