Welcome to our blog

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.

2 thoughts on “Welcome to our blog

  1. Marco Aceto June 23, 2020 / 4:59 am

    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!

    Like

    • andysinclair June 23, 2020 / 1:37 pm

      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

      Liked by 1 person

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s