Видео

For those of us that don't have the version that supports those functions. This VBA code does get stock price. Can be modified to get other data. The majority of the code pulls in the web site the key is the line "price = html.getElementsByClassName("livePrice yf-mgkamr")(0).innerText". As yahoo performs updates this "class" may change. So you'll need to know how to update that using the Inspect function and highlighting the data and copying the class name on the "price =" line. Hope this helps. Function Get_Current_Price(a As String) As Currency Dim request As Object Dim response As String Dim html As New HTMLDocument Dim website As String Dim price As Variant ' Website to go to where "a" is the Ticker Symbol website = "finance.yahoo.com/quote/" & a & "?p=" & a & "&.tsrc=fin-srch" ' Create the object that will make the webpage request. Set request = CreateObject("MSXML2.XMLHTTP") ' Where to go and how to go there - probably don't need to change this. request.Open "GET", website, False ' Get fresh data. request.SetRequestHeader "If-Modified-Since", "Sat, 1 Jan 2000 00:00:00 GMT" ' Send the request for the webpage. request.Send ' Get the webpage response data into a variable. response = StrConv(request.ResponseBody, vbUnicode) ' Put the webpage into an html object to make data references easier. html.body.innerHTML = response ' Get the price from the specified element on the page. This is the piece that may change over time if Yahoo updates its HTML code. Go to site, right mouse button, choose inspect and then run mouse over html. Drill down on right arrows until only price is highlighted, that will show the the HTML class name (currently it is "livePrice yf-mgkamr"). For now code should work as is as of 8/5/2024. price = html.getElementsByClassName("livePrice yf-mgkamr")(0).innerText Get_Current_Price = price ' Output the price into a message box. Commented out get ride of (') if you want to use it for debuging. 'MsgBox price End Function

Nice

Thank you so much

So simple, glad I found your video!

Cool

Could you please show us how to formulate a cell to show time - many times I have time data shown like 45678 - and it is so annoying to change from the top bar every time do you know how we can have a keyboard shortcut to fix it

Man you just saved me a lot of stress. I've signed up for a few mapping services the past few days to do just this -- this will make things much easier with a project I'm working on.

Pls help me can you share me the steps with keys

Best video on multilevel grouping in excel

Doesn’t seem to work anymore. I get taken to “/homes. Not the address

I tried, it prompts back 'VALUE' and not any number

Bingo! Thank you!!

incredible. Thank you.

Thank you so much, this video was so useful, keep up the good work and I have subscribed of course

Wow this is cool!!! I just took time out of my day to follow this. Now me and my coworker can play some Yahtzee 😂

Keep in up Rich!

very helpful

Obrigado

❤👍🇮🇳

Thank you SIR!

That’s pretty cool!

😡 Promo_SM

I am not seeing ifs in my excel 2016

thanks a lot :)

Wwwhhhat I did not think it would be that easy. Always something new to learn!

Many thanks!!

I've got Office 365, which has the home/student version of Excel (2016) and doesn't have the map feature (amongst other features). is there an add-in I can purchase that will add these map features?

Nice.I found it useful.I am subscribing it.

how to get time difference in xl from today () and any other time in any other cell ? The time must be in year format.

I can't tell you in words, how much you helped me. Thanks you very much for this video. I really pray God to bless you

VERY HELPFUL THANK YOU!

How do I create different tasks (lets say in a drop down) but some have 14 day target date and some have 21? ie, if its a postal complaint i have 21 days to respond, if its email I have 14

THANK YOU!!

THANK YOU

I’m first one to like! Everyone let’s give this man some subs! Great tips on here!

That's a nasty cough man! Hope you didn't have Covid. Next time mute that out or record without the nasty coughing throughout. Makes for a much more professional presentation

Hi Rich, thanks for the explanation. I have a question. How can we add the S&P500 and the Dow Jones indexes?. Thanks

What version of excel? Not seeing map to insert. Is this an add-in?

thank 😊😊

This worked in one workbook I was working in, but now in my new workbook it is copying the formula into every row instead of keeping a blank cell in every other row. Any ideas??

please how can i use this with waze maps??

hi, great video just how would i make it work with waze live maps can you please let me know

THANK YOU

Please share data file for practice

Thanks a lot 😊

Thanks so much

I used the same formula but if the value in first column is blank for next months, it picks random number of days because of formula

Hi Sir, thank you for sharing this! also, I would like to know if there is any simple way like this to calculate remaining days, from today to specific date. kinda like the count down, it's for something like remaining days for subscription or promo. thank you ^_^

Super helpful, thanks!

Thank you very much🙏🙏