Loading ...
Sorry, an error occurred while loading the content.

124Re: RCHGetYahooQuotes()

Expand Messages
  • Randy Harmelink
    Jul 28, 2006
      Here's a little template for you.  Typically, when I want some Yahoo quotes data, I'll start out like this:

      1. Put ticker symbols in cells A2, A3, A4. (e.g. "IBM", "JNJ", and "MOT").
      2. Put Yahoo codes in cells B1, C1, D1 (e.g. "o", "h", and "l1").
      3. Highlight a range -- let's say B2 to M100.
      4. Type (into B2):  "=RCHGetYahooQuotes(A2:A100,B1:M1)"
      5. Hit Ctrl-Shift-Enter (to array-enter the formula)

      After a second or so, I will see:

        A B C D   E  
        1  o h l1 
      2 IBM 75.83 77.29 76.15 
      3 JNJ 62.15 62.57 62.56 
      4 MOT 22 22.24 22.11 
      5     
      6     

      However, since I set the symbol range to be A2:A100 and the Yahoo code range to be B1:M1, I can easily extend the table in either direction .  For example, I can type "v" in cell E1.  And I can type "MMM" in cell A5.  I would then see:

      A B C D E
        1 o h l1 v
      2 IBM 75.83 77.29 76.15 6422900
      3 JNJ 62.15 62.57 62.56 7658600
      4 MOT 22 22.24 22.11 21180900
      5 MMM 69.89 70.7 69.75 6141000
      6          

      And I can keep putting more symbols in, down to cell A100.   Or I can put in more Yahoo codes, out to cell M1.

      Hopefully that helps a bit?
    • Show all 61 messages in this topic