Showing posts with label finance. Show all posts
Showing posts with label finance. Show all posts

Thursday, August 27, 2015

How to Monitor Stock Prices in Microsoft Excel


Open a blank Microsoft Excel spreadsheet.
Click on a cell where you want to show a stock price.
Click on 'Data' in the top menu bar.
Scroll down to 'Import External Data,' then over to 'New Web Query.'
In the window that pops up, type the URL http://finance.yahoo.com in the address.
Enter the stock symbol you wish to track. Be sure to double check that you entered the correct stock symbol by checking the company name that shows.
Scroll down to 'Last trade:' and click on the arrow to the left. The arrow will change to a check mark. The data highlighted will be shown on your spreadsheet.
Choose the data you wish to be in your spreadsheet, then click on the 'Import' button at the bottom of the window. You may choose to add any data with an arrow next to it into your spreadsheet by clicking on the arrow to the left of the data.
Verify the cell where you want the data to appear when prompted. You can click on any cell in the spreadsheet if you wish to change the location. Click on 'OK' after choosing the cell.
Save the spreadsheet. You can update the stock price(s) any time by clicking on 'Data' in the top menu bar. Then scroll down to 'Refresh Data' and click on it.
Know that you can also update the stock prices in the 'External Data' toolbar. Just click on the red exclamation point in that toolbar.

Sunday, August 23, 2015

How to Invest in the Paris Bourse Stock Exchange


Learn how the Euronext is structured. In September 2000, the Paris Bourse Stock Exchange became the Paris-based Euronext exchange, with subsidiary exchanges based in five other European countries. In 2006, the New York Stock Exchange (NYSE) Group and the Euronext merged to form the NYSE Euronext.
Speak to your financial adviser about your personal finance plan. Determine how much money to invest in the exchange formerly known as the Paris Bourse, remembering that any wise investor knows better than to sink everything into a single place.
Open a trading account with a discount brokerage. Thanks to the merger of the NYSE and the Euronext, international investors have much easier access to the Paris stock exchange than they do to other major international stock markets. Thus your buy and sell requests don't necessarily have to be routed through a Paris-based broker for your order to be filled.
Choose a French company to invest in. The best way to find these is to track trends in the Paris exchange by reading local, English-language financial papers and following the market for a period of weeks or months. Check into a company's background the same as you would for a domestic stock: know the share's price history, review financial statements, check earnings forecasts and make a decision about which company's stock offers the best value.
Place an order to buy shares of the company you've decided upon through your brokerage. Use the NYSE Euronext's English homepage to get up-to-date stock quotes and follow your investment (see Resources below).