yahoo.excel.function.. - OoCities

					                                            Yahoo Spreadsheet Functions
                                                             CONTENTS

          Yahoo Search Function
              =ySearch(Query Term, optional Number of Results, optional showURLS)

          Foreign Exchange Rate Functions
               =yExchangeRate(FromCountryCode,ToCountryCode)

          Stock Quote Functions
              =yfq(ticker)
              =yfmc(ticker)
              =yfcy(ticker)
              =yfpe(ticker)
              =yfbid(ticker)
              =yfask(ticker)
              =yahooqutoe (ticker,parm)

          Finance News Function
              =yfinnews(ticker, optional number of results, optional details)

          Address Book
              =yPhone(first name, last name)

          Yahoo360 Number of Friends Function
              =y360numfriends(yahooID)

          Zip Code Lookup Function
               =yZip(address, city, state)

          Home Value Function
              =yHomeVal(address, city, state)

          Movies Rating and Description Function
              =yMovies(moviename, optional: ShowDescription, optional: ResultNumber)

          Weather Function
              =yWeather(zipcode, parameter)

          Backyard Functions
              =by(name,fieldnumber)




                                                           Tab:Sheet1 - page 1
D:\Docstoc\Working\pdf\a0dc3401-24a7-4a04-8d2b-f3845df71995.xls                        7/7/2011; 9:27 PM
                                                                    Yahoo Search Function

This function does a search on Yahoo and returns the results.

Using the first search term below, it would generate the following URL:
http://api.search.yahoo.com/WebSearchService/V1/webSearch?appid=InformITXML&query=Marco+Boerries+Birthday

                                                             The syntax of the function is:
                                          =ySearch(Query Term, optional Number of Results, optional showURLS)

The default number of results is 3, but it can be set from 1-10.
By default, the URLs are not returned, but you can put a 1 in the third term to show the URLs


   Input:
   Query                                                                      Output: Search Results
   Term

Marco             1.) Yodel Anecdotal - Yahoo! corporate blog, providing insights into the company, its people, products, and culture. - yodel.yahoo.com/
Boerries          2.) Live at the Yahoo press conference - Engadget - To celebrate its birthday, TV Squad is giving one lucky reader an HDTV! ... Marco
Birthday        Boerries, SVP Yahoo! ... Marco: We've already been dealing with this on ... - ces.engadget.com/2007/01/08/live-at-the-yahoo-press-
                conference/
                  3.) 2007 International CES: People - Marco Boerries, senior vice president of Yahoo!'s Connected Life, introduced Yahoo Go! ... Monroe's
                singing of happy birthday for the 40th anniversary of ... - www.cesweb.org/about_ces/photos/rd_photos_people.asp?option=people
                  4.) sfbay: Invitation - Marco Boerries "Successful German Visionary, ... Marco sold StarOffice to Sun Microsystems on August 5, 1999 -
                four days. after his 31st birthday. ... - www.swiss-list.com/mailings/sfbay/2004/0014.shtml
                  5.) LinuxPlanet - Reviews - The StartX Files: Word to the Wise: Writer 638C - Happy Birthday... Mr. OpenOffice... - The burning
                question among many ... Happy Birthday... Mr. OpenOffice... with a student, 16-year-old Marco Börries, who founded Star Division in
                1985. ... - linuxplanet.com/linuxplanet/reviews/3841/2/
                  6.) LinuxPlanet - Print - The StartX Files: Word to the Wise: Writer 638C - Brian Proffitt takes a look at just those differences this week,
                and ... Happy Birthday... Mr. ... student, 16-year-old Marco Börries, who founded Star Division ... -
                www.linuxplanet.com/linuxplanet/print/3841/
                  7.) Local News | News for Charlotte, North Carolina | WCNC.com | Business - Submit a Birthday. Community Events. News Tips. WCNC
                Investigators ... said Marco Boerries, senior vice president of the company's "Connected Life" division. ... -
                www.wcnc.com/sharedcontent/business/topstories2/010206ccjccwTechGadget.3b1ac0...
birthday
charles
degaulle




  D:\Docstoc\Working\pdf\a0dc3401-24a7-4a04-8d2b-f3845df71995.xls        Tab:Search - page 2                                              7/7/2011; 9:27 PM
                                                          Yahoo Shopping: Price Search Function
