search

cmallwitz / Financials-Extension

Extension for LibreOffice Calc to access stock market data
Other
145 stars 19 forks source link

Net Asset Value #43

Open jbourvic opened 2 years ago

jbourvic commented 2 years ago

Closed End Funds (CEFs) are stocks that act like mutual funds but trade like ETFs generally. However, they have one characteristic that is unique to them: a Premium/Discount % (this can be a positive or negative percentage).

This P/D value is determined by the Market Price divided by the Net Asset Value price. Stocks, mutual funds and ETFs all try to recalculate the NAV of their assets to keep the NAV as close to the current price of the asset. But CEFs do things differently. Investors can bid up the value of CEF stock such that you could be paying $1.10 for $1.00 of NAV; or $0.90 for $1.00.

It would be beneficial if there were a code to scrape the NAV value. We could then use Calc to determine the current P/D value. Would this be a possibility?

jbourvic commented 1 year ago

I would like to update this question pertaining to Closed End Funds (CEFs) and Business Development Companies (BDCs). Due to their unique nature. the current market price vs their net asset value (NAV) becomes a significant determining factor in evaluating a purchase. This difference is called the Premium/Discount (or P/D) of the fund. There is a website that shows this, as well as other significant information for these funds. Can www.cefdata.com be accessed to scrape these details? Or is that problematic.