Bram van der Kroft
Bram van der Kroft
  • 25
  • 86 230
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.
มุมมอง: 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!

ความคิดเห็น

  • @rachelharson173
    @rachelharson173 หลายเดือนก่อน

    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!

  • @gideongondwe8547
    @gideongondwe8547 หลายเดือนก่อน

    Thank you very much for the tutorial

  •  2 หลายเดือนก่อน

    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!

  • @nusratnoshin8008
    @nusratnoshin8008 2 หลายเดือนก่อน

    Could you please tell how have you added row_number here?

  • @jyotidhungana4070
    @jyotidhungana4070 2 หลายเดือนก่อน

    Excellent presentation and sessions. Thank you so much and grateful for your contribution, From Nepal

  • @ToniZ2010
    @ToniZ2010 3 หลายเดือนก่อน

    Your screen is very unclear.

  • @FriendGoluYT09
    @FriendGoluYT09 3 หลายเดือนก่อน

    People creating such efficient important content have little followers. Shame on this generation.

    • @Kroft-Tutorials
      @Kroft-Tutorials 3 หลายเดือนก่อน

      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.

    • @FriendGoluYT09
      @FriendGoluYT09 3 หลายเดือนก่อน

      @@Kroft-Tutorials thanks sir kindly continue this series to advanced level.

  • @DiningLIU
    @DiningLIU 4 หลายเดือนก่อน

    received this error: command tab2x1 is unrecognized

    • @Shalom4600
      @Shalom4600 4 หลายเดือนก่อน

      Having same problem....

  • @Mastercane98
    @Mastercane98 4 หลายเดือนก่อน

    Very well done, thank you very much for your tutorial.

    • @Kroft-Tutorials
      @Kroft-Tutorials 3 หลายเดือนก่อน

      Glad it was helpful!

  • @everyonemustlearnzm
    @everyonemustlearnzm 5 หลายเดือนก่อน

    Man, you deserve more subscribers !!!

  • @rodrigoalejandrosalinas7478
    @rodrigoalejandrosalinas7478 5 หลายเดือนก่อน

    How can i get median p25 and p75 in this tabulation? Thanks for your video

    • @Kroft-Tutorials
      @Kroft-Tutorials 5 หลายเดือนก่อน

      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)

  • @abiramivenkateswaran5728
    @abiramivenkateswaran5728 5 หลายเดือนก่อน

    The data used for working with strings is from?

  • @demascot5233
    @demascot5233 5 หลายเดือนก่อน

    bro you are just the best so far....thank you

  • @jagatdave
    @jagatdave 6 หลายเดือนก่อน

    Can you please share your do file editor? That would be easy to copy paste your command on student's sample data

  • @anchal.ak22
    @anchal.ak22 6 หลายเดือนก่อน

    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

  • @fadilajoudate7091
    @fadilajoudate7091 6 หลายเดือนก่อน

    where are the data in help video

  • @NicodemusSigitSutanto
    @NicodemusSigitSutanto 7 หลายเดือนก่อน

    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

    • @Kroft-Tutorials
      @Kroft-Tutorials 6 หลายเดือนก่อน

      type: sysuse auto.dta All other data is from the FRED research.stlouisfed.org/

    • @NicodemusSigitSutanto
      @NicodemusSigitSutanto 6 หลายเดือนก่อน

      @@Kroft-Tutorials thanks a lot 👍

    • @Kamaljeet-rx3jf
      @Kamaljeet-rx3jf 5 หลายเดือนก่อน

      @@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

  • @alihussien7935
    @alihussien7935 7 หลายเดือนก่อน

    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?

    • @niachinkhokwe2553
      @niachinkhokwe2553 6 หลายเดือนก่อน

      drop the merge variable....on variables scroll down, rightclick the ''merge'' variable and click on drop the selected variable

    • @alihussien7935
      @alihussien7935 6 หลายเดือนก่อน

      @@niachinkhokwe2553 okay thanks for your help

    • @Kroft-Tutorials
      @Kroft-Tutorials 6 หลายเดือนก่อน

      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.

    • @onyekaenwesi7216
      @onyekaenwesi7216 5 หลายเดือนก่อน

      ​@@niachinkhokwe2553 you are right, thank you

  • @ayeshaasif5532
    @ayeshaasif5532 7 หลายเดือนก่อน

    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

    • @Kroft-Tutorials
      @Kroft-Tutorials 6 หลายเดือนก่อน

      Glad it was helpful!

  • @KhadimHussain-x3w
    @KhadimHussain-x3w 7 หลายเดือนก่อน

    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);

    • @Kroft-Tutorials
      @Kroft-Tutorials 6 หลายเดือนก่อน

      Than somewhere, you have a missing ( or ).

  • @RishavRaj-mv3cs
    @RishavRaj-mv3cs 7 หลายเดือนก่อน

    you are Infront of commands. 😒

  • @alaminhossain9803
    @alaminhossain9803 7 หลายเดือนก่อน

    The tutorial is well organized which i consider as the important aspect while learning from TH-cam.

  • @surenderpandey7680
    @surenderpandey7680 8 หลายเดือนก่อน

    Please provide the link for downloading car data file

    • @Kroft-Tutorials
      @Kroft-Tutorials 6 หลายเดือนก่อน

      type: sysuse auto.dta

  • @SunnYangLiu
    @SunnYangLiu 8 หลายเดือนก่อน

    Where are the other data files?

  • @aijazdar7824
    @aijazdar7824 8 หลายเดือนก่อน

    sir, you video is on the variable portion, i am not able to see what you are doing in varible portion

  • @TemirlanIsmailov-p7d
    @TemirlanIsmailov-p7d 8 หลายเดือนก่อน

    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?

    • @Kroft-Tutorials
      @Kroft-Tutorials 8 หลายเดือนก่อน

      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"

    • @TemirlanIsmailov-p7d
      @TemirlanIsmailov-p7d 8 หลายเดือนก่อน

      @@Kroft-Tutorials Aaaaa. Thank you so much!

  • @khadim1875
    @khadim1875 8 หลายเดือนก่อน

    just wonderful !

  • @NguyenHoangSon2598
    @NguyenHoangSon2598 8 หลายเดือนก่อน

    Very helpful. Thank you!

  • @patiencepokoo6151
    @patiencepokoo6151 8 หลายเดือนก่อน

    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

  • @dvdsts4155
    @dvdsts4155 11 หลายเดือนก่อน

    Thank you for your tutorial, very helpful! <3

    • @Kroft-Tutorials
      @Kroft-Tutorials 10 หลายเดือนก่อน

      Glad it was helpful!

  • @oluwakemiadeyemi267
    @oluwakemiadeyemi267 11 หลายเดือนก่อน

    Thank you for this tutorial. It is really helpful!

    • @Kroft-Tutorials
      @Kroft-Tutorials 10 หลายเดือนก่อน

      You're very welcome!

  • @abidnoor4939
    @abidnoor4939 ปีที่แล้ว

    you are in front of commands how to learn then 😭😭😭😭😭😭

  • @GovindaKumar-cr3xz
    @GovindaKumar-cr3xz ปีที่แล้ว

    nice video good and systematic with simple

  • @tommy.h.descartes
    @tommy.h.descartes ปีที่แล้ว

    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?

    • @Kroft-Tutorials
      @Kroft-Tutorials ปีที่แล้ว

      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

  • @hannahshussain6485
    @hannahshussain6485 ปีที่แล้ว

    Thanks Bram!

  • @yangyichen3922
    @yangyichen3922 ปีที่แล้ว

    this is very useful! THANK YOU!

  • @PrinceYankson-i2v
    @PrinceYankson-i2v ปีที่แล้ว

    very educative and simple

  • @khedirderres3726
    @khedirderres3726 ปีที่แล้ว

    Thanks

  • @frankosei-kusi9404
    @frankosei-kusi9404 ปีที่แล้ว

    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

    • @Kroft-Tutorials
      @Kroft-Tutorials ปีที่แล้ว

      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

  • @BingzeXu
    @BingzeXu ปีที่แล้ว

    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.

  • @mitchellhodgson8224
    @mitchellhodgson8224 ปีที่แล้ว

    thank you for the tutorial !