Profile cover photo
Profile photo
InvestExcel
18 followers -
Resources for Option Pricing, Financial Modeling and Investment
Resources for Option Pricing, Financial Modeling and Investment

18 followers
About
Posts

Post has attachment
How does Yahoo Finance calculate the beta of a stock? What assumptions and data does it use? Find out here.

Post has attachment

Post has attachment
Calculate dividend growth rates with data downloaded from the Internet. You only need the stock ticker

Post has attachment
Calculate if a stock is priced fairly with the Gordon Growth model. This approach assumes that the intrinsic value of a stock is the sum of the future value of all the dividends.

Post has attachment
Create Candlestick charts automatically with VBA. Download the spreadsheet at http://investexcel.net/plot-candlestick-chart-vba/

Post has attachment

Post has attachment

Post has attachment
Calculate your car payments with this free spreadsheet

Post has attachment
Find undervalued utility stocks with the Graham Number

Post has attachment
VBA function gives the current share price price, EPS, PE, or any other of over 80 financial quotes updated, via the web. Uses the Yahoo Finance API
Wait while more posts are being loaded