2a

Sun Mar 15, 2015 8:57 am (PDT) . Posted by:

Trying another way to get this info on Intrinsic Value (DE) and/or Margin of Safety(DE).

From the source page:

What are all these "td" for? It says "/table" in there. Is it more efficient to pull a table out? How would you write the instruction to grab either the 70.60 amount or the 34.75% amount, with all those td's in there?

> > > Trying another way to get this info on Intrinsic Value (DE) and/or Margin > of Safety(DE). > > > > From the source page: > > > > What are all these "td" for? It says "/table" in there. Is it more > efficient to pull a table out? How would you write the instruction to grab > either the 70.60 amount or the 34.75% amount, with all those td's in there? > > http://www.gurufocus.com/analysis/NAS:DORM > > (line 1452) > > > >

Trying another way to get this info on Intrinsic Value (DE) and/or Margin of Safety(DE).

From the source page:

What are all these "td" for? It says "/table" in there. Is it more efficient to pull a table out? How would you write the instruction to grab either the 70.60 amount or the 34.75% amount, with all those td's in there?

Trying another way to get this info on Intrinsic Value (DE) and/or Margin of Safety(DE).

From the source page:

What are all these "td" for? It says "/table" in there. Is it more efficient to pull a table out? How would you write the instruction to grab either the 70.60 amount or the 34.75% amount, with all those td's in there?

A formula can only return a value to a cell. If you have something underlined, it has to be a format you applied to the cell. Inadvertently, maybe? I can't explain why you get different results. Did you do a copy and paste? I don't even see a "5.016" string on the web page...

2h

Sun Mar 15, 2015 1:35 pm (PDT) . Posted by:

I created a macro button to calcuate the SMF. Was wondering if you had any ideas on how to stop the SMF in the middle of a download.

On some occasions it auto populates on the file open (using pre set tickers) and the only work around I know of is to save the file with no tickers. So a stop SMF button or a procedure to not auto run on the open is of interest.

Let me know if you have an ideas. Some of my files take 5 mins to load so it can get frustrating.

2j

Sun Mar 15, 2015 2:16 pm (PDT) . Posted by:

I've seen claims that the ESC key or Ctrl+Break will stop VBA processing, but I've not had them work when I've wanted something to stop.

A possible solution is to use the smfUpdateDownloadTable process. It loads values into your workbook instead of formulas that calculate. Then, you can be in control of what gets updated and when. But it may not fit your needs.

Another option is to set up a calculation trigger, so that the only formulas that calculate are those you trigger. For example, something like:

=IF($A$1<>"Y","--",RCHGetElementNumber(....))

...so that the add-in function will only be calculated if cell A1 has "Y" in it. But you need to save the file when the trigger cell has something other than "Y" in it, so that when you open the file, no calculations will be done. I use this technique quite a bit.

> > I created a macro button to calcuate the SMF. Was wondering if you had > any ideas on how to stop the SMF in the middle of a download. > > On some occasions it auto populates on the file open (using pre set > tickers) and the only work around I know of is to save the file with no > tickers. So a stop SMF button or a procedure to not auto run on the open > is of interest. > > Let me know if you have an ideas. Some of my files take 5 mins to load > so it can get frustrating. > >

2k

Sun Mar 15, 2015 2:24 pm (PDT) . Posted by:

For this type of thing, I ALWAYS do a "Paste Special", as text (alt+e+s+t, ENTER). If you just do a Ctrl+V to paste it, you paste it as HTML data. If I paste it that way, I do get the hyperlinks, but they are with the values I expect to see, not the two things you cite.

I've attached a copy of the workbook I'm using. Do you still see your same values when you open it?

If so, try smfForceRecalculation, just in case.

On Sun, Mar 15, 2015 at 1:39 PM, 'Jim Ranum' amt2100@...wrote:

> > > Tried these exact instructions on 2 different computers, one is Win 7 and > the other Win 8, both Office 2013, and same strange results. > > I have not updated the SMF file in a year. Would this be causing this > problem? When it was described what the update was for, I didn't think I > needed it. (Don't use those websites) > > >

2m

Sun Mar 15, 2015 2:57 pm (PDT) . Posted by:

Ahhh. The problem is you're not logged into IE, to create the IE security cookie so the add-in can access the Intrinsic value calculations. The results you get below are what I get if I log out of my premium membership.

On Sun, Mar 15, 2015 at 2:25 PM, 'Jim Ranum' amt2100@...wrote:

> > Well, I just updated the SMF files, got the latest version showing, but I > still am getting the same responses with the instructions given below: > > > > > > >

For this type of thing, I ALWAYS do a "Paste Special", as text (alt+e+s+t, ENTER). If you just do a Ctrl+V to paste it, you paste it as HTML data. If I paste it that way, I do get the hyperlinks, but they are with the values I expect to see, not the two things you cite.

I've attached a copy of the workbook I'm using. Do you still see your same values when you open it?