Financial Analytics in Spreadsheets

Name: Financial Analytics in Spreadsheets
Brand: Careervira
Price: 150 USD
Availability: InStock
Rating: 1 (1 reviews)

via

DataCamp

Course Report

Find detailed report of this course which helps you make an informed decision on its relevance to your learning needs. Find out the course's popularity among Careervira users and the job roles that would find the course relevant for their upskilling here. You can also find how this course compares against similar courses and much more in the course report.

Visit Course Report

Course Features

Duration

4 hours

Delivery Method

Online

Available on

Limited Access

Accessibility

Mobile, Desktop, Laptop

Language

English

Subtitles

English

Level

Intermediate

Teaching Type

Self Paced

Video Content

4 hours

Course Description

Finance is about monitoring the progress of traded assets. This course will show you how to create a visual dashboard with spreadsheets that tracks financial securities' performance. We will discuss the hypothetical stock ABC, including its historical dividends and prices. It will be possible for you to visualize its prices and to calculate important reward and risk indicators. It will also show you whether your ABC investment has outperformed the benchmark. Spreadsheets can be used to create excellent monitoring tools for traders or financial analysts.

Course Overview

Virtual Labs

International Faculty

Post Course Interactions

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

Data Visualization in Spreadsheets

What You Will Learn

Learn how to build a graphical dashboard with spreadsheets to track the performance of financial securities

You will focus on historical prices and dividends of the hypothetical stock ABC

You will learn how to visualize its prices, how to measure essential reward and risk indicators, and see if your investment in ABC outperformed a benchmark index

Course Content

Expand all sections

Module 1: Monitoring historical prices

Module 2: Monitoring historical returns

Module 3: Monitoring the distribution of returns

Module 4: Benchmarking performance

Course Instructors

David Ardia

Professor of Quantitative Methods for Finance

David is professor of quantitative methods for finance. His research lies in the areas of econometrics, quantitative finance, and risk management. In 2018, he was elected Swiss risk manager of the ye...

Riccardo Mancini

Freelance Quantitative Analyst

Riccardo is a Market Risk Analyst for a financial services firm. He is passionate about coding in R, quantitative models applied to finance, andsoccer!