Wonderful video! After getting the Google data instructions I skipped the MS Outlook bit and got the refresh settings instructions. All worked perfectly. Thank you!

This is really a fantastic video which explains the steps in importing the stock data into the stand alone MS Office version (non subscription version). Thanks a lot for the video. Really useful and your efforts are well appreciated.

Great tutorial!

Hello, I am doing a report on Benford's Law that has to be 12 pages for highschool. Where did you get the trasaction amounts (the 6000 numbers) from? Are those able to be sent to me or is there a place where I can find them? I want to do a similar test to prove that Benford's law works to detect fraud. Thank you!

Can I use this method to input real time stock data in my excel app on my iPad Pro?

I don't think that using "=1" is effective way because every time, you entered "=1" you have to change it to "=2" and "=3" etc. which is much time-consuming. I think that using a reference of the cell is more efficient. For example, when you are calculating the COUNT for the cell with a value of 1, you just simply reference a cell where "1" is entered. Then, for the cell below, simply copy the above formula, changing automatically the above referenced cell the next reference. I tested it myself. Instead of "=1" I entered "E3". Excel formula accordingly search the reference E3 to find the value, for example, and the next formula down the row of 4, Excel searches a value in the cell E4. This way, you wouldn't need to spend time to replace 1 with 2, and with 3, and with 4, and so on.

very helpful video!

How do I do this if the row header is the item description and below the item description is how many stores ordered that specific item

Make the countif criteria dynamic, have it refer to that cell.

Awesome explanation! 👍 I just want to ask how did you get that +/-(1/2n) in the formula of confidence interval? Does it really matter in case of a large sample size?

Awesome! Can you share this sheets?

how do you select cards rather than use random

All I'm getting are script errors. Doesn't work on 2016.

Great analysis, I personally questioning return of BRK shares under performing compare to spy , he benefiting his fame ,

I'm using Office Pro Plus 2016 and when I get to 3:57, and go to the "Data" ribbon, there's no "Get Data from the Web" button [and I couldn't find it in the menu to add it to the ribbon]. Is there a workaround or do I need to update Excel?

What a detailed explanation. Loved it!!

Your comment that information is much more widely proliferated now versus the 60's to 80's, is the key. Bill Dickerson was a great investor that I personally knew. He was a millionaire by the time he was 23. He had to buy through a real live broker, he had to pay fees and had to wait until the next day to see how he had done. His sole guiding document was the Wall Street Journal. He made charts and graphs (before computers) and developed his theory that almost any stock will go up if you just wait for it. Fast forward 60 years, using nothing more than statistics and some heavy duty computers, James Simons made a 39.1% average net annual return between 1988 - 2018. He looked at the market as a whole using mathematical models to analyze and execute trades. Buffett would have done much, much better if he used Simons' approach but his ego won't let him.

i done with the auto share price updated in google sheet, but once i public to web and try to get data from web (excel 2021) load the data, all the inform are appear except for my share price (it show "loading..."), wondering where is go wrong, any tips?

Thanks this is great

"I don't want to upload it to the cloud due to privacy concerns" ## streaming to 12 k viewers , :D

Awesome! Very useful, finally understood the concepts

That's so good man, thanks a lot

top lad nice one g

Very Good ! Thank's !

Thank you - This is the best solution I have found to get real-time quotes into Excel 2021 without paying for Office 365 - it works perfectly. I import them as a separate sheet in excel and just refer to them where I need them. also makes it easier to add new symbols. I would have never found the update frequency time setting without your video also!

Excellent video illustrating a very powerful point. Would the sum have been closer if 2018 year end constituent weightings been applied to the 2019 returns. Applying year end 2019 weightings to 2019 returns "double-weights" 2019 performance because the performance is built into the year end 2019 constituent weightings (stocks that did well end the year with a greater weighting, and those that didn't do well end with a smaller weighting than they did at the beginning of the year). Just a thought.

Thank you!!!

So the Office version does not work without 365 subscription nowadays? Was anyone able to do it in Office free version?

Thank you for the great video. It was very clear and works like a charm. I'm using Excel 2021. Question: Stock values from Google Sheets comes in as a table. A table within any workbook prevents Custom Views from working (Its greyed out). Is there a way to import stock data, but not as a table, so that the custom views can be used?

Good Day I wanna Know a formula, how to pick up the most common number on any list or raw

Can Benford's law be assistive in investigating fraud cases where fraudsters misused the Covid relief funds? Is there a pattern observed in cases already investigated?

where to get the monte carlo package

I've notice 19 rarely ever gets picked for the mega ball. It's only happened twice in the past year which is unusual.

you the man!! just the video i needed... thanks

Thank you!!!!! Great video!!!!!

thank you for real. i wonder if there are some zero price data or some messing price data, must we delete these days or make them somehow? i hear there is a approach and we can make five days data by running a geometric codes in mathlab but i don't know how...? i wonder if you know more details about what i'm talking about...

thank you for this very clear video . i had a problem to get the info into an excel 2013 sheet. i got all kind of errors and gave up. BUT went to another computer where i have excel 2019 and there it worked like a charm. i now have also everything in 1 sheet. after i did the import i did an edit of the query. i selected first row as headers (because i have a header row in googlesheets) and also selected specific colums. so i get the following columns from my google sheet: ticker name currency price 52w-low 52w-high. so the first 6 columns come from google sheet and i can freely use column 7 and further. these are now not effected by the data refresh.

Here is the skew for common stocK between 1926 and 2016.there was 36 trillion of wealth creation. 25000 companies or 96% of all stocks produced little wealth creation. 1026 stocks or 4% of stocks produced 35 trillion and of those companies 90 or less than 1/3 of 1% was responsible for almost 20 trillion.

Hello sir, I'm confused about the norm.dist and standardize functions, as far as I know the norm.dist function is also to find zscore, but doesn't standardization also use the same formula to find zscore? Then why are the results different? CMIIW

How would you apply the shiller pe to other markets?

Thumb up from HONG KONG trader in ibank

Can you normalize promotion type that has qualitative info ?

Great trick! You just gained a sub and a like.

Great!

hy if i have a likert scale questionaire response like high moderate low and no how can i normalized in values to calculate minimum and maximum plz reply

A big merci (:

Lucid explanation.

thanks for the information ,in a situation where you have a negative skew value for currency ,how do you describe that Mean -0.04% Standard Error 0.06% Median -0.03% Mode #N/A Standard Deviation 1.30% Sample Variance 0.02% Kurtosis 0.70 Skewness -0.25 Range 8.41% Minimum -4.46% Maximum 3.95% Sum -21.17% Count 502

Thank you!! your explanation is so easy to follow :)

I was disappointed when Office 2021 came out and the non-365 version did not include the feature for downloading quotes directly. But your method works fine and I thank you for sharing this info. You now have a new subscriber.