Excel Busn Math 33: Stock Values Web Query & Rate Of Change

Posted by admin on March 5th, 2010 and filed under stock quotes | 8 Comments »

See how to add current stock prices to your Stock Analysis Table in Excel using a web query. See how to calculate the Rate of Change or Percent of Change in stock value.
Excel math formulas. Rate, Rate Of Change, Percentage Of Change, Increase, Decrease, Percentage Math Problems.

Duration : 0:7:54


[youtube 0rSNeMpSvbY]

8 Responses

  1. ExcelIsFun Says:

    Search for and …
    Search for and watch this video title:

    Search & Find Excel Videos, Playlists, Download Workbooks – excelisfun

  2. lorimchawk Says:

    i have used several …
    i have used several of your videos and in the beginning of each one, it states we can download the excel file, but I am not sure how to find your channel and locate those excel spreadsheets. Can you walk me through that? You have taught me a ton in the past few days.

  3. ExcelIsFun Says:

    You are welcome!
    You are welcome!

  4. killerdog5500 Says:

    Freakin awesome!! …
    Freakin awesome!! I’m taking a computer class online. You taught me in in 3 minutes what I’ve been trying to undwerstand for hours! Thanks alot.

  5. ExcelIsFun Says:

    Dear unamofa,


    Dear unamofa,

    You are welcome!

    –excelisfun

  6. unamofa Says:

    thanks, again I did …
    thanks, again I did it…I Love excel¡¡ and it is all thanks to you..

  7. ExcelIsFun Says:

    Dear unamofa,

    I …
    Dear unamofa,

    I am not sure what setup you have, but a method like what is seen in this video:

    YTLE#89: Relative & Absolute Macro together

    might work.

    –excelisfun

  8. unamofa Says:

    Hi thanks a lot for …
    Hi thanks a lot for all your videos, I am learning a lot.
    I am trying to create a web query where I activate the auto-refresh everyday and I want the worksheet to auto-save the values each day in another table with all the values.

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.