[smf_addin] Digest Number 3601

EXCEL Stock Market Functions Add-in Group

5 Messages

Digest #3601

1a

Re: Retrieving Yahoo stock split and dividend info by mark.boogaers

2a

Re: Next earnings date from excel cell? by trendsekr

2b

Re: Next earnings date from excel cell? by "Randy Harmelink" rharmelink

3a

Re: Google data source not available anymore? by c2adf9311e2c386ea6b50154ae931d42

3b

Re: Google data source not available anymore? by "Randy Harmelink" rharmelink

Messages

1a

Re: Retrieving Yahoo stock split and dividend info

Thu Jan 7, 2016 5:26 am (PST) . Posted by:

mark.boogaers

Thanks Randy. Let me try with the UK Yahoo. Morningstar might work, but foreign tickers are in a different format. Basically need to convert 1 by 1 so not the preferred option.

Reply to sender . Reply to group . Reply via Web Post . All Messages (7) . Top ^

2a

Re: Next earnings date from excel cell?

Thu Jan 7, 2016 7:44 am (PST) . Posted by:

trendsekr

Now nearly 3 years later this gives me N/A. Is there an update?

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

2b

Re: Next earnings date from excel cell?

Thu Jan 7, 2016 11:53 am (PST) . Posted by:

"Randy Harmelink" rharmelink

What formula are you using? If you're using the Yahoo element (#1285),
Yahoo only adds the date shortly before earnings reports are due. "N/A" is
what they populate the field with at other times. For example:

http://finance.yahoo.com/q?s=MMM

On Thu, Jan 7, 2016 at 8:44 AM, trendsekr@... wrote:

>
> Now nearly 3 years later this gives me N/A. Is there an update?
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

3a

Re: Google data source not available anymore?

Thu Jan 7, 2016 12:27 pm (PST) . Posted by:

c2adf9311e2c386ea6b50154ae931d42

Thank you Randy,

Can you please point me somewhere or explain how I can use this file?

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

3b

Re: Google data source not available anymore?

Thu Jan 7, 2016 12:38 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You need to put it into the folder where the add-in is located, replacing
the existing file of the same name. If you replace it while you have EXCEL
open, you'll need to either run the smfForceRecalculation macro, or exit
and restart EXCEL.

Those smf-elements-*.txt files contain all of the element definitions.
Basically, they're just saved versions of add-in formulas.

On Thu, Jan 7, 2016 at 1:27 PM, sdglobe@... wrote:

>
> Can you please point me somewhere or explain how I can use this file?
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• New Members 19

• Privacy • Unsubscribe • Terms of Use