10 Excel Functions for Data Analysis
April 11, 2024
Article
This course is part of Trading Strategies in Emerging Markets Specialization
Instructor: Ramabhadran Thirumalai
192,405 already enrolled
Included with
(1,781 reviews)
(1,781 reviews)
Add to your LinkedIn profile
4 assignments
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review
The purpose of this course is to equip you with the knowledge required to comprehend the financial statements of a company and understand the various transactions that take place in the stock market so that you can replicate the strategies discovered by the extant academic literature.
The first part of the course provides a brief introduction to financial statements and various common filings of firms. You will learn how to obtain information regarding a company's performance from them and use the information to build trading strategies. Next, you are taught basic asset pricing theories so that you will be able to calculate the expected returns of a stock or a portfolio. Finally, you will be introduced to the actual functioning of asset markets, type of players in the market, different types of orders and the efficient ways and opportune time to execute them, trading costs and ways of minimizing them, the concept of liquidity .etc. This knowledge is required to develop efficient algorithm to execute various trading strategies.
This module provides a brief introduction to financial statements and various common filings. These are the most important sources for obtaining information regarding a company's performance. Most strategies are indeed based on financial statements. After completing this module you will be able to get the important details from the balance sheets.
12 videos1 reading1 assignment1 discussion prompt
The purpose of this module is to equip you with the skills required to identify accounting information required for building trading strategies. After completing this module you will be able to calculate the key financial ratios.
5 videos1 reading1 assignment
Before you start trading, you should first be able to calculate the expected return from a stock. The expected return comes from various asset pricing models such as Capital Asset Pricing Model (CAPM), Arbitrage Pricing Theory (APT) and Fama-French Three Factor Model. The purpose of this module is to equip you with the skills required to calculate the expected returns of a stock (or) a portfolio. After completing this module you will be able to calculate the expected returns of a stock.
9 videos1 reading1 assignment1 discussion prompt
This module will provide a detailed introduction to the actual functioning of asset markets. The module will cover essential details such as type of players in the market, different type of orders and the efficient ways and opportune time to execute them, trading costs and ways of minimizing them, the concept of liquidity .etc. This is required to develop efficient algorithm to execute various trading strategies. After completing this module you will have a clear idea of different types of orders and which orders to use when.
11 videos1 reading1 assignment1 discussion prompt
We asked all learners to give feedback on our instructors based on the quality of their teaching style.
The Indian School of Business has successfully put India on the global map of management education by nurturing young leaders with an understanding of developing economies and the society at large. Through innovations in curricula and pedagogy to reflect the shifting business landscape, the ISB is committed to providing the best venue for management education to meet the growing need to develop young leaders who can manage global challenges.
Indian School of Business
Course
Interactive Brokers
Specialization
University of Illinois Urbana-Champaign
Build toward a degree
Course
University of Illinois Urbana-Champaign
Course
1,781 reviews
43.62%
30.60%
11.67%
5.89%
8.19%
Showing 3 of 1781
Reviewed on Aug 2, 2020
Good for beginner but would recommend to have a bit knowledge about trading as it will be easy to grasp, Also WEEK 3 will be very challenging as its just MATH
Reviewed on Oct 30, 2020
On the three it got i little bit complicated because it was a lack of information about a spetific topic (The CAPM) But the rest was really great. Thanks
Reviewed on Jul 24, 2021
The course is great and well structured. The only thing that might be lacking is it focuses on long term investment by analyzing balance sheet and not on the short term trading.
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Earn a degree from world-class universities - 100% online
Upskill your employees to excel in the digital economy
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.
These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work.
These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.
These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. If you do not allow these cookies we will not know when you have visited our site, and will not be able to monitor its performance.
These cookies enable the website to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.