Senin, 28 November 2016

[smf_addin] Digest Number 3852

12 Messages

Digest #3852

Messages

Sun Nov 27, 2016 3:52 am (PST) . Posted by:

bleushin19

Hi Randy,


I hope you could help me about smfGetTagContent.


I'm trying to get the number of employees from the link:
=smfGetTagContent("http://finance.yahoo.com/q/pr?s="AAPL,"span",1,">Full Time Employees",,,,1)



output shows me: Business Summary


While:


=smfGetTagContent("http://finance.yahoo.com/q/pr?s="AAPL,"span",0,">Full Time Employees",,,,1)



output shows me: Full Time Employees: 116,000Business Summary


How will I be able to remove the Business Summary from the output? I think I'm missing something on the parameters to use.


Thanks,


Sun Nov 27, 2016 4:07 am (PST) . Posted by:

bleushin19

Thanks.. Got it. Used the =RCHGetTableCell from your topic Yahoo! Groups https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/8127

https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/8127

Yahoo! Groups https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/8127 Oops! Sorry, an error occurred while loading the content.



View on groups.yahoo.com https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/8127
Preview by Yahoo





Thanks Randy.

Sun Nov 27, 2016 4:15 am (PST) . Posted by:

rjemery7

Array Entered smfPricesByDates


If one uses the function smfPricesByDates in an array entered formula, the Ticker is also hard coded, is it not, even if the ticker is outside the range? Changing the Ticker (in A2 according to the Examples on page 34 of the documentation) then has no effect on the array entered formula.


In Excel (2007), is it possible to have the array formula independent of the cell holding the Ticker?


After all, the array formula itself is little more than dates, and I would like to change the Ticker and have the array formula report updated data for the new Ticker with the same dates already established.

Sun Nov 27, 2016 5:22 am (PST) . Posted by:

"Randy Harmelink" rharmelink

If you refer to a cell containing the ticker symbol, the formula results
should change if you change the cell value. Give me an example of your
formula. Do you have manual calculation turned on in EXCEL?

There are several templates on the web site:

http://ogres-crypt.com/SMF/Templates/#smfPricesByDates()

I don't know what you mean by "page 34" of the documentation. There are no
"pages" to the documentation.

I have NO idea what you mean by "Ticker is hard coded ... outside the
range". If you're using a reference to a cell, it's not hard-coded. If
something referred to was inside the range, you'd get a circular reference
error.

On Sun, Nov 27, 2016 at 5:15 AM, rjemery@
​...wrote:

>
> Array Entered smfPricesByDates
>
> If one uses the function smfPricesByDates in an array entered formula, the
> Ticker is also hard coded, is it not, even if the ticker is outside the
> range? Changing the Ticker (in A2 according to the Examples on page 34 of
> the documentation) then has no effect on the array entered formula.
>
> In Excel (2007), is it possible to have the array formula independent of
> the cell holding the Ticker?
>
> After all, the array formula itself is little more than dates, and I would
> like to change the Ticker and have the array formula report updated data
> for the new Ticker with the same dates already established.
>

Sun Nov 27, 2016 7:33 am (PST) . Posted by:

rjemery7

Randy,


> If you refer to a cell containing the ticker symbol, the formula
> results should change if you change the cell value. Give me
> an example of your formula.


I have a simple XLSX file, 12KB in size, that I twice tried to upload without success. It demonstrates the issues I am having.


> Do you have manual calculation turned on in EXCEL?


Yes, and I use SHIFT+F9 to perform recalculations.


> I don't know what you mean by "page 34" of the documentation.
> There are no "pages" to the documentation.


The documentation set I have printed as reference clearly has page numbers in the bottom right corner. There are a total of 57 pages. It's your documentation. I didn't do anything to enhance it. The set is not dated, but the last date in the Change Log is "2007/01/20 Release 1.3h."


> I have NO idea what you mean by "Ticker is hard coded ... outside
> the range". If you're using a reference to a cell, it's not hard-coded.
> If something referred to was inside the range, you'd get a circular
> reference error.


Once the array formula was established in Row 4 of my test case, based on the Ticker in A4, changing A4 had no effect on any subsequent recalculation. The array formula was forever tied to the original Ticker in A4. I would call that "hard coded," or if you prefer, embedded. A4 is outside the cell range of the array formula.


FWIW, the version of SMF I am using is:
Stock Market Functions add-in, Version 2.1.2014.01.30 (K:\Documents\ExcelWork\SMF Add-In; ; 1)


Sun Nov 27, 2016 8:23 am (PST) . Posted by:

"Randy Harmelink" rharmelink

On Sun, Nov 27, 2016 at 8:33 AM, rjemery@
​...wrote:

>
>
> Randy,
>
> > If you refer to a cell containing the ticker symbol, the formula
> > results should change if you change the cell value. Give me
> > an example of your formula.
>
> I have a simple XLSX file, 12KB in size, that I twice tried to upload
> without success. It demonstrates the issues I am having.
>

​Save it as a normal XLS file. You can just attach it to an email.​

> > Do you have manual calculation turned on in EXCEL?
>
> Yes, and I use SHIFT+F9 to perform recalculations.
>

​Since that's a limited recalculation, there could be issues
​. I never use it myself. I always do full recalculation.​

>
> > I don't know what you mean by "page 34" of the documentation.
> > There are no "pages" to the documentation.
>
> The documentation set I have printed as reference clearly has page numbers
> in the bottom right corner. There are a total of 57 pages. It's your
> documentation. I didn't do anything to enhance it. The set is not dated,
> but the last date in the Change Log is "2007/01/20 Release 1.3h."
>

