<ARTICLE ID="xacc-price-sources">

<ARTHEADER>
<TITLE>Stock Ticker</TITLE>
</ARTHEADER>
<sect1>
<TITLE>Price Sources </TITLE>

<para><emphasis>THIS MATERIAL NEEDS TO BE REWRITTEN FOR 1.6!!!</emphasis
</para>
<PARA>GnuCash provides a somewhat rudimentary automated stock quote
gathering system.
If a GnuCash <LINK LINKEND="STOCKACCT">stock account</LINK> is
suitably configured, and the host computer is connected to the
Internet, the program <APPLICATION>gnc-prices</APPLICATION> may be
used to load stock and mutual fund price quotes from various web sites
directly into GnuCash.
</PARA>

<PARA>This is what you do:

<ITEMIZEDLIST>
  <LISTITEM>
    <PARA>Create an account and mark it as being of type "Mutual
      Fund" or "Stock".
    </PARA>
  </LISTITEM>
  <LISTITEM>
    <PARA>Enter a valid ticker symbol in the box marked "Security:"
     </PARA>
  </LISTITEM>
  <LISTITEM>
    <PARA>Select a quote source from the pull-down menu. Currently
    supported quote sources include <EMPHASIS>Yahoo</EMPHASIS>,
    <EMPHASIS>Yahoo Europe</EMPHASIS>, <EMPHASIS>Fidelity
    Investments</EMPHASIS>, <EMPHASIS>T. Rowe Price</EMPHASIS>, the
    <EMPHASIS>Vanguard Group</EMPHASIS>, <EMPHASIS>the Australian
    Stock Exchange</EMPHASIS> (ASX) and
    <EMPHASIS>TIAA-CREF</EMPHASIS>.  Note that Yahoo will provide
    price quotes for many mutual funds <EMPHASIS>including</EMPHASIS>
    Fidelity, T.Rowe Price and Vanguard, and that the quoted prices at
    Yahoo <EMPHASIS>should</EMPHASIS> be identical to those that may
    be found at the source sites (otherwise, somebody's reporting
    wrong information!). If you choose Yahoo Europe, you should append
    the market code for the security, such as PA for Paris, BE for
    Berlin, etc. Example: 12150.PA (a Peugeot security in the Paris
    market).
    </PARA>
  </LISTITEM>
  <LISTITEM>
    <PARA>Ensure that the currency of the account matches the source
    of the stock you have selected. This means:

        <ITEMIZEDLIST>
<LISTITEM>
<PARA>Quotes from the <EMPHASIS>Australian Stock Exchange</EMPHASIS>
          (ASX) should be in Australian dollars (AUD).

          </PARA>
</LISTITEM>
<LISTITEM>
<PARA>Quotes from <EMPHASIS>Yahoo Europe</EMPHASIS> should be in Euros
          (ECU)

          </PARA>
</LISTITEM>
<LISTITEM>
<PARA>Quotes from <EMPHASIS>Yahoo</EMPHASIS>, <EMPHASIS>Fidelity
      Investments</EMPHASIS>, <EMPHASIS>T. Rowe Price</EMPHASIS> 
      and the <EMPHASIS>Vanguard
      Group</EMPHASIS> should be in US Dollars (USD).
        </PARA>
</LISTITEM>
</ITEMIZEDLIST>
      
    </PARA>
</LISTITEM>
</ITEMIZEDLIST>

    <TABLE>
<TITLE>Code List for European Markets</TITLE>
<TGROUP COLS="2">
<THEAD>
<ROW>
<ENTRY>Code</ENTRY>
<ENTRY>Market</ENTRY>
</ROW>
</THEAD>
<TBODY>
<ROW>
<ENTRY>PA</ENTRY>
<ENTRY>Paris</ENTRY>
</ROW>
<ROW>
<ENTRY>BC</ENTRY>
<ENTRY>Barcelona</ENTRY>
</ROW>
<ROW>
<ENTRY>BE</ENTRY>
<ENTRY>Berlin</ENTRY>
</ROW>
<ROW>
<ENTRY>BI</ENTRY>
<ENTRY>Bilbao</ENTRY>
</ROW>
<ROW>
<ENTRY>BR</ENTRY>
<ENTRY>Br&ecirc;me</ENTRY>
</ROW>
<ROW>
<ENTRY>CO</ENTRY>
<ENTRY>Copenhagen</ENTRY>
</ROW>
<ROW>
<ENTRY>D</ENTRY>
<ENTRY>Dusseldorf</ENTRY>
</ROW>
<ROW>
<ENTRY>F</ENTRY>
<ENTRY>Frankfurt</ENTRY>
</ROW>
<ROW>
<ENTRY>H</ENTRY>
<ENTRY>Hamburg</ENTRY>
</ROW>
<ROW>
<ENTRY>HA</ENTRY>
<ENTRY>Hanover</ENTRY>
</ROW>
<ROW>
<ENTRY>L</ENTRY>
<ENTRY>London</ENTRY>
</ROW>
<ROW>
<ENTRY>MA</ENTRY>
<ENTRY>Madrid</ENTRY>
</ROW>
<ROW>
<ENTRY>MC</ENTRY>
<ENTRY>Madrid (M.C.)</ENTRY>
</ROW>
<ROW>
<ENTRY>MI</ENTRY>
<ENTRY>Milan</ENTRY>
</ROW>
<ROW>
<ENTRY>MU</ENTRY>
<ENTRY>Munich</ENTRY>
</ROW>
<ROW>
<ENTRY>O</ENTRY>
<ENTRY>Oslo</ENTRY>
</ROW>
<ROW>
<ENTRY>ST</ENTRY>
<ENTRY>Stockholm</ENTRY>
</ROW>
<ROW>
<ENTRY>SG</ENTRY>
<ENTRY>Stuttgart</ENTRY>
</ROW>
<ROW>
<ENTRY>VA</ENTRY>
<ENTRY>Valence</ENTRY>
</ROW>
<ROW>
<ENTRY>FX</ENTRY>
<ENTRY>Xetra</ENTRY>
</ROW>
</TBODY>
</TGROUP>
</TABLE>

    <TABLE>
