Udemy Certificate 0

Stocks & Crypto: In Google Spreadsheet only with formulas

Name: Stocks & Crypto: In Google Spreadsheet only with formulas
Price: 34.99 USD
Availability: InStock

About this course

That's the only asset allocation you'll need. This course will teach you everything you need to know to stay up to date with your asset management of stocks, cryptos, and precious metals. With this overview, you can keep track of your finances anytime and from anywhere.If you have completed this course, then:you can display your current deposit valueyou can you create a watchlist with purchase decisionyou can you show a historical price history with a trend lineyou can you create a currency converter with showing you the current currency rateyou can you evaluate dividends or income distributions from your bank statementyou can import crypto assets as well as altcoins from various external sourcesWhat we go through in the course:Get to know GOOGLEFINANCE formulaQuery stocks and cryptos on various exchanges with GOOGLEFINANCE.Query historical data.Use SUMIF and SUMIFS functions to create automated evaluationsQuery external data with the IMPORTXML functionPrepare imported data with the LEFT and RIGHT function.Convert imported data to a number with VALUE functionCatch errors of functions and external data with IF ERRORUse INDEX function for trimming table valuesQuerverweise zu anderen Tabellenblätter vornehmenMake cross-references to other spreadsheetsWhy Google Sheets?Because you have access to your financial overview anytime and anywhere there is internetYou can access Google Drive on nearly every deviceGoogle Spreadsheet as well as all functions and used interfaces are free of chargeThe interfac

62/100

CourseAsk score

What the provider tells you: 38/45
Who stands behind it: 8/35
How complete the listing is: 16/20

Scores how much the provider publishes and who stands behind it — not how well it is taught.

What you'll learn

create a watchlist with purchase decisions
display current deposit value
show historical price trends
evaluate dividends and income distributions
import and manage crypto assets
use various formulas for data analysis

Financial Analysis #data analysis #cryptocurrency #financial analysis #asset management #data import #google sheets #formulas #stocks #investment tracking #googlefinance formula #watchlist creation #historical price tracking #dividends evaluation

$34.99

Price shown by Udemy — confirm on their site.

Enroll on Udemy

You'll be redirected to Udemy to complete enrollment.