​That's not something I created. I only create an HTML document for each
function.​

​My goal is "paperless".​

> > I have NO idea what you mean by "Ticker is hard coded ... outside
> > the range". If you're using a reference to a cell, it's not hard-coded.
> > If something referred to was inside the range, you'd get a circular
> > reference error.
>
> Once the array formula was established in Row 4 of my test case, based on
> the Ticker in A4, changing A4 had no effect on any subsequent
> recalculation. The array formula was forever tied to the original Ticker
> in A4. I would call that "hard coded," or if you prefer, embedded. A4 is
> outside the cell range of the array formula.
>

​As far as I know, Shift+F9 should do the trick, but I can't be sure.

Try a full recalculation using the smfForceRecalculation function and see
if things update. That might tell you whether it's due to your method of
calculation.​

BTW, Shift+F9 will NOT refresh any web page retrievals, for web pages
you're extracting data from. It will just recalculate the formula with the
previously retrieved web page.

> FWIW, the version of SMF I am using is:
> Stock Market Functions add-in, Version 2.1.2014.01.30
> (K:\Documents\ExcelWork\SMF Add-In; ; 1)
>

​So old I have no idea what might be an issue. :)​

Sun Nov 27, 2016 10:59 am (PST) . Posted by:

rjemery7

Randy,

How do I send an e-mail to you attaching the XLS file?


I updated to the 2016-09-02 smf release and tried all F9 combinations including F9 alone. Results remain the same as previously reported.

Sun Nov 27, 2016 3:23 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Google is your friend. Search for "how do I attach a file in google mail".

Did you try either of the templates I pointed you to? Trying those would
indicate if your method of calculation is the problem.

On Sun, Nov 27, 2016 at 11:59 AM, rjemery@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> How do I send an e-mail to you attaching the XLS file?
>
> I updated to the 2016-09-02 smf release and tried all F9 combinations
> including F9 alone. Results remain the same as previously reported.
>

Sun Nov 27, 2016 4:18 am (PST) . Posted by:

rjemery7

Randy,

Perfectly understandable. Google I think takes innovation too far.

Mon Nov 28, 2016 12:18 am (PST) . Posted by:

bleushin19

Hi Randy,


Thank you for the marvelous work you've done. I have been learning a lot and I need to learn a lot more.


Been working out to get data on MSN (http://www.msn.com/en-us/money/stockdetails/analysis/fi-126.1.PANW) Growth section using the smfGetTagContent, however, I am stuck on this issue:


I have here a sample :


=smfGetTagContent("http://www.msn.com/en-us/money/stockdetails/analysis/fi-126.1.PANW,"p",1,"Sales (Revenue)","Q/Q (Last Year)")



result shows the correct output. "34.00"


Then comes the problem where I am stuck:


=smfGetTagContent("http://www.msn.com/en-us/money/stockdetails/analysis/fi-126.1.PANW,"p",1,"Net Income","Q/Q (Last Year)")



result shows the same output for the first sample "34.00" where it should have been "-"


It seems that it looks at the "Q/Q (Last Year)" to get the data. Would you be able to specify the tags so that it would show the correct result.


Thanks,


Mon Nov 28, 2016 12:39 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Your problem is that "Net Income" is not a good first search term. It is in
the source code of the web page several times before that table. So it
finds that first occurrence, then the first Q/Q after that, which is what
you found with the first function.

Try something like:

=smfGetTagContent("
http://www.msn.com/en-us/money/stockdetails/analysis/fi-126.1.PANW","p",1,">Growth
Rate (%)","Sales (Revenue)","Q/Q (Last Year)")

=smfGetTagContent("
http://www.msn.com/en-us/money/stockdetails/analysis/fi-126.1.PANW","p",1,">Growth
Rate (%)","Net Income","Q/Q (Last Year)")

The first search term of ">Growth Rate (%)" positions you at the top of the
table before looking for the next search term.

On Mon, Nov 28, 2016 at 1:17 AM, bleushin19@
​...wrote:

>
>
> Hi Randy,
>
>
> Thank you for the marvelous work you've done. I have been learning a lot
> and I need to learn a lot more.
>
>
> Been working out to get data on MSN (http://www.msn.com/en-us/
> money/stockdetails/analysis/fi-126.1.PANW) Growth section using the
> smfGetTagContent, however, I am stuck on this issue:
>
>
> I have here a sample :
>
>
> =smfGetTagContent("http://www.msn.com/en-us/money/
> stockdetails/analysis/fi-126.1.PANW,"p",1,"Sales (Revenue)","Q/Q (Last
> Year)")
>
>
> result shows the correct output. "34.00"
>
>
> Then comes the problem where I am stuck:
>
>
> =smfGetTagContent("http://www.msn.com/en-us/money/
> stockdetails/analysis/fi-126.1.PANW,"p",1,"Net Income","Q/Q (Last Year)")
>
>
> result shows the same output for the first sample "34.00" where it should
> have been "-"
>
>
> It seems that it looks at the "Q/Q (Last Year)" to get the data. Would
> you be able to specify the tags so that it would show the correct result.
>
>

Mon Nov 28, 2016 12:58 am (PST) . Posted by:

bleushin19

Yes, Thanks.

I tried adding Growth but is seems I was missing something, and that is Growth Rate.


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

Tidak ada komentar:

Posting Komentar