Excel VBA – Get Stock Quotes from Yahoo Finance API

https://www.facebook.com/FreeTutorials Code here: http://brettdotnet.posterous.com/excel-vba-get-stock-quotes-from-yahoo-api In this tutorial, I show you how…
Video Rating: 4 / 5

This entry was posted in AI SEO and tagged , , , , , . Bookmark the permalink.

15 Responses to Excel VBA – Get Stock Quotes from Yahoo Finance API

  1. Robert White says:

    Thanks. Excellent tutorial. I learned a lot (and I needed to do this).

  2. Nicolas Aguilar says:

    Hey I was wondering if there was a way to have the workbook autoupdate only cells that have changes as they change so it is an entirely dynamic workbook, and so I can use it as I create a self-adjusting mean-variance portfolio.

  3. John Dowdee says:

    Excellent video! Thanks! Keep up the good work.

  4. BuyNYCstocks says:

    I cant figure out who you “debug print symbol”. how to another screen appear?

  5. zyzzyva57 says:

    Outstanding! Simple and clear…I have been looking for this foundation for a long time…Really like how your download allows me right out of the “box” simply to add a stock symbol for the other data to get populated…Conditioning formatting, adding columns for calculations, and Freezing the top row jazzed it up even more for what I want…I hope you do another video adding even more stuff

  6. Michael S says:

    Hi Brett, how come I cannot get activeX controls? My insert button doesn’t give me that option.

  7. Joe JG says:

    wow, I have to admit, this was probably the best vba video I’ve seen on youtube. great job!

  8. Michael Ebbah says:

    Thanks Brett for a great video tutorial but I would confess, it’s still way technical for me. Instead of creating one, I chose to download your YahooStocks.xlsm. When I tried to open it, it says, “This workbook includes content that is not supported by Excel for Mac 2011″ then a line below it says “Active X.” Do you have a solution for this? Thanks ahead.

  9. aldilabandaro says:

    thank you Brett. i have a question. what if i want add more variable like previous close price or open price. how to modify it? 

  10. Fred Miller says:

    Hey Brett, Great tutorial. I am attempting to do something similar to this. Would you mind if I emailed you an example?

  11. Essa Khan says:

    hi Brett, Good after noon wonder ful tutorial video. i would like to ask you which course did u do to learn VBA. Thanks and Happy new year in advance bye.

  12. Stephen Wahrenburg says:

    will do. thanx!

  13. DontFretBrett says:

    That’s definitely doable. I’d need more details to give a code example. Message me or email blogbrett at gmail dot com

  14. Stephen Wahrenburg says:

    Do you know how i might be able to loop by the value within a cell rather than the cell location. so i want to loop that will go through cells with the value of 1, 2 and 3 aposed to cells with location .range(“B” & i) where i is from 1 – 3.

  15. funkydr23 says:

    I mean the font color and the background on vba editor mode

Leave a Reply