Using the first search term below, it would generate the following URL:
'http://api.shopping.yahoo.com/ShoppingService/v1/productSearch?appid=YahooDemo&query=digital camera
                                                                       The syntax of the function is:
                                                      =yshop(Item, optional number of results, optional showURLS)
The default number of results is 1, but it can be set from 1-10.




                          Input: Query Term                                                             Output: Search Results

digital camera                                                         1.) Casio Exilim Zoom EX-Z750 Digital Camera: 155.00 - 349.00
                                                                       2.) Sony Cyber-shot DSC-W7 Digital Camera: 382.99 - 499.00
                                                                       3.) Nikon Coolpix 5600 Digital Camera: 77.00 - 171.00
                                                                       4.) Sony Cyber-shot DSC-N1 Digital Camera: 170.00 - 384.10
                                                                       5.) Canon PowerShot S3 IS Digital Camera: 210.00 - 474.99
                                                                       6.) Canon PowerShot A520 Digital Camera: 219.95 - 236.99
                                                                       7.) Kodak EasyShare Z740 Digital Camera: 180.00 - 388.00

WRT330N                                                               Linksys Wireless-N Gigabit Gaming Router WRT330N: 154.99 - 199.99
WRVS4400N                                                             Linksys Wireless-N Gigabit Security Router with VPN WRVS4400N: 188.93 - 299.99

Garmin nuvi 350 Personal Travel Assistant                             Garmin nuvi 350 Personal Travel Assistant: 449.99


Tomtom One GPS Navigation System                                      Tom Tom TomTom One GPS Navigation System: 299.99
Garmin StreetPilot c330 Automotive GPS Navigation System              Garmin StreetPilot c330 Automotive GPS Navigation System: 275.00
Garmin Nuvi 660 Portable/Vehicle GPS Navigation                       Garmin Nuvi 660 Portable / Vehicle GPS Navigation: 689.00
Garmin nuvi 360 GPS Receiver                                          Garmin nüvi 360 GPS Receiver: 449.99 - 899.00
Garmin nuvi 350 Personal Travel Assistant                             Garmin nuvi 350 Personal Travel Assistant: 449.99




    D:\Docstoc\Working\pdf\a0dc3401-24a7-4a04-8d2b-f3845df71995.xls         Tab:Shopping - page 3                                                      7/7/2011; 9:27 PM
                                                  Foreign Exchange Rate Functions

This does a simple lookup of the current exchange rates from Yahoo Finance
                                                         The syntax of the function is:
                                           =yExchangeRate(FromCountryCode,ToCountryCode)

                                                Shortcuts are: =y4x() and yforex()




                                                                                                    TO
                                                   USD           GBP              CHF        EUR             JPY          KRW             CNY
                                                                                                                                         Chinese
                                                US Dollar UK Pound Swiss Franc               Euro        Japanese Yen   Korean Won
                                                                                                                                          Yuan

   FROM           USD        US Dollar              0.0000           0.5203         1.2219   0.7639          115.9200       952.7000        7.7545
                  GBP        UK Pound               1.9619           1.0000         2.3483   1.4682          222.7924     1,831.0415       14.9038
                  CHF        Swiss Franc            0.8203           0.4258         1.0000   0.6252           94.8725       779.7192        6.3465
                  EUR        Euro                   1.3090           0.6811         1.5995   1.0000          151.7450     1,247.1316       10.1510
                  JPY        Japanese Yen           0.0086           0.0045         0.0105   0.0066            1.0000         8.2186        0.0669
                  KRW        Korean Won             0.0010           0.0005         0.0013   0.0008            0.1217         1.0000        0.0081
                  CNY        Chinese Yuan           0.1290           0.0671         0.1576   0.0985           14.9487       122.8577        1.0000




   D:\Docstoc\Working\pdf\a0dc3401-24a7-4a04-8d2b-f3845df71995.xls     Tab:forex - page 4                                      7/7/2011; 9:27 PM
                                                                        Stock Quote Functions
