Newsgroups: misc.invest
Subject: Online Company and Fund Data (LONG) was: Is Mutual Fund Info Avail ...
From: gary@intrepid.com (Gary Funck)
Date: 14 Apr 92 18:26:11 GMT
Distribution: usa
Organization: Intrepid Technology, Inc.


In article <1992Apr12.145746.2431@cbfsb.cb.att.com> you write: >
>Does anyone know where I can get this information in ASCII format?
>I could then write UNIX shell scripts, awk programs, or even 'C'
>programs to extract info from the database exactly as I want it.
>I'd also be able to print the results of my work, something I can't 
>do from Wealthbuilder (I'm not set up to print non-ASCII stuff).  

DISCLAIMER: Although I'm generally happy with the Prodigy
service, I strongly believe there has to be a better way to get
financials and price info. without paying thousands a year.  Using
Prodigy is time consuming, but it is priced within reach of an
individual investor.

[PS: I don't own any Sears, IBM, or Prodigy stock, but with IBM's
recent move I've been thinking twice on that one :-)]

BTW, If any one else out there subscribes to Strategic Investor
and would like to collaborate on writing (UNIX based) analysis and
database programs, let's talk.

Scott,

This may not answer your question directly: I use Prodigy ($13/month)
and its Strategic Investor service (another $15/month).  With SI, you
can search for mutual funds, and download to a PC (or Mac) in
delimited ASCII format.  Unfortunately, getting a *lot* of data
this way is painful (manual pointing and clicking, selecting
5 mutual funds/stocks at a crack).

I recently downloaded data on 300 companies. This took
about ten hours of my time.  Painful, yes.  The exercise has proven
productive in terms of pointing me towards some undervalued stocks.

Below is an example: a formatted company financial summary, and a
delimited mutual fund file.

(I haven't gotten around to formatting the mutual fund info.).


------- company financials in human readable form ---------------

SILICON GRAPHICS     symbol: SGI    sic: 3570      

STOCK PRICE          18.00 as of 04/11/92  
52 week high         29.75
52 week low          13.25
earnings/share        0.66
dividend              0.00

PRICE HISTORY     1991    1990    1989    1988    1987
year end         22.63   13.50   14.63    9.38    8.13
year high        24.38   20.44   14.69   12.38   14.13
year low         11.13    9.00    7.13    6.75    5.38

shares outstanding:      44.0 (million)
average weely volume:     4.0%
institional holdings:    67.4%
closely held holdings:   11.0%

KEY RATIOS        04/11/92  1 yr. ago   Industry
P/E ratio               24        23         0
price/sales           1.24      2.04      0.35
price/book            2.12      4.07      0.73
yield                 0.00      0.00      0.52
beta                  1.33      1.58      1.27

PERFORMANCE          12/91  1 yr. ago   Industry
profit margin          5.2%      7.7%     -2.3%
return on equity       8.9%     15.3%     -4.7%
return on assets       4.8%      8.9%     -2.1%

FINANCIAL STRENGTH      12/91  1 yr. ago   Industry
debt/equity               0.1       0.2       0.4
l. t. debt/cap.           0.1       0.1       0.3
Quick ratio               3.6       2.8       1.1
current ratio             4.3       3.6       1.5

GROWTH RATE (in percent) [as of FY ending  6/91]
                    1 yr.        3 yr.       5 yr.
                  Co.  Ind.    Co.  Ind.   Co.  Ind.
sales            31.0  -0.3   44.4   4.6   58.9   8.2
earnings          2.1   0.0   69.2   0.0   33.7   0.0
dividend          0.0  -2.9    0.0  -1.2    0.0   2.0

NOTES:
     STOCK SPLIT/DIVIDEND - PER SHARE DATA ADJUSTED
     ACQUISITION OF ASSETS

INCOME STATMENT [millions]
                     3 months ended        6 months ended
                    12/91      12/90      12/91      12/90
total revenue       188.0      136.0      339.8      251.8
net income           12.5       10.4       20.2       20.0
earnings/share       0.25       0.25       0.39       0.47
div./share           0.00       0.00       0.00       0.00

FISCAL YEARS ENDING
                     6/91       6/90       6/89       6/88
total revenue       549.9      419.8      263.8      152.6
net income           32.9       32.3       11.5       12.5
earnings/share        0.7        0.8        0.3        0.4
div./share            0.0        0.0        0.0        0.0

BALANCE SHEET [millions]
                         AS OF        - AT FISCAL YEAR END -
                         12/91            6/91        6/90
current assets           535.6           479.5       298.1
long term assets         162.7           162.3        66.2
TOTAL ASSETS             698.3           641.8       364.3

current liabilities      124.9           116.2        83.5
l. t. liabilities         33.0            30.3        36.4
TOTAL LIABILITIES        157.9           146.5       120.0

prefered stock           166.7           166.7        34.0
common stock             373.6           328.6       210.3
TOTAL STOCK              540.3           495.3       244.3

FREE CASH FLOW [millions]
                            FISCAL YEARS ENDING
                          6/91       6/90       6/89
EARNINGS                  32.9       32.3       11.5

depreciation              31.3       22.3       15.1
other sources              3.5        0.6       -0.3
capital expenses         -47.2      -29.6      -23.3
dividends                  0.0        0.0        0.0

free cash flow            20.5       25.6        3.0
free cash flow/share       0.5        0.7        0.1


------- mutual fund delimited file, displayed vertically --------
SYMBOL                         WEINX
FUND NAME                      AIM WEINGARTEN FUND, INC.
FIRST OFFERING                 03/67
OBJECTIVE                      Growth - Long-Term
PERIOD ENDING                  02/29/92
CUM 1 MONTH RET                -1.05
CUM 3 MONTH RET                10.22
CUM 1 YEAR RET                 23.10
CUM 3 YEAR RET                 93.58
CUM 5 YEAR RET                 102.95
CUM 10 YEAR RET                641.12
CUM MARKET CYCLE RET           59.55
ANNUALIZED 1 MONTH RET         -11.94
ANNUALIZED 3 MONTH RET         47.57
ANNUALIZED 1 YEAR RET          23.10
ANNUALIZED 3 YEAR RET          24.63
ANNUALIZED 5 YEAR RET          15.21
ANNUALIZED 10 YEAR RET         22.18
ANNUALIZED MARKET CYCLE RET    17.80
VS S&P 1 MONTH RET             -28.63
VS S&P 3 MONTH RET             -2.92
VS S&P 1 YEAR RET              +6.87
VS S&P 3 YEAR RET              +8.07
VS S&P 5 YEAR RET              +3.71
VS S&P 10 YEAR RET             +3.81
VS S&P MARKET CYCLE RET        +3.67
RANK IN OBJ 1 MONTH RET        10
RANK IN OBJ 3 MONTH RET        8
RANK IN OBJ 1 YEAR RET         4
RANK IN OBJ 3 YEAR RET         2
RANK IN OBJ 5 YEAR RET         1
RANK IN OBJ 10 YEAR RET        1
RANK IN OBJ MARKET CYCLE RET   1
RANK OVERALL 1 MONTH RET       10
RANK OVERALL 3 MONTH RET       3
RANK OVERALL 1 YEAR RET        2
RANK OVERALL 3 YEAR RET        1
RANK OVERALL 5 YEAR RET        1
RANK OVERALL 10 YEAR RET       1
RANK OVERALL MARKET CYCLE RET  1
SALES CHARGE                   5.500
BACK END LOAD                  0.000
EXPENSE RATIO                  1.30
12B-1 FEES                     0.29
MANAGER                        HARRY HUTZLER/JON SCHOOLAR
YEAR MGR BEGAN                 1969
FAMILY/GROUP                   AIM FUNDS
OPEN NEW INVESTORS             Y
OPEN NEW IRA                   Y
PHONE SWITCHING                Yes
WITHDRAWAL PLAN                Yes
IRA ACCTS                      Yes
REPORT DATE                    09/30/91
TOTAL ASSETS                   3293.2
CASH & EQUIV                   6.3
COMMON STOCK                   93.8
PREFERRED STOCK                0.0
CONV ISSUES                    0.0
WARRANTS                       0.0
CORP BONDS                     0.0
MUNI BONDS                     0.0
GOVT BONDS                     0.0
OTHER                          0.0
DIST AS OF                     02/29/92
YTD INCOME                     $0.0000
YTD CAP GAIN                   $0.0000
LAST DIV                       12/16/91
LAST INCOME/SHARE              $0.0675
LAST CAP/SHARE                 $0.0875
DIVIDEND YIELD                 0.38
TURNOVER RATIO                 79.0
AVG MATURITY                   
MATURITY UNITS                 
BETA                           1.17
ALPHA                          0.38
VOLATILITY                     5
-- 
| Gary Funck  		    gary@intrepid.com  [uunet!uupsi!intrepid!gary]
| Intrepid Technology Inc., Mountain View CA (415) 964-8135
--
Newsgroups: misc.invest