[smf_addin] Digest Number 3177

EXCEL Stock Market Functions Add-in Group

9 Messages

Digest #3177

1a

Re: obtaining data by isabella.ascione

1b

Re: obtaining data by "Randy Harmelink" rharmelink

1c

Re: obtaining data by "Kermit W. Prather" kermitpra

1d

Re: obtaining data by isabella.ascione

1e

Re: obtaining data by isabella.ascione

1f

Re: obtaining data by isabella.ascione

1g

Re: obtaining data by "Kermit W. Prather" kermitpra

2a

Re: How to make difference at FT for interim and annual data by holmberg_tommy

2b

Re: How to make difference at FT for interim and annual data by "Randy Harmelink" rharmelink

Messages

1a

Re: obtaining data

Thu Sep 11, 2014 6:20 am (PDT) . Posted by:

isabella.ascione

Yes, I am using Chrome (if matters..) and when I am clicking on Link 9.5.1 I am being re-directed to

http://finance.groups.yahoo.com/group/smf_addin/message/7625 http://finance.groups.yahoo.com/group/smf_addin/message/7625



The reason I am doing this is to educate myself on the use of the smfForceRecalculation macro


Thank you the other yahoo quote questions were resolved.

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

1b

Re: obtaining data

Thu Sep 11, 2014 6:42 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sounds like Chrome is serving up a cached web page. You may need to use
Ctrl+F5 instead of just F5. The Ctrl+F5 keyboard shortcut says to reload
the current page, overriding the cache.

But I'm only marginally familiar with Chrome.

On Thu, Sep 11, 2014 at 6:20 AM, kenken171@... wrote:

>
> Yes, I am using Chrome (if matters..) and when I am clicking on Link 9.5.1
> I am being re-directed to
>
> http://finance.groups.yahoo.com/group/smf_addin/message/7625
>
> The reason I am doing this is to educate myself on the use of the smfForceRecalculation
> macro
>
> Thank you the other yahoo quote questions were resolved.
>

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

1c

Re: obtaining data

Thu Sep 11, 2014 6:49 am (PDT) . Posted by:

"Kermit W. Prather" kermitpra

Have you ever thought about reading the documentation that Randy did such a great job putting together?

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Thursday, September 11, 2014 8:31 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] obtaining data


Hello,

I am sorry, I sent my previous email unfinished.

Could you help me by telling me which functions to use to obtain the following data based on entered ticker:

- company name

- current stock price

- reporting or not same store sales

- earnings report date

- ex-dividend date

- aver. daily volume

The source of data is not important. How the refreshing works?


Thank you

Kaloyan

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

1d

Re: obtaining data

Thu Sep 11, 2014 6:54 am (PDT) . Posted by:

isabella.ascione

The key combination did work indeed. Thank you.

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

1e

Re: obtaining data

Thu Sep 11, 2014 7:20 am (PDT) . Posted by:

isabella.ascione

Kermit

I ask what I want and when I want it, politely! Thanks for your constructivism and enjoy your day.

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

1f

Re: obtaining data

Thu Sep 11, 2014 7:32 am (PDT) . Posted by:

isabella.ascione

I can ask what I want and when I want!

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

1g

Re: obtaining data

Thu Sep 11, 2014 7:52 am (PDT) . Posted by:

"Kermit W. Prather" kermitpra

Of course, you can. But don't you think it would be more productive if we did not waste Randy's time asking questions that he had already answered dozens of times.

Sorry, I should have been more politically correct in making my suggestion.

In the past, I too, have been guilty of taking advantage of Randy's time and generosity.

Have a nice day

Kermit

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Thursday, September 11, 2014 10:32 AM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] obtaining data


I can ask what I want and when I want!

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

2a

Re: How to make difference at FT for interim and annual data

Thu Sep 11, 2014 7:37 am (PDT) . Posted by:

holmberg_tommy

Hi,

Was it luck or something but I actually found different addresses for those two tables.


Annual data is located at:


http://markets.ft.com/research/Markets/Tearsheets/Financials?s=AFSI:NSQ&subview=BalanceSheet&period=a http://markets.ft.com/research/Markets/Tearsheets/Financials?s=AFSI:NSQ&subview=BalanceSheet&period=a


Whereas interim data is located at:


http://markets.ft.com/research/Markets/Tearsheets/Financials?s=AFSI:NSQ&subview=BalanceSheet&period=b http://markets.ft.com/research/Markets/Tearsheets/Financials?s=AFSI:NSQ&subview=BalanceSheet&period=b





So only difference is the last letter. Formula is now working but still, thanks.


Best regards: Tommy Holmberg

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

2b

Re: How to make difference at FT for interim and annual data

Thu Sep 11, 2014 7:55 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Thanks for letting us know. I didn't see it.

On Thu, Sep 11, 2014 at 7:37 AM, holmberg_tommy@...wrote:

>
> Was it luck or something but I actually found different addresses for
> those two tables.
>
> Annual data is located at:
>
> *http://markets.ft.com/research/Markets/Tearsheets/Financials?s=AFSI:NSQ&subview=BalanceSheet&period=a
> <http://markets.ft.com/research/Markets/Tearsheets/Financials?s=AFSI:NSQ&subview=BalanceSheet&period=a>*
>
> Whereas interim data is located at:
>
> *http://markets.ft.com/research/Markets/Tearsheets/Financials?s=AFSI:NSQ&subview=BalanceSheet&period=b
> <http://markets.ft.com/research/Markets/Tearsheets/Financials?s=AFSI:NSQ&subview=BalanceSheet&period=b>*
>
> So only difference is the last letter. Formula is now working but still,
> thanks.
>
>

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 26

• Privacy • Unsubscribe • Terms of Use