These are a set of functions that grab stock quotes, market cap, dividend yeild, etc. from the
Yahoo Finance page.

                                                                                                                                            s
                                                                      Dividend
  Ticker               Quote                Market Cap                                  P/E                  Bid           Ask Price              Variant
                                                                       Yield
                                                                                                                                                =yahooqutoe
                    =yfq(ticker)            =yfmc(ticker)        =yfcy(ticker)      =yfpe(ticker)       =yfbid(ticker)    =yfask(ticker)
Examples:                                                                                                                                       (ticker,parm)

ACAS                          44.85                  6.869B                  7.65              6.83                44.7                49
BAM
OMG
PWE
WNR
YHOO


                 Note: These finance functions are simplified versions of similar ones created by Randy Harmelink in his
                 excellent Stock Market Function Add In
                                   http://finance.groups.yahoo.com/group/smf_addin/




    D:\Docstoc\Working\pdf\a0dc3401-24a7-4a04-8d2b-f3845df71995.xls                   Tab:quotes - page 5                                                   7/7/2011; 9:27 PM
                                         Finance News Function
This functions pulls the latest news for the specified ticker symbol.
                                            The syntax of the function is:
                        =yfinnews(ticker, optional number of results, optional details)

- ticker is the stock ticker symbol that you would otherwise use on Yahoo
- number of results can be up to 10
- details - this is a true/false

Example URL:
http://finance.yahoo.com/rss/headline?s=IBM

   Input                                                         Outputs




yhoo            1. eBay Embraces Mobility (at TheStreet.com)
                2. Limelight Readies For Spotlight (at Forbes.com)
                3. Microsoft video site gets a piracy cleanup (at MarketWatch)
                    The Soapbox video site has put Microsoft Corp. in an uncomfortable position with new and
                high-profile partner NBC Universal.
                4. Fool on Call: Adobe Recharged (at Motley Fool)
                5. Audible Magic on Copyright Patrol (AP)
                    Vance Ikezoye didn't set out to become one of the digital revolution's top copyright cops
                when he first began tinkering with the technology that launched Audible Magic Corp.

BAM
BNB.AX
BRKb
HERO




                                                           Tab:fin.news - page 6
 D:\Docstoc\Working\pdf\a0dc3401-24a7-4a04-8d2b-f3845df71995.xls                                                7/7/2011; 9:27 PM
                                                Finance Charts Functions
    This functions pulls the sparkline from YahooFinance for the specified ticker symbol.
                                                      The syntax of the function is:
                                     =yfinnews(ticker, optional number of results, optional details)

    - ticker is the stock ticker symbol that you would otherwise use on Yahoo
    - number of results can be up to 10
    - details - this is a true/false

    Example URL:




1                        http://chart.finance.yahoo.com/c/0b/y/yhoo
2                        http://ichart.finance.yahoo.com/z?s=YHOO&t=3m&q=&l=&z=&p=m50,m200&a=v
3                        http://ichart.finance.yahoo.com/z?s=YHOO
4                        http://ebetaichart.finance.yahoo.com/instrument/1.0/YHOO/chart;range=1y/image;size=160x
5                        http://ebetaichart.finance.yahoo.com/instrument/1.0/YHOO/chart;range=1y;compare=GE/im
6                        http://ebetaichart.finance.yahoo.com/instrument/1.0/YHOO/chart;range=6m;compare=GE/im
7                        http://ebetaichart.finance.yahoo.com/instrument/1.0/YHOO/chart;range=6m/image;size=260
8                        http://finance.yahoo.com/charts#chart1:symbol=acas;range=1y;indicator=volume;charttype=
    yspark     SparkLine http://ichart.finance.yahoo.com/h?s=YHOO

     Ticker                     Spark Lines


    ABY                              0

    MRK

    KMX

    YHOO

    CSCO
ons


 optional details)




&l=&z=&p=m50,m200&a=v

OO/chart;range=1y/image;size=160x95
OO/chart;range=1y;compare=GE/image;size=160x95
OO/chart;range=6m;compare=GE/image;size=135x90
OO/chart;range=6m/image;size=260x115
ge=1y;indicator=volume;charttype=line;crosshair=on;logscale=on;source=undefined
                                              Phone Number Lookup
This function returns the primary phone number of a person in
your address book.

                                                The syntax of the function is:
                                               =yPhone(first name, last name)

