Unlocking Financial Analytics and Critical Thinking Skills
Dive into the world of financial analytics, critical thinking, and programming concepts with a focus on loops, procedures, and functions. Explore the key concepts, learning objectives, and best practices to enhance your skills in coding and finance. Simplify and streamline your processes for more efficient results.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
Financial Analytics Subs & Functions Stefano Grazioli
Critical thinking Going well Teams? EasyMeter 2
You Do The Talking Name, academics Learning objectives Comfort with coding Comfort with finance 3
Financial Analytics WINIT What Is New In Technology?
Key concepts (orange words) Activity diagram Variable Variable type
Learning Objectives Loops For Next Do While Procedures Subs Functions Conditionals If Then Select Case Objects Properties Methods 6
Procedures: Financial Analytics Functions and Subs Simplify! Reuse!
Program A Program B Line of code Longer line of code Longer line of code Line Line Longer line of code Longer line of code Longer line of code Line Line Line Longer line of code Much longer line of code Much longer line of code Longer line of code Line Line Line Longer line of code Longer line of code Longer line of code Line Line Longer line of code Much longer line of code Longer line of code Line Line Longer line of code Longer line of code Longer line of code Line Line Much longer line of code Longer line of code Line Line Line Longer line of code Much longer line of code Longer line of code Line Longer line of code Much longer line of code Longer line of code Line Line Line Line Longer line of code Much longer line of code Line Line Line Longer line of code Much longer line of code Line Line Longer line of code Longer line of code Longer line of code Line Line Longer line of code Much longer line of cod Much longer line of code Longer line of code Line Line Longer line of code Much longer line of code 69 lines of code Line of code Longer line of code Longer line of code Line Call SUB C Line Longer line of code Much longer line of code Much longer line of code Longer line of code Line Line Call SUB C Longer line of code Much longer line of code Longer line of code Line Call SUB C Much longer line of code Longer line of code Line Line Line Longer line of code Much longer line of code Longer line of code Line Longer line of code Much longer line of code Longer line of code Line Line Line Line Longer line of code Much longer line of code Line Line Line Longer line of code Much longer line of code Line Call SUB C Longer line of code Much longer line of cod Much longer line of code Longer line of code Line Line Longer line of code Much longer line of code SUB C Line Longer line of code Longer line of code Longer line of code Line Line 55 lines of code 20% less writing - No reinventing - Fewer errors - Single location for changes
Functions are programs that return values Example built- in function Keyword Argument 9
Implementing SUM Security: private vs. public Function name Argument Type of info returned Example use of the function in a larger program 10
You can create your own functions Arguments, with arbitrary names Security: private vs. public Arbitrary name Keyword Example of use inside a larger program 11
Subs do not return values Security: private vs. public Argument, with arbitrary name Arbitrary name Keyword Example of use inside a larger program 13
Variables and Parameters Variables have a lifecycle / scope Parameters are a special type of variable: used as input to subs and functions, do not need a DIM Find the vars and params in here Private Sub Button1_Click Dim inputFromUser As String inputFromUser = InputBox("Please enter your name") ShowConfirmation(inputFromUser) End Sub Private Sub ShowConfirmation(someText As String) Range("A1").Value = "You entered: " + someText End Sub 14
Financial Analytics WINIT What Is New In Technology?