<TITLE>Pseudo-symbols that can be used for TIAA-CREF quotes</TITLE>
<TGROUP COLS="2">
<THEAD>
<ROW>
<ENTRY>Name</ENTRY>
<ENTRY>Pseudo-symbol</ENTRY>
</ROW>
</THEAD>
<TBODY>
<ROW>
<ENTRY>Stock</ENTRY>
<ENTRY>CREFstok</ENTRY>
</ROW>
<ROW>
<ENTRY>Money Market</ENTRY>
<ENTRY>CREFmony</ENTRY>
</ROW>
<ROW>
<ENTRY>Equity Index</ENTRY>
<ENTRY>CREFequi</ENTRY>
</ROW>
<ROW>
<ENTRY>Inflation-Linked Bond</ENTRY>
<ENTRY>CREFinfb</ENTRY>
</ROW>
<ROW>
<ENTRY>Bond Market</ENTRY>
<ENTRY>CREFbond</ENTRY>
</ROW>
<ROW>
<ENTRY>TIAA Real Estate</ENTRY>
<ENTRY>TIAAreal</ENTRY>
</ROW>
<ROW>
<ENTRY>Social Choice</ENTRY>
<ENTRY>CREFsoci</ENTRY>
</ROW>
<ROW>
<ENTRY>Teachers PA Stock Index</ENTRY>
<ENTRY>TIAAsndx</ENTRY>
</ROW>
<ROW>
<ENTRY>Global Equities</ENTRY>
<ENTRY>CREFglob</ENTRY>
</ROW>
<ROW>
<ENTRY>Teachers PA Select Stock</ENTRY>
<ENTRY>TIAAsele</ENTRY>
</ROW>
<ROW>
<ENTRY>Growth</ENTRY>
<ENTRY>CREFgrow</ENTRY>
</ROW>
</TBODY>
</TGROUP>
</TABLE>

</PARA>

<PARA>A sample image is shown below:
<INLINEMEDIAOBJECT>
<IMAGEOBJECT>
<IMAGEDATA FILEREF="image/ticker-a.png">
</IMAGEOBJECT>
<TEXTOBJECT>
<PHRASE>Sample Diagram</PHRASE>
</TEXTOBJECT>
</INLINEMEDIAOBJECT>

    </PARA>
<PARA>To update the prices stored in a gnucash account file, run
    the command line command <APPLICATION>gnc-price</APPLICATION>, specifying the
    filename; for example:
<COMMAND>    gnc-prices myaccts.xac</COMMAND>

    </PARA>
<PARA>Running this command will print various diagnostic messages
    to the screen while it loads data. It will work only when the
    host computer is attached to the Internet. It can function in
    conjunction with masquerading-style firewalls and proxy
    servers.

    </PARA>
<PARA>The command can be run many times in one day; however, it
    will update the accounts at most once with the most recent
    trading days price data.

    Thus, if <APPLICATION>gnc-prices</APPLICATION> is run on Friday, Saturday,
    Sunday and Monday, only two price entries will be made: one
    containing Friday's data, and one containing Monday's data,
    since the Saturday and Sunday runs will only retrieve the
    Friday closing price.

    </PARA>
<PARA>To keep <APPLICATION>gnc-prices</APPLICATION> from updating one account, while
    allowing it to update another account, merely mark the data
    source for that account as <SCREEN>(none)</SCREEN>. You can do this
    from the <GUIMENU>Edit Account</GUIMENU> window.

    </PARA>
<PARA>After running <APPLICATION>gnc-prices</APPLICATION> for a few days, your
    accounts will begin to resemble the following:
     <INLINEMEDIAOBJECT>
<IMAGEOBJECT>
<IMAGEDATA FILEREF="image/ticker-b.png">
</IMAGEOBJECT>
<TEXTOBJECT>
<PHRASE>Later Ticker Listing</PHRASE>
</TEXTOBJECT>
</INLINEMEDIAOBJECT>


</PARA>
</SECT1>
</ARTICLE>

<!-- Local variables: -->
<!-- sgml-parent-document: "gnucash.sgml" -->
<!-- End: -->