You have to already be logged in to Yahoo
Both first and last name are required
If the first name or last name is entered directly (rather than as a pointer to text in other cells)
then the text must be surrounded with double quotes "

The URL used comes from the mobile site:
http://us.wap.yahoo.com/p/addrbk/l?m=s&s=firstname+lastname

                        Inputs                                                             Outputs

        First Name                   Last Name                                 =yphone(firstname,lastname)

Albie                                                        p: albiev@yahoo-inc.com




                                                      Tab:phone#s
  D:\Docstoc\Working\pdf\a0dc3401-24a7-4a04-8d2b-f3845df71995.xls from contacts - page 9                     7/7/2011; 9:27 PM
     Yahoo360 Number of Friends Function
This is an example of a web function that shows the number of friends
                     someone has on Yahoo360.
                    The syntax of the function is
                    =y360numfriends(yahooID)

                                                   Zip Code Returned by
              YahooID
                                                          Yahoo
                vikbhan                                             195
                pjbrody
              sega94115
           jonathanhstrauss
                  brw2
                 lee_ott
                gchu.rm
             pattimcguire
            jasonchroman
            michaeltadlock
                   joff
              jakeloomis
             scotthroberts
               mboerries




                                                       Tab:#friends on 360 - page 10
D:\Docstoc\Working\pdf\a0dc3401-24a7-4a04-8d2b-f3845df71995.xls                        7/7/2011; 9:27 PM
                                         Zip Code Lookup Function
This function automates a zip code lookup, by pulling the zip code from the Yahoo Maps site, given an
address, city, and state.

                                               The syntax of the function is:
                                                =yZip(address, city, state)

                                                                                          Zip Code Returned by
               Address                              City                     State
                                                                                                 Yahoo
402 Castenada Ave                        San Francisco                CA                  94116-1909
124 Midway Road                          Ithaca                       NY
62 Stuyvesant Road                       Asheville                    NC
810 N Kings Road                         Los Angeles                  California
86 Cross Country Trail                   Stamford                     Ct
824 Highwood Dr                          Franklin Lakes               nj
6321 Palma del Mar Blvd                  St Petersburg                FL
100 Whitemarsh Road                      Ardmore                      PA
804 Gist Street                          Silver Springs               MD
10612 canterberry road                   fairfax station              va
Four Salem Street                        Swamscott                    MA




                                                          Tab:zipcode - page 11
D:\Docstoc\Working\pdf\a0dc3401-24a7-4a04-8d2b-f3845df71995.xls                                          7/7/2011; 9:27 PM
                                                  Home Value Function

This function that automates the lookup of the value of a home, by pulling the Zillow Estimate
from the Yahoo Real Estate page.
                                                  The syntax of the function is
                                               =yHomeVal(address, city, state)

                                                                                                 Home Value Returned
               Address                           City and State                        or Zip
                                                                                                      by Yahoo
5 Willow Tree Lane                       Irvine                      CA                                      573,743
2526 Lyric Ave                           Los Angeles                 CA
407 Castenada Ave                        San Francisco               CA
757 el cerrito ave                                                                94010-6949
87 Linden Avenue                                                                  94027-2161




                                                             Tab:HomeValue - page 12
    D:\Docstoc\Working\pdf\a0dc3401-24a7-4a04-8d2b-f3845df71995.xls                                       7/7/2011; 9:27 PM
                                                Movies Rating and Description Function

   This function does a lookup of the a Movie on Yahoo Movies, so that you can see the ratings (by default) or the full
   description of the movie.

                                                          The syntax of the function is:
                                     =yMovies(moviename, optional: ShowDescription, optional: ResultNumber)

   Entering =yMovies("Star Wars") will return the ratings for that movie.
   Entering =yMovies("Star Wars",1) will return the description for StarWars.

                     Movie                                                                       Result
