![Investment Analysis](/img/default-banner.jpg)
- Видео 63
- Просмотров 59 345
Investment Analysis
Норвегия
Добавлен 15 дек 2020
How to find the 2nd or Nth instance with INDEX/MATCH in Excel
How to find the 2nd or Nth instance with INDEX/MATCH in Excel
Просмотров: 440
Видео
How to calculate Cost Plus Incentive Fee (CPIF) contracts in Excel with VBA
Просмотров 1056 месяцев назад
How to calculate Cost Plus Incentive Fee (CPIF) contracts in Excel with VBA
How to Draw the Efficient Frontier & Capital Market Line (CML) in Excel
Просмотров 2,2 тыс.10 месяцев назад
Opportunity set, feasible set, minimum variance portfolio (MVP), efficient frontier, Sharpe Ratio, tangent portfolio, Capital Market Line (SML).
Common master’s thesis mistakes: Planning failure
Просмотров 110Год назад
Common master’s thesis mistakes: Planning failure
Project Cost Estimation
Просмотров 277Год назад
Lecture 0 in my project cost estimation course. Methods for estimating investment cost (CAPEX) in projects.
Master's Thesis Mistakes: Project Life-Cycle Model
Просмотров 143Год назад
Master's Thesis Mistakes: Project Life-Cycle Model
How to draw a normal distribution in LaTeX with Tikz
Просмотров 1,7 тыс.Год назад
How to draw a normal distribution in LaTeX with Tikz
Effect of time lag and too intensive control correction on the effectiveness of feedback
Просмотров 862 года назад
Clips borrowed from these two videos: - ruclips.net/video/68zZZn8wy4E/видео.html - ruclips.net/video/0vUZG2z8TAs/видео.html
How to make network diagrams in Excel
Просмотров 4 тыс.2 года назад
How to make network diagrams in Excel
Programming Excel to play Colonel Blotto
Просмотров 3672 года назад
Programming Excel to play Colonel Blotto
How to properly handle figures in Word
Просмотров 2762 года назад
How to properly handle figures in Word
How to make summary statistics table in Stata
Просмотров 6 тыс.2 года назад
How to make summary statistics table in Stata
How to write equations in Microsoft Word
Просмотров 2582 года назад
How to write equations in Microsoft Word
How to do regression in Stata and output it to Excel
Просмотров 4772 года назад
How to do regression in Stata and output it to Excel
How to show formulas of neighbouring cells in Excel using VBA
Просмотров 962 года назад
How to show formulas of neighbouring cells in Excel using VBA
How to do regression analysis in Excel
Просмотров 3392 года назад
How to do regression analysis in Excel
How to make publication worthy statistical distributions in Stata
Просмотров 3092 года назад
How to make publication worthy statistical distributions in Stata
An IQ test explained by an almost smart person
Просмотров 3042 года назад
An IQ test explained by an almost smart person
What is project budgeting and how is it different from cost estimation?
Просмотров 7002 года назад
What is project budgeting and how is it different from cost estimation?
How to do Hello World in Excel and VBA
Просмотров 2882 года назад
How to do Hello World in Excel and VBA
Terrible advices on how to finish a PhD on time
Просмотров 2472 года назад
Terrible advices on how to finish a PhD on time
I keep getting Compile error: Wrong number of arguments or invalid property assignments?? Sub MissingDate() Range("B3").Select Status = True Do While Status = True If ActiveCell.Value = ActiveCell.Offset(-1, 0).Value + 1 Then ActiveCell.Offset(1, 0).Select Else Rows(ActiveCell.Row).Select Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove ActiveCell.Value = ActiveCell.Offset(-1, 0).Value + 1 End If If IsEmpty(ActiveCell, Value) Then Status = False End If Loop End Sub 'PLEASE HELP
you lost me when you didnt reinclude that 230 seconds that you cut out
how can i addapt this code to allow for a predetermined bin range thats layed out in the spreadsheet insteado of create its own?
Goood video but you have not explained how the rown macro is used to write row names. You used --> local rown = "`rown' + `var''" without defining what value rown holds the first time it is encoutered in the code.
For the first time it is empty and then subsequently will add each `var' as it iterates through meaning in the end it is a list of all the variables. It may have been easier to use the original local `myvar' instead of doing this.
Great work, Can you help me in building 4 or more stocks portfolio in excel, especially for capital market line? thanks
Was wondering how you might do it for columns? I tried changing Rows to Columns but didnt work
Great video! May you share the excel file for convenience? Thanx
Amazing Video I was able each point and practiced on my own worksheet works fine.
Thank you for a very clear presentation.
👏👏👏
Why you are talking at the back of microphone?
Sé que probablemente no hables español, pero gracias de cualquier manera, me sirvió de mucho.
I tried but have an issue with the calculation of the LST can you send me your exsample so i can have a look what i'm doing wrong? Thanks in advance!
Great video! simple and easy to understand!...Thank you so much! Really helpful.👍
Thank you so much for this video
Hi, thank you for the helpful video. How would you add a column for the differences in variables between group 1 and 2? And show whether these differences are significant?
Gran trabajo amigo, muy útil sigue así. Saludos desde Colombia
Interesting. The font you use is quite small for an iPad view … bigger please! :)
Hi, I came here to figure out how not to make the table containing figures move around like crazy when working on a manuscript - any thoughts on that?
Hi Sindre,does ECTS include exam preparations? Thanks for good educational videos!
Hello! Please create a Video or please teach how can I auto fill the Days (Monday, Tuesday, Wed......Sunday) without using the Mouse to drag on Excel. How to do the same by using only the Keyboard
Thank you, it's just what I needed.
Generate three numbers from 0 to 100 (or 1000, or from an interval [0;1] with some precision) and renormalize their sum to a 100.
Thank you!
Quality caps at 360p. Cannot read what you type.
Great video! Thank you. Do you know how we can generate triangular distribution with a correlation matrix?
1 week and 3 days into my new data analyst job and this literally just solved an issue that the person I replaced couldn't figure out prior to departing. you're are lifesaver!
Hi, I have a doubt regarding CPM/PERT network diagrams ( precedance diagram) and I was wondering if you could help me?
Unfathomably based
I think for 35 it is C as the grey kinda is a mirror axis. Could be wrong, though For 38 each row has either warm colours, cold colours or grey scale. Which means it can't be E, F or G
That test gotta be a bit funky. My IQ is like always estimated to be between 120 and 125 and this one claims it to be 133 Like I'm not a genious (took the test before I watched the video and only used 20 of the 40 minutes)
I picked this particular test for two reasons. The colour scheme is pretty rad (the Norwegian test is just black and white) and I want to make myself look good - so an easy test it is then. As for why the test is seemingly easier, an IQ test has to be calibrated on a sample of individuals, so maybe my Danish brothers are a bit dunderheaded? *Smirking with self-satisfaction* Or, given how old this test is, maybe there is a bit of a Flynn effect going on. All jokes aside, measuring IQ is subject to quite a bit of random noise.
Super helpful. Thank you!
I was trying to debug ,getting run time error 13 (Type mismatch)
😠 p̴r̴o̴m̴o̴s̴m̴
Thank you so much for this video, it helps a lot! I have a question, I am trying to export data from multiple linear regressions - using your code, each work but only in separate do files. If I try to create 1 do file, stata is giving me a conformability error (503). I believe it thinks that I am trying to combine the two made matrices which I am not. Is there a way around this?
Great video! Thanks. One little correction, at time 5:39 the formula for f(x) is incorrect in the last line of the video where there is a "1" should be "0" as is on time 3:12.
thank you so much it was really helpful :)
That is the working capital calculation, is not the NWC.
Awesome😊👍👍👍👍
Hi, why cannot number of slides be on the y-axis? I have trouble understanding what should be on which axis. Also, why is VAR.S not sqaured?
beautiful work! .. nice skills!
Useful! Thx!
thank you
This is great stuff. Thank you so much for taking the time to explain.
Thanks so much for this help. I made the mistake of subtracting the already negative value. You saved me a lot of time and frustration.
Hey, can u share this file please? :)
Very cool! It worked for me! ty for it!
Interesting video, I thought I might be able to use NPV for my project which is as follows: My project is slightly different and would appreciate some feedback (project summary) this is to calculate future value of a current value, the variable is the number of days, therefor this has to be a variable cell (current fixed value* Number of days) * 10)) * fixed % = current value. So, the objective is to take todays and extrapolate for any number of future days. Nb: (current number of days increases * 1 per day). so calculation is current value * days to ^n power can you help? Example: Current value = 2,000.48 )starting point) multiplied by number of days (266) this is the variable multiply product *10 ) product is increased @ 1.5% daily. The project is to calculate the value of in n days. (a = variable days 8 b=Units current value )= c (product *10) * d percentage) = projected combined value (number of units) NB: the future number is a projection based upon the starting point snapshot.
very great man, it inspires me for my working tasks. Thanks!!
Thanks for this video. It is very informative and helpful. Would you please share the excel file ?