This blog will be a place where we will share our thoughts, ideas and news covering finance, trading and technology. We will post product news, articles about Excel as well as thoughts on developments in trading and financial markets.
We hope you enjoy what we write and we would love to hear from you, so all comments welcome!
Andy.
Hey! I was wondering how I can ensure that I have the most recent financial statement figures without having to go into each stock separately and checking. ex: =epf.yahoo.annualcurrentassets(“aapl”, 2020) may show me apples recent 10-K numbers, or it may show me #N/A. then I would have to go to 2019’s financials which would be a year too late.
Any help would be great!
LikeLike
Hi Marco,
Thanks for you interest in our product. You could use an Excel IF statement combined with the ISNUMBER function, for example:
=IF(ISNUMBER(EPF.Yahoo.AnnualRevenue(“AAPL”,2020)),EPF.Yahoo.AnnualRevenue(“AAPL”,2020),EPF.Yahoo.AnnualRevenue(“AAPL”,2019))
This will show the 2020 revenue number (if it exists) otherwise the 2019 number.
I hope this helps!,
Andy
LikeLiked by 1 person
Hi, just wondering if dividend payments will be included soon for payments made (not dividend yield but actual dividends paid). Cheers
LikeLike
Hi Shaun,
Thanks for your comment.
The Add-in does provide dividend payment history, for example the below formula will retrieve Microsoft dividends since 1 Jan 2019:
=EPF.Yahoo.DividendsDatePeriod(“MSFT”, “1 Jan 2019”, “1 Nov 2020″,”DESC”, 1)
More details in the User Guide: https://www.excelpricefeed.com/userguide/excel-array-formulas-yahoo-finance#EPF.Yahoo.DividendsDatePeriod
Andy
LikeLike