2a

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

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.

2b

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

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. >

2c

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

> 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:\Documents92;ExcelWork92;SMF Add-In; ; 1)

2d

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

> > > 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&quot;.​

> > 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.

> > 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. >

4b

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

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.

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. > >