August 1, 2022

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

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.

2022Accountingtechchallenge-AccountantPosition.xlsx

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 Collepals.com Plagiarism Free Papers Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers. Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS Why Hire Collepals.com writers to do your paper? Quality- We are experienced and have access to ample research materials. We write plagiarism Free Content Confidential- We never share or sell your personal information to third parties. Support-Chat with us today! We are always waiting to answer all your questions. Calculate absorption costing income and variable costing income. Construct and prepare an income statement for a calendar year. Introduction Note: Accounting requires specific steps You are a supervisor at Regional Call Center’s Washington, DC, facility. Regional provides contract call center services for a number of companies, including banks and major retail Related Posts Uncategorized In this lab you will examine some of the mechanisms of evolution that lead to changes in fur color in mice. you’re required to fill out the ?Lab 10 datashee Uncategorized The selection of measures is an incredibly important aspect of program evaluation.? Discuss possible measures that could be used in your program evaluat Uncategorized Financial Analysis Purpose This analysis is an individual assignment where you will analyze your own company in terms of its financial position.? The easi Why Choose Us Best Essay Writing Services- Get Quality Homework Essay Paper at Discounted Prices At the risk of sounding immodest, we must point out that we have an elite team of writers. Ours isn’t a collection of individuals who are good at searching for information on the Internet and then conveniently re-writing the information obtained to barely beat Plagiarism Software. Who can’t do that? Our writers have strong academic backgrounds with regards to their areas of writing. A paper on History will only be handled by a writer who is trained in that field. A paper on health care can only be dealt with by a writer qualified on matters health care. Thesis papers will only be handled by Masters’ Degree holders while Dissertations will strictly be handled by PhD holders. With such a system, you needn’t worry about the quality of work. Quality isn’t just an option, it is the only option. We don’t just employ writers, we hire professionals. We have writers spread into all fields including but not limited to Philosophy, Economics, Business, Medicine, Nursing, Education, Technology, Tourism and Travels, Leadership, History, Poverty, Marketing, Climate Change, Social Justice, Chemistry, Mathematics, Literature, Accounting and Political Science. Our writers are also well trained to follow client instructions as well adhere to various writing conventional writing structures as per the demand of specific articles. They are also well versed with citation styles such as APA, MLA, Chicago, Harvard, and Oxford which come handy during the preparation of academic papers. They also have unrivalled skill in writing language be it UK English or USA English considering that they are native English speakers. You also needn’t worry about logical flow of thought, sentence structure as well as proper use of phrases. Our writers are also not the kind to decorate articles with unnecessary filler words. We respect your money and most importantly your trust in us. In writing, we will be precise and to the point and fill the paper with content as opposed to words aimed at beating the word count. Our shift-system also ensures that you get fresh writers each time you send a job. This helps overcome occupational hazards brought about by fatigue. Hence, quality will consistently be at the top. From our writers, you expect; good quality work, friendly service, timely deliveries, and adherence to client’s demands and specifications. Once you’ve submitted your writing requests, you can go take a stroll while waiting for our all-star team of writers and editors to submit top quality work. How Our Website Works Get an Essay from Us College Essays is the biggest affiliate and testbank for WriteDen. We hire writers from all over the world with an aim to give the best essays to our clients. Our writers will help you write all your homework. They will write your papers from scratch. We also have a team of editors who read each paper from our writers just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. Step 1 To make an Order you only need to click ORDER NOW and we will direct you to our Order Page. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline. Deadline range from 6 hours to 30 days. Step 2 Once done with writing your paper we will upload it to your account on our website and also forward a copy to your email. Step 3 Upon receiving your paper, review it and if any changes are needed contact us immediately. We offer unlimited revisions at no extra cost. Is it Safe to use our services? We never resell papers on this site. Meaning after your purchase you will get an original copy of your assignment and you have all the rights to use the paper. Pricing and Discounts Our price ranges from $8-$14 per page. If you are short of Budget, contact our Live Support for a Discount Code. All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure. Please note we do not have prewritten answers. We need some time to prepare a perfect essay for you. Recent Posts In this week’s reading, we have explored various pricing strategies (such as Value-based pricing, Competitive Pricing, Penetration Pricing, Cost-Oriented Pr In this lab you will examine some of the mechanisms of evolution that lead to changes in fur color in mice. you’re required to fill out the ?Lab 10 datashee In this assignment, students will pull together the capstone project change proposal components they have been working on throughout the course to create a In response to at least two of your peers, answer the following: Did you find your peers’ process and outcome metrics were linked appropriately? What d In order to analyze the data to answer your evaluation questions, you will need to collect the data and store the data in a database. This week you will be College Pal All Rights Reserved Terms and Conditions College pals.com Privacy Policy 2010-2018

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

Questions

Question 1

Question 2

Related Posts

In this lab you will examine some of the mechanisms of evolution that lead to changes in fur color in mice. you’re required to fill out the ?Lab 10 datashee

The selection of measures is an incredibly important aspect of program evaluation.? Discuss possible measures that could be used in your program evaluat

Financial Analysis Purpose This analysis is an individual assignment where you will analyze your own company in terms of its financial position.? The easi