Sabtu, 13 Februari 2016

[smf_addin] Digest Number 3634

11 Messages

Digest #3634
1a
formula help by friedman_steve
1b
Re: formula help by "Randy Harmelink" rharmelink
2a
Re: spreadsheet help by "Jim Ranum" amt2100
2b
Re: spreadsheet help by "Randy Harmelink" rharmelink
2c
Re: spreadsheet help by "Jim Ranum" amt2100
2d
Re: spreadsheet help by "Randy Harmelink" rharmelink
2e
Re: spreadsheet help by "Jim Ranum" amt2100
2f
Re: spreadsheet help by "Randy Harmelink" rharmelink
2g
Re: spreadsheet help by "Jim Ranum" amt2100
3a
Retrieving NAV Values by "Michael Thomas" thomas91112
3b
Re: Retrieving NAV Values by "Randy Harmelink" rharmelink

Messages

Fri Feb 12, 2016 6:35 am (PST) . Posted by:

friedman_steve

Hi,
just looking for a bit of formula help I can't get to work.


from the site: "http://www.nasdaq.com/earnings/report/splk" (but also written where the stock is referenced from cell A1.




1) Want to grab the date from bar: "Earnings announcement" (Feb 25 2016)
2) Want to grab the text below that bar, (in this stock example: "Splunk Inc. is expected* to report earnings on 02/25/2016 after market close. The report will be for the fiscal Quarter ending Jan 2016."




Thanks ahead of time.


Steve


Fri Feb 12, 2016 9:31 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Try:

=smfStrExtr(smfGetTagContent("http://www.nasdaq.com/earnings/report/"&A1,"h2",-1,"id=""reportdata-div"""),":
","~")
=smfGetTagContent("http://www.nasdaq.com/earnings/report/
"&A1,"p",1,"id=""reportdata-div""",,,,1)

On Fri, Feb 12, 2016 at 7:35 AM, friedman_steve@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> just looking for a bit of formula help I can't get to work.
>
> from the site: "http://www.nasdaq.com/earnings/report/splk" (but
> also written where the stock is referenced from cell A1.
>
> 1) Want to grab the date from bar: "Earnings announcement" (Feb 25
> 2016)
>
> 2) Want to grab the text below that bar, (in this stock example: "Splunk
> Inc. is expected* to report earnings on 02/25/2016 after market close. The
> report will be for the fiscal Quarter ending Jan 2016."
>
>

Fri Feb 12, 2016 9:47 am (PST) . Posted by:

"Jim Ranum" amt2100

Hi Randy,

In the last couple days, my spreadsheet stays active for several minutes after I first open it, then it just stops updating info.
When I try to run the Force Recalc macro, I get this message and I can't figure out how to fix it.


No other changes have been made to the spreadsheet. Been using it fine for years.

Thanks a bunch.
Best regards,
Jim



Fri Feb 12, 2016 9:55 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Does that location match up with the location you have for the add-in in
the add-in manager? Check:

=RCHGetElementNumber("Version&quot;)

Do you have location errors on your formulas? That is, do some have
hard-coded paths on them? Does EXCEL give you any warnings when it opens
the workbook?

On Fri, Feb 12, 2016 at 10:47 AM, 'Jim Ranum' amt2100@... wrote:

>
>
> In the last couple days, my spreadsheet stays active for several minutes
> after I first open it, then it just stops updating info.
>
> When I try to run the Force Recalc macro, I get this message and I can't
> figure out how to fix it.
>
>
>
>
>
> No other changes have been made to the spreadsheet. Been using it fine for
> years.
>
>
>
>

Fri Feb 12, 2016 11:47 am (PST) . Posted by:

"Jim Ranum" amt2100

Hi Randy,

No errors. Works fine when opening for several minutes. Then just stops updating and even using F2 on a cell won't work.
Just get the message below when trying to use the Force Recalc macro.

The version shows up as:
Stock Market Functions add-in, Version 2.1.2015.07.08 (C:\SMF Add-In; ; ; 1)

The Macro message points to C:\Program Files\SMF Add-in vs. C:\SMF Add-In
How do I redirect the Macro? Don't you advocate having the add-in located in the C:\ root directory?

Thanks.

Best regards,
Jim



From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, February 12, 2016 12:55 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] spreadsheet help


Does that location match up with the location you have for the add-in in the add-in manager? Check:
=RCHGetElementNumber("Version&quot;)
Do you have location errors on your formulas? That is, do some have hard-coded paths on them? Does EXCEL give you any warnings when it opens the workbook?

On Fri, Feb 12, 2016 at 10:47 AM, 'Jim Ranum' amt2100@... wrote:

In the last couple days, my spreadsheet stays active for several minutes after I first open it, then it just stops updating info.
When I try to run the Force Recalc macro, I get this message and I can't figure out how to fix it.


No other changes have been made to the spreadsheet. Been using it fine for years.




Fri Feb 12, 2016 11:59 am (PST) . Posted by:

"Randy Harmelink" rharmelink

You'd want to use the macro from the "C:/SMF Add-in" folder, since that is
the add-in you are using, and yes, it is in the currently recommended
location.

If you're clicking on a button to run the macro, I think you have to delete
the button and recreate it. I don't think there is a way to modify the
location of the macro on an existing button.

But I'm not sure what to make of the workbook stopping updating. I doubt
smfForceRecalculation is going to help that issue. I would suspect those
things that aren't updating probably have location errors.

On Fri, Feb 12, 2016 at 12:47 PM, 'Jim Ranum' amt2100@gmail.com [smf_addin]
<smf_addin@yahoogroups.com> wrote:

>
>
> No errors. Works fine when opening for several minutes. Then just stops
> updating and even using F2 on a cell won't work.
>
> Just get the message below when trying to use the Force Recalc macro.
>
>
>
> The version shows up as:
>
> Stock Market Functions add-in, Version 2.1.2015.07.08 (C:\SMF Add-In; ; ;
> 1)
>
>
>
> The Macro message points to C:\Program Files\SMF Add-in vs. C:\SMF Add-In
>
> How do I redirect the Macro? Don't you advocate having the add-in located
> in the C:\ root directory?
>
>
>
>

Fri Feb 12, 2016 12:14 pm (PST) . Posted by:

"Jim Ranum" amt2100

OK, makes sense.
Can you please refresh my memory on how to add that macro button back on there after I delete the bad one?
In looking at the MS Excel Help info, it says how to add a button, but it shows 2 kinds of macros, Active-X and a Form macro. Which is the one we need?

Thanks.

Best regards,
Jim



From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, February 12, 2016 2:59 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] spreadsheet help


You'd want to use the macro from the "C:/SMF Add-in" folder, since that is the add-in you are using, and yes, it is in the currently recommended location.
If you're clicking on a button to run the macro, I think you have to delete the button and recreate it. I don't think there is a way to modify the location of the macro on an existing button.
But I'm not sure what to make of the workbook stopping updating. I doubt smfForceRecalculation is going to help that issue. I would suspect those things that aren't updating probably have location errors.

On Fri, Feb 12, 2016 at 12:47 PM, 'Jim Ranum' amt2100@gmail.com <mailto:amt2100@gmail.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:

No errors. Works fine when opening for several minutes. Then just stops updating and even using F2 on a cell won't work.
Just get the message below when trying to use the Force Recalc macro.

The version shows up as:
Stock Market Functions add-in, Version 2.1.2015.07.08 (C:\SMF Add-In; ; ; 1)

The Macro message points to C:\Program Files\SMF Add-in vs. C:\SMF Add-In
How do I redirect the Macro? Don't you advocate having the add-in located in the C:\ root directory?




Fri Feb 12, 2016 12:42 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

This is more or less what I did:

http://www.dummies.com/how-to/content/how-to-add-an-excel-2007-macro-to-the-quick-access.html

On Fri, Feb 12, 2016 at 1:14 PM, 'Jim Ranum' amt2100@...wrote:

>
> OK, makes sense.
>
> Can you please refresh my memory on how to add that macro button back on
> there after I delete the bad one?
>
> In looking at the MS Excel Help info, it says how to add a button, but it
> shows 2 kinds of macros, Active-X and a Form macro. Which is the one we
> need?
>
>
>
>

Fri Feb 12, 2016 1:06 pm (PST) . Posted by:

"Jim Ranum" amt2100

All fixed.

Thanks very much Randy.

Best regards,
Jim



From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, February 12, 2016 3:43 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] spreadsheet help


This is more or less what I did:

http://www.dummies.com/how-to/content/how-to-add-an-excel-2007-macro-to-the-quick-access.html

On Fri, Feb 12, 2016 at 1:14 PM, 'Jim Ranum' amt2100@...wrote <mailto:amt2100@...wrote> :

OK, makes sense.
Can you please refresh my memory on how to add that macro button back on there after I delete the bad one?
In looking at the MS Excel Help info, it says how to add a button, but it shows 2 kinds of macros, Active-X and a Form macro. Which is the one we need?




Fri Feb 12, 2016 10:12 am (PST) . Posted by:

"Michael Thomas" thomas91112

For an ETF, what function should I use to retrieve its NAV value from Yahoo Finance?ThanksMike

Fri Feb 12, 2016 10:46 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Try:

=RCHGetTableCell("http://finance.yahoo.com/q?s=spy",1,">NAV")

On Fri, Feb 12, 2016 at 11:12 AM, Michael Thomas thomas91112@... wrote:

>
>
> For an ETF, what function should I use to retrieve its NAV value from
> Yahoo Finance?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar