[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Markets data & Excel



PureBytes Links

Trading Reference Links

G.G.,

I don't know if others have brought up this problem but "sending a web
page" tends to cause difficulties to my browser when I view them and am
NOT on-line at the time. Often Netscape will crash even with different
versions and settings.

Most people simply copy the web ADDRESS to refer to a site, that seems
to work very well.

If people experience this same problem please let us know so this may be
made aware to others.

Thanks... John

> G. G. wrote:
> 
> Worth a visit.
> G.G.
> 
> http://www.marshall.usc.edu/library/guides/bridge.html
> --
> --End--
> 
> My wife keeps complaining I never listen to her   ...or something like
> that. ;-)
> 
>     ---------------------------------------------------------------
> [Image]                                                        [Image]
> [Image]
>                                 [Image]
> 
>                 Guide to the Bridge Information System
> 
>      Bridge is a real-time financial information service that you
>      can access through the Business School network (HOH, BRI or
>      ACC). You can get up-to-the-minute and historical
>      information about U.S. stocks and markets. Bridge keeps
>      daily data for six months, weekly data for two years, and
>      monthly data for ten years. This user guide will walk you
>      through the more common, and simpler, Bridge resources.
> 
>      Company information
> 
>        1. Go to the "Start Menu," select "Programs," select
>           "Finance" and then "BridgeStation" (ask a staff member
>           to log you in).
>        2. Under "Workspace" select "New" or "Add Display"
>        3. Select "Security Strip"
>        4. Enter the company ticker symbol (If you don't know your
>           ticker symbol, use the lookup feature – "File," "Add
>           Workspace," and select "Lookup.")
> 
>      This display gives you the current stock price. To get more
>      information, double-click on the TICKER symbol in the
>      Security Strip display. A menu will pop up with a variety of
>      choices.
> 
>        To look up:      Select:
> 
>        Historical       Ä Price history
>        stock prices     Ä Daily, weekly or monthly
> 
>        Financial              Method one           Method two
>        ratios            Ä Fundamental       Ä Fundamental
>                          Analysis            Analysis
>                          Ä Fundamental
>                          Profile             Ä Corporate Profile
> 
>                             Ä Value Ratios      Ä Operating
>                                              Ratios
> 
>        Dividend         Ä Fundamental Analysis
>        information      Ä Corporate Profile
>                         Ä Dividends
> 
>        News             Ä NewsSearch or NewsWatch
> 
>      Indexes and Futures
> 
>        1. Under "Workspace" select "Add Display" or "New"
>        2. Select "Market Watch"
>        3. Select an index or a futures commodity
> 
>      Index                 Symbol       Futures              Symbol
>      Dow Jones Industrial
>      Average               DJIA         Metals               METALS
>      Nasdaq                NDX          Grains               GRAINS
>      S & P 500             SP500        Agriculture          AGRICUL
>      S & P 100             SP100
>      Treasury bills        Bonds
> 
>     ---------------------------------------------------------------
> 
>      Printing and saving data
> 
>      To print:
> 
>           Under "Workspace" select "Print Display"
> 
>      To save data:
> 
>           In order to save data from Bridge, you need to access
>           Bridge through Excel. (Note: If you need assistance,
>           you must speak with a reference librarian.)
> 
>      Step one: setup
> 
>        1. Open Excel
>        2. Open "Tools" menu, and choose "Add-ins"
>        3. Click on "Browse" and follow this path:
>           c:\windows\apps\bridge\bws32\etc\btools.
>        4. Double click on btools.
>        5. Back at the "Add-ins" window, click on "OK."
>        6. A Bridge Tools option will appear in the Excel menu. In
>           order to display information from Bridge on Excel, the
>           Bridge Dynamic Data Exchange (BDDE) file must be open.
>        7. To access the Bridge Dynamic Data Exchange (BDDE), use
>           the "Find Files" function (under the Windows Menu bar)
>           to find the bdde.exe file. Double click on bdde.exe.
>           You will be asked for the Bridge password (ask a staff
>           member for asssistance). Close the "Find Files" window.
> 
>      Step two: get data
> 
>        1. In Excel, choose the cell on the spreadsheet where you
>           want your data to start.
>        2. From the "Bridge Tools" menu, choose "History." This is
>           where you specify the data you want.
>        3. Fill in the ticker symbol, the time units (days, weeks,
>           months, etc.), how many units you want, and the type of
>           information you want. The options on the list work like
>           a toggle switch. (Click on LS, and Last Sale is added
>           to your list. Click on LS again, and it is removed.)
>        4. Click on "Copy Link," then click on "Exit."
>        5. From "Bridge Tools" again, choose "Paste Link." This
>           will start your tabular data at the cell you chose in
>           step one.
>        6. From here, you can manipulate the data, print, and save
>           as an Excel file.
>        7. You can also open a real-time ticker. Again, choose a
>           starting cell on the spreadsheet. From Bridge Tools,
>           choose Ticker. Enter your ticker symbol and any other
>           parameters. Click OK. Your ticker table will begin from
>           the cell you chose.
> 
>                                 [Image]
> 
>    Marvel Home Page | Information Services Division | Search HOMER |
>                          Access Global Express
> 
>                                 [Image]
> 
>           Direct questions about these web pages to the Webmaster