- 25
- 86 230
Bram van der Kroft
เข้าร่วมเมื่อ 25 ก.พ. 2023
As a researcher and teacher, I get many questions on how to do simple statistical models in Finance. Therefore, I present you this Stata tutorials from Zero to Hero! In my channel, I discuss the most elementary to more advanced Stata data analytics tips and tricks for Practitioners, Students, and Researchers in Finance and Economics. The course lectures will start easy with uploading data into Stata and end with regression analyses and graphical applications.
Stata from Zero to Hero: A beginner guide to performing basic financial analysis and econ research
As an academic, I teach and do research at a university and often get questions on how to perform fundamental statistical, financial, or economic analyses.
This video shows you a 20-part tutorial on the use of Stata. This coding language is suitable for financial and economic analyses and can be applied to university projects or research applications.
This video shows you a 20-part tutorial on the use of Stata. This coding language is suitable for financial and economic analyses and can be applied to university projects or research applications.
มุมมอง: 26 046
วีดีโอ
FactSet Tutorial for Financial Applications and Data Analysis
มุมมอง 2Kปีที่แล้ว
This video explains how to install and operate FactSet. In the first part, I will explain how to download the software and install the Excel Plugin (a license is required, I am not affiliated) Subsequently, I will show how to collect a list of identifiers. Last, I will show how to collect financial and accounting information for the collected firm identifiers
FactSet Lecture 03: Collecting Historical Data Using Excel
มุมมอง 4.8Kปีที่แล้ว
This video shows you how to collect historical information in Excel. Suitable for undergraduate and graduate Economics, Finance, Accounting, and management.
FactSet Lecture 02 Collecting Identifiers Online
มุมมอง 1.4Kปีที่แล้ว
This video shows you how to retrieve a list of stock identifiers and static information from FactSet online. In the next video, I will show you how to collect historical information in Excel. Suitable for undergraduate and graduate Economics, Finance, Accounting, and management.
FactSet Lecture 01: Installing FactSet Excel
มุมมอง 3.9Kปีที่แล้ว
This video shows you how to install the FactSet application. In the following video, I show how to collect the list of stock identifiers and, in the video after that, how to collect historical information in Excel. Suitable for undergraduate and graduate Economics, Finance, Accounting, and management.
Stata Lecture 20: How to create your Graphs, Plots, and Images?
มุมมอง 1.4Kปีที่แล้ว
This video shows how to generate graphics in Stata to Excel or Latex using Outreg2. I will show you how to make line charts, scatter plots, bar charts, histograms, box plots, and pie charts. In addition, I will show you how to overlay multiple charts and how to combine and export graphs to png files. This lecture series is intended for economics, management, and finance application.
Stata Lecture 19: Exporting your Regression Analyses with Outreg2
มุมมอง 7Kปีที่แล้ว
This video shows how to export regression analyses in Stata to Excel or Latex using Outreg2. This lecture series is intended for economics, management, and finance application.
Stata Lecture 18: Regressions Analyses and Standard Errors for Financial applications
มุมมอง 1Kปีที่แล้ว
This video shows how to perform regression analyses in Stata. We will focus on OLS, fixed effects, random effects, interaction terms, and standard errors. This lecture series is intended for economics, management, and finance application.
Stata Lecture 17: Reducing dimensionality with the Collapse command
มุมมอง 578ปีที่แล้ว
This video shows you how to collapse data in Stata. The application is helpful in collapsing stock data across mutual funds or products across firms. This lecture series is intended for economics, management, and finance application.
Stata Lecture 16: How to Merge datasets and what can go wrong?
มุมมอง 3.4Kปีที่แล้ว
This video shows how to merge data in Stata. We will focus on its applications and potential pitfalls. This lecture series is intended for economics, management, and finance application.
Stata Lecture 15: Levering Egen and Bysort commands
มุมมอง 1.3Kปีที่แล้ว
This video shows the application of the Egen command in Stata. We will focus on its applications in generating means, maximums, minimums, groups, and counting of observations across groups. This lecture series is intended for economics, management, and finance application.
Stata Lecture 14: How to move across rows (leads and lags)?
มุมมอง 692ปีที่แล้ว
This video shows the application of [_n-1] commands in Stata. We will focus its applications on generating variables (stock returns) and dropping duplicate observations. This lecture series is intended for economics, management, and finance application.
Stata Lecture 13: Understanding Foreach, Forvalues, and Levelsof Loop
มุมมอง 5Kปีที่แล้ว
This video shows the application of Loops in Stata. We will focus on loops that work with variables or strings, loops over numbers, and loops over all distinct values in a variable. This lecture series is intended for economics, management, and finance application.
Stata Lecture 12: Working with Strings!
มุมมอง 1.1Kปีที่แล้ว
This video shows the application of String commands in Stata. We will focus on using the substr(), strlen(), and subinstr() commands. This lecture series is intended for economics, management, and finance application.
Stata Lecture 11: The Bysort command
มุมมอง 2.1Kปีที่แล้ว
This video shows the benefits of using the bysort command in Stata. This lecture series is intended for economics, management, and finance application.
Stata Lecture 10: What to do with DO files?
มุมมอง 772ปีที่แล้ว
Stata Lecture 10: What to do with DO files?
Stata Lecture 9: Help with the Help Function
มุมมอง 692ปีที่แล้ว
Stata Lecture 9: Help with the Help Function
Stata Lecture 8: How to master and export the Tabulate command
มุมมอง 2.2Kปีที่แล้ว
Stata Lecture 8: How to master and export the Tabulate command
Stata Lecture 7: Exporting Summary Statistics
มุมมอง 4.9Kปีที่แล้ว
Stata Lecture 7: Exporting Summary Statistics
Stata Lecture 6: Generating Summary Statistics
มุมมอง 2.1Kปีที่แล้ว
Stata Lecture 6: Generating Summary Statistics
Stata Lecture 5: Understanding String, Integer, and Date variable types!
มุมมอง 2.3Kปีที่แล้ว
Stata Lecture 5: Understanding String, Integer, and Date variable types!
Stata Lecture 4: Renaming and Removing variables.
มุมมอง 1.5Kปีที่แล้ว
Stata Lecture 4: Renaming and Removing variables.
Stata Lecture 3: How to generate variables?
มุมมอง 2.4Kปีที่แล้ว
Stata Lecture 3: How to generate variables?
Stata Lecture 2: How to import Excel/CSV data?
มุมมอง 3.2Kปีที่แล้ว
Stata Lecture 2: How to import Excel/CSV data?
Stata Lecture 1: How to effectively pre-clean data!
มุมมอง 4.4Kปีที่แล้ว
Stata Lecture 1: How to effectively pre-clean data!
Hello, there is one certain part about this video that I don't really get it which is the command: gen first_value = substr(rentsfyr,2,4) if substr(rentsfyr,6,1)==" " As I don't understand where the number "2,4" and "6,1" in the brackets coming from. Thank you!
Thank you very much for the tutorial
Hello Mr. I have a variable with 10 different values and I need, from each one these values, to create a table that contains data from another variable. Could you guide me in defining this procedure? Thank you very much!
Could you please tell how have you added row_number here?
gen row_number = _n
@@daniellearaujodeoliveira9647thank you!
Excellent presentation and sessions. Thank you so much and grateful for your contribution, From Nepal
Your screen is very unclear.
People creating such efficient important content have little followers. Shame on this generation.
Happy to be of help! It saves my students a lot of time in learning how to do basic statistical modelling, so I thought it would be work recording.
@@Kroft-Tutorials thanks sir kindly continue this series to advanced level.
received this error: command tab2x1 is unrecognized
Having same problem....
Very well done, thank you very much for your tutorial.
Glad it was helpful!
Man, you deserve more subscribers !!!
I appreciate that!
How can i get median p25 and p75 in this tabulation? Thanks for your video
For the summary command, use: sum var1 var2 ... varN, det For the tabulate, use tabstat var1 var2 ... varN, stat(n mean p25 p50 p75) col(stat)
The data used for working with strings is from?
bro you are just the best so far....thank you
Wow, thanks
Can you please share your do file editor? That would be easy to copy paste your command on student's sample data
Sir i am working on NSSO 61st round and i am having a problem while merging. Actually, for round 4 to 9, there is no unique id variable without which i am unable to merge it. Please suggest me what can i do
where are the data in help video
Thanks for your tutorial. Btw, can you share the data you use? Because I couldn’t practice what you do in the video. Thanks in advance
type: sysuse auto.dta All other data is from the FRED research.stlouisfed.org/
@@Kroft-Tutorials thanks a lot 👍
@@Kroft-Tutorials man.. you should have shown first which dataset we are working with so that we can replicate what we are learning in the lesson.. its a pain.. anyway.. thanks for these amazing STATA tutorials
Thanks for your videos. I have a problem with merge I won't to merge 1:1 sam key variable . At all I have 7 dataset I like to merge. I get error says variable _merge already defined stata. How can we solve that problem?
drop the merge variable....on variables scroll down, rightclick the ''merge'' variable and click on drop the selected variable
@@niachinkhokwe2553 okay thanks for your help
drop the _merge variable. A less safe way to prevent this is to type nogenerate after the keepusing part of the merge to prevent making the _merge dummy. However, this dummy can tell you how good the coverage of the merge is, do be careful with this option.
@@niachinkhokwe2553 you are right, thank you
Great explanation..I'm going through your entire Stata playlist to learn the basics of stata. Also my professor told me we can use the asdoc command for exporting our diagnostic tests, regression results and tables. Thank you
Glad it was helpful!
I tried with esttab using "D:\Research 2023-24\china new CRI\stata table.xls", cells("count(fmt(0)) mean(fmt(3)) var(fmt(3)) var(fmt(3)) min(fmt(3)) max(fmt(3)) max(fmt(3)") label replace But it showing parentheses unbalanced r(132);
Than somewhere, you have a missing ( or ).
you are Infront of commands. 😒
The tutorial is well organized which i consider as the important aspect while learning from TH-cam.
Thank you!
Please provide the link for downloading car data file
type: sysuse auto.dta
Where are the other data files?
sir, you video is on the variable portion, i am not able to see what you are doing in varible portion
Dear Professor, I followed every step, but got this in the end: gen hh_debt_ratio = debt_gdp_hh/100 type mismatch r(109); What could be the reason for that?
Probably the debt to gdp ratio is a string, a non-number variable. If the variable contains numbers, consider using: "destring debt_gdp_hh, replace force"
@@Kroft-Tutorials Aaaaa. Thank you so much!
just wonderful !
Thank you! Cheers!
Very helpful. Thank you!
So glad!
Hi Sir, I am running Hausman panel ARDL on Stata. I have successfully run the pooled mean group (PMG) regression. I want to run the Mean Group (MG) regression so I can decide which is best to use using the Hausman result. However, I get an error as the maximum number of iterations exceeded when running MG after running PMG. Please could help me to overcome this problem? Thank you
Thank you for your tutorial, very helpful! <3
Glad it was helpful!
Thank you for this tutorial. It is really helpful!
You're very welcome!
you are in front of commands how to learn then 😭😭😭😭😭😭
nice video good and systematic with simple
Glad you liked it
Thank you. But is I have a number of countries in a variable and I want to shorten the country names how would I go about doing this?
Dear Tommy, I would suppose a substring command from the egen package would help. Type substr(varname,1,x) to get the first x letters. Warm regards, Bram
Thanks Bram!
:)
this is very useful! THANK YOU!
Glad it was helpful!
very educative and simple
Thanks :)
Thanks
Glad it was of help :)
hey, wanna be the first to comment your video was very helpful. can you export cross-sectional data analysis table, I've tried to no avail. Thank you
Dear Frank, Could you please elaborate? Outreg2 should be able to do so if you use CS data, not panel I think. Warm regards, Bram
Hi Bram, thank you very much for your demonstration. I am also a PhD student. Recently I am working on a project and I have one quick question, is Excel plug-in only applicable to single value items? For example, I would like to download firm's supply chain information (including suppliers, customers and competitors) and each firm may have hundreds or thousands related firms under supply chain. In this case, should I not use Excel plug-ins? I really appreciate your suggestions.
Best of luck!
I hope our email contact helped :)
thank you for the tutorial !
Glad it was helpful!