Bram van der Kroft
Bram van der Kroft
  • 25
  • 81 504
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.
Переглядів: 24 493

Відео

FactSet Tutorial for Financial Applications and Data Analysis
Переглядів 1,9 тис.Рік тому
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,5 тис.Рік тому
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,3 тис.Рік тому
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,8 тис.Рік тому
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,3 тис.Рік тому
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
Переглядів 7 тис.Рік тому
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
Переглядів 993Рік тому
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
Переглядів 549Рік тому
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,1 тис.Рік тому
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,2 тис.Рік тому
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)?
Переглядів 671Рік тому
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
Переглядів 5 тис.Рік тому
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,1 тис.Рік тому
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 тис.Рік тому
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?
Переглядів 726Рік тому
Stata Lecture 10: What to do with DO files?
Stata Lecture 9: Help with the Help Function
Переглядів 644Рік тому
Stata Lecture 9: Help with the Help Function
Stata Lecture 8: How to master and export the Tabulate command
Переглядів 2,1 тис.Рік тому
Stata Lecture 8: How to master and export the Tabulate command
Stata Lecture 7: Exporting Summary Statistics
Переглядів 4,7 тис.Рік тому
Stata Lecture 7: Exporting Summary Statistics
Stata Lecture 6: Generating Summary Statistics
Переглядів 2 тис.Рік тому
Stata Lecture 6: Generating Summary Statistics
Stata Lecture 5: Understanding String, Integer, and Date variable types!
Переглядів 2,2 тис.Рік тому
Stata Lecture 5: Understanding String, Integer, and Date variable types!
Stata Lecture 4: Renaming and Removing variables.
Переглядів 1,4 тис.Рік тому
Stata Lecture 4: Renaming and Removing variables.
Stata Lecture 3: How to generate variables?
Переглядів 2,3 тис.Рік тому
Stata Lecture 3: How to generate variables?
Stata Lecture 2: How to import Excel/CSV data?
Переглядів 3 тис.Рік тому
Stata Lecture 2: How to import Excel/CSV data?
Stata Lecture 1: How to effectively pre-clean data!
Переглядів 4,1 тис.Рік тому
Stata Lecture 1: How to effectively pre-clean data!

КОМЕНТАРІ

  • @rachelharson173
    @rachelharson173 13 днів тому

    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 28 днів тому

    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!

  • @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 2 місяці тому

    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 3 місяці тому

      Having same problem....

  • @Mastercane98
    @Mastercane98 4 місяці тому

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

  • @everyonemustlearnzm
    @everyonemustlearnzm 4 місяці тому

    Man, you deserve more subscribers !!!

  • @rodrigoalejandrosalinas7478
    @rodrigoalejandrosalinas7478 4 місяці тому

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

    • @Kroft-Tutorials
      @Kroft-Tutorials 4 місяці тому

      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 4 місяці тому

    The data used for working with strings is from?

  • @demascot5233
    @demascot5233 4 місяці тому

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

  • @jagatdave
    @jagatdave 5 місяців тому

    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 5 місяців тому

    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 6 місяців тому

    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 6 місяців тому

    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 4 місяці тому

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

  • @user-us1sf7gd3d
    @user-us1sf7gd3d 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 UA-cam.

  • @surenderpandey7680
    @surenderpandey7680 7 місяців тому

    Please provide the link for downloading car data file

  • @SunnYangLiu
    @SunnYangLiu 7 місяців тому

    Where are the other data files?

  • @aijazdar7824
    @aijazdar7824 7 місяців тому

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

  • @user-lk2gk6mc8x
    @user-lk2gk6mc8x 7 місяців тому

    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 7 місяців тому

      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"

    • @user-lk2gk6mc8x
      @user-lk2gk6mc8x 7 місяців тому

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

  • @khadim1875
    @khadim1875 7 місяців тому

    just wonderful !

  • @NguyenHoangSon2598
    @NguyenHoangSon2598 7 місяців тому

    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 10 місяців тому

    Thank you for your tutorial, very helpful! <3

  • @oluwakemiadeyemi267
    @oluwakemiadeyemi267 10 місяців тому

    Thank you for this tutorial. It is really helpful!

  • @abidnoor4939
    @abidnoor4939 11 місяців тому

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

  • @GovindaKumar-cr3xz
    @GovindaKumar-cr3xz 11 місяців тому

    nice video good and systematic with simple

  • @tommy.h.descartes
    @tommy.h.descartes 11 місяців тому

    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 11 місяців тому

      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!

  • @user-mg2nn9cu5o
    @user-mg2nn9cu5o Рік тому

    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

  • @user-of6vl8ox7j
    @user-of6vl8ox7j Рік тому

    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 !

  • @bahadursingh9204
    @bahadursingh9204 Рік тому

    As well as please share your twitter link also

    • @Kroft-Tutorials
      @Kroft-Tutorials Рік тому

      www.linkedin.com/in/bram-van-der-kroft-676629142/ I do not have twitter :)

  • @bahadursingh9204
    @bahadursingh9204 Рік тому

    Respected sir, when I try to download, demanding a business email.id which I do not have....so please tell me what I should be done , I am research scholar and want to use it for academic use

    • @Kroft-Tutorials
      @Kroft-Tutorials Рік тому

      Dear Sir/Madam, I cannot give access to the software unfortunately. I have it via my university. Warm regards, Bram