A good year                                        Good Year, A (2006) | Critics | C | Community | C+
For your consideration
Babel
A guide to recognizing your saints                 Guide to Recognizing Your Saints, A (2006) | Critics | B | Community | B
Hollywoodland                                      Hollywoodland (2006) | Critics | B- | Community | B-
The gathering                                      Gathering, The (2003) | Critics | My Grade: | Community | B-
Little miss sunshine                               Little Miss Sunshine (2006) | Critics | B+ | Community | B+
Her minor thing                                    Her Minor Thing | Critics | My Grade: | Community | B-
Journey to the end of the night                    Journey to the End of the Night (2006) | Critics | My Grade: | Community | C+
Infamous                                           Infamous (2006) | Critics | B | Community | B-
Keane                                              Keane (2005) | Critics | B+ | Community | B-
Man of the year                                    Man of the Year (2006) | Critics | C | Community | B-
Invincible                                         Invincible (2006) | Critics | B- | Community | B+
Man about town                                     Man About Town (2006) | Critics | My Grade: | Community | C+
La mujer de mi hermano                             La Mujer de Mi Hermano (2006) | Critics | C- | Community | C+
Match point                                        Match Point (2005) | Critics | A- | Community | B
Marie Antoinette                                   Marie Antoinette (2006) | Critics | B | Community | B-
Minis first time                                   First Time (2006) | Critics | My Grade: | Community | C+
Memoirs of a geisha                                Memoirs of a Geisha (2005) | Critics | B- | Community | B
The new world                                      the Duck (1986) | Critics | My Grade: | Community | C
Scoop                                              Scoop (2004) | Critics | My Grade: | Community | D+
Relative strangers                                 Relative Strangers (2005) | Critics | My Grade: | Community | C+
School for scoundrels                              School for Scoundrels (2006) | Critics | C- | Community | B-
Snakes on a plane                                  Snakes on a Plane (2006) | Critics | B- | Community | B-
Soap                                               Soap (2006) | Critics | My Grade: | Community | D+
Tenacious d                                        Tenacious D in: The Pick of Destiny (2006) | Critics | B- | Community | B-
Trust the man                                      Trust the Man (2006) | Critics | C+ | Community | C+
Worlds fastest indian                              Fastest Indian (2005) | Critics | B- | Community | B
Whirly girl                                        Whirly Girl (2006) | Critics | My Grade: | Community | B
White coats                                        White Coats (2006) | Critics | My Grade: | Community | B-
Sherrybaby                                         Sherrybaby (2006) | Critics | B | Community | B-
Shopgirl                                           Shopgirl (2005) | Critics | B- | Community | B-
The proposition                                    Proposition, The (2006) | Critics | B+ | Community | B
La petite jerusalem                                Petite Jérusalem (2006) | Critics | My Grade: | Community | C+
Mozart and the whale                               Mozart and the Whale (2005) | Critics | My Grade: | Community | B
National lampoon's barely legal                    National Lampoon's Barely Legal (2005) | Critics | My Grade: | Community | C+
National lampoon's dorm daze                       National Lampoon Presents: Dorm Daze (2003) | Critics | My Grade: | Community | C
The lost city                                      Lost City, The (2006) | Critics | C | Community | B-
Looking for comedy in the muslim world             Looking for Comedy in the Muslim World (2006) | Critics | C+ | Community | C
The marine                                         Marine, The (2006) | Critics | C- | Community | B-
Keeping mum                                        Keeping Mum (2006) | Critics | B- | Community | B
Flicka                                             Flicka (2006) | Critics | C+ | Community | B-
Factotum                                           Factotum (2006) | Critics | B | Community | C+
Davinci code                                       Code, The (2006) | Critics | C+ | Community | B-


    D:\Docstoc\Working\pdf\a0dc3401-24a7-4a04-8d2b-f3845df71995.xls   Tab:Movies - page 13                                      7/7/2011; 9:27 PM
Conejo en la luna                                  Conejo en la Luna (2004) | Critics | My Grade: | Community | The Critics:
Down in the valley                                 Down in the Valley (2006) | Critics | C+ | Community | C+
Accepted                                           Accepted (2006) | Critics | C | Community | B
The ant bully                                      Ant Bully, The (2006) | Critics | B- | Community | B-




    D:\Docstoc\Working\pdf\a0dc3401-24a7-4a04-8d2b-f3845df71995.xls   Tab:Movies - page 14                                     7/7/2011; 9:27 PM
                                                        Weather Function
