11 Messages
Digest #3634
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
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."
>
>
=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
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")
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.
>
>
>
>
the add-in manager? Check:
=RCHGetElementNumbe
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")
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.
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:
=RCHGetElementNumbe
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?
>
>
>
>
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.
> 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?
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.
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?
>
>
>
>
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?
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@
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?
>
>
=RCHGetTableCell("http://finance.yahoo.com/q?s=spy",1,"
On Fri, Feb 12, 2016 at 11:12 AM, Michael Thomas thomas91112@
>
>
> 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:
Posting Komentar