This function returns the current weather, or expected highs/lows for a given zip code

                                                      The syntax of the function is:
                                                         =yWeather(zipcode)
                                                                   or
                                                    =yWeather(zipcode, parameter)

The URL used comes from the mobile site:
http://wap.oa.yahoo.com/raw?dp=weather&zip=94010


  Input                   Output                                                      Other Outputs
Zip Code                                                          Now                          City          High       Low
94010            Partly Cloudy 52 ºF                 Partly Cloudy 52 ºF              Burlingame, CA      70ºF       50ºF
94105            Partly Cloudy 52 ºF                 Partly Cloudy 52 ºF              San Francisco, CA   72ºF       53ºF
94089            Fair 57 ºF                          Fair 55 ºF                       Sunnyvale, CA       74ºF       50ºF




                                                              Tab:Weather - page 15
    D:\Docstoc\Working\pdf\a0dc3401-24a7-4a04-8d2b-f3845df71995.xls                                             7/7/2011; 9:27 PM
                                         The Yahoo 8-Ball




                                       The syntax of the function is:
                                        =y8Ball(yes/no question)

                            Yes/No Question                                        Answer
        Does she like me?                                              As I See It Yes
        Will he ask me to the prom?                                    It Is Certain




                                                           Tab:8
D:\Docstoc\Working\pdf\a0dc3401-24a7-4a04-8d2b-f3845df71995.xls Ball - page 16              7/7/2011; 9:27 PM
1 yr Target Price                 t8        Day's Range                         m
200-day Moving Average            m4        Day's Range (Real-time)             m2
50-day Moving Average             m3        Day's Value Change                  w1
52-week High                      k         Day's Value Change (Real-time)      w4
52-week Low                       j         Dividend Pay Date                   r1
52-week Range                     w         Dividend Yield                      y
After Hours Change (Real-time)    c8        Dividend/Share                      d
Annualized Gain                   g3        Earnings/Share                      e
Ask                               a         EBITDA                              j4
Ask (Real-time)                   b2        EPS Estimate Current Year           e7
Ask Size                          a5        EPS Estimate Next Quarter           e9
Average Daily Volume              a2        EPS Estimate Next Year              e8
Bid                               b         Error Indication (returned for      e1
                                            symbol changed / invalid)
Bid (Real-time)                   b3        Ex-Dividend Date                    q
Bid Size                          b6        Float Shares                        f6
Book Value                        b4        High Limit                          l2
Change                            c1        Holdings Gain                       g4
Change & Percent Change           c         Holdings Gain (Real-time)           g6
Change (Real-time)                c6        Holdings Gain Percent               g1
Change From 200-day Moving        m5        Holdings Gain Percent (Real-time)   g5
Average
Change From 50-day Moving         m7        Holdings Value                      v1
Average
Change From 52-week High          k4        Holdings Value (Real-time)          v7
Change From 52-week Low           j5        Last Trade (Price Only)             l1
Change in Percent                 p2        Last Trade (Real-time) With Time    k1

Change Percent (Real-time)        k2        Last Trade (With Time)              l
Commission                        c3        Last Trade Date                     d1
Day's High                        h         Last Trade Size                     k3
Day's Low                         g         Last Trade Time                     t1




from
http://www.gummy-stuff.org/Yahoo-data.htm
Low Limit                                    l3
Market Cap (Real-time)                       j3
Market Capitalization                        j1
More Info                                    i
Name                                         n
Notes                                        n4
Open                                         o
Order Book (Real-time)                       i5
P/E Ratio                                    r
P/E Ratio (Real-time)                        r2
PEG Ratio                                    r5
Percebt Change From 52-week High             k5
Percent Change From 200-day Moving Average   m6

Percent Change From 50-day Moving Average    m8
Percent Change From 52-week Low              j6
Previous Close                               p
Price Paid                                   p1
Price/Book                                   p6
Price/EPS Estimate Current Year              r6
Price/EPS Estimate Next Year                 r7

Price/Sales                                  p5

Shares Owned                                 s1
Short Ratio                                  s7
Stock Exchange                               x

Symbol                                       s
Ticker Trend                                 t7
Trade Date                                   d2
Trade Links                                  t6
Volume                                       v

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:5
posted:7/8/2011
language:English
pages:18