Minggu, 15 Maret 2015

[smf_addin] Digest Number 3357[1 Attachment]

15 Messages

Digest #3357
2a
Guru question by "Jim Ranum" amt2100
2b
Re: Guru question by "Randy Harmelink" rharmelink
2c
Re: Guru question by "Jim Ranum" amt2100
2d
Re: Guru question by "Jim Ranum" amt2100
2e
Re: Guru question by "Randy Harmelink" rharmelink
2f
Re: Guru question by "Randy Harmelink" rharmelink
2g
Re: Guru question by "Jim Ranum" amt2100
2h
Macros by "J@Y" g3m1n1980
2i
Re: Guru question by "Jim Ranum" amt2100
2j
Re: Macros by "Randy Harmelink" rharmelink
2k
Re: Guru question by "Randy Harmelink" rharmelink
2l
Re: Guru question by "Jim Ranum" amt2100
2m
Re: Guru question by "Randy Harmelink" rharmelink
2n
Re: Guru question [1 Attachment] by "Jim Ranum" amt2100

Messages

Sun Mar 15, 2015 5:25 am (PDT) . Posted by:

marco.deen

As Yahoo does not have a message board for ^GSPC I'm not sure where to direct this question, but possibly someone here has an answer:


If I pull ^GSPC volume using smfgetyahooquotes(^GSPC,"v") I get a value of 553.445.667 for 3/13
If I use rchgetyahoohistory the value for the same day is 3.498.560.000


Obviously this is because Yahoo provides these values, but does anyone have a clue as to why these are different?



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

"Jim Ranum" amt2100

Hi Randy,

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)

Thank you,

Jim

Best regards,

Jim

Sun Mar 15, 2015 9:24 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

For me, the easiest thing is to use the HTML bold tags (i.e. <b>...</b>):

=smfConvertData(smfGetTagContent("http://www.gurufocus.com/analysis/NAS:DORM","b",1,"/Intrinsic
Value"))
=smfConvertData(smfGetTagContent("http://www.gurufocus.com/analysis/NAS:DORM","b",1,">Margin
of Safety"))

On Sun, Mar 15, 2015 at 8:57 AM, 'Jim Ranum' amt2100@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

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

Sun Mar 15, 2015 10:00 am (PDT) . Posted by:

"Jim Ranum" amt2100

Thanks Randy.

I get 2 strange answers with these instructions.

The first one returns:

Normalized Discounted Cash Flow and Book Value of the company

(underlined)

The second one returns:

5.016

(underlined)

Weird.

Best regards,

Jim

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Sunday, March 15, 2015 12:19 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Guru question

For me, the easiest thing is to use the HTML bold tags (i.e. <b>...</b>):

=smfConvertData(smfGetTagContent("http://www.gurufocus.com/analysis/NAS:DORM","b",1,"/Intrinsic Value"))
=smfConvertData(smfGetTagContent("http://www.gurufocus.com/analysis/NAS:DORM","b",1,">Margin of Safety"))

On Sun, Mar 15, 2015 at 8:57 AM, 'Jim Ranum' amt2100@gmail.com <mailto:amt2100@gmail.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:

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)

Sun Mar 15, 2015 10:03 am (PDT) . Posted by:

"Jim Ranum" amt2100

Since these terms occur numerous times on the page, can we use the term "Calculation" to start the search? That's the location on the page.

Thanks.

Best regards,

Jim

From: Jim Ranum [mailto:amt2100@gmail.com]
Sent: Sunday, March 15, 2015 1:00 PM
To: 'smf_addin@yahoogroups.com'
Subject: RE: [smf_addin] Guru question

Thanks Randy.

I get 2 strange answers with these instructions.

The first one returns:

Normalized Discounted Cash Flow and Book Value of the company

(underlined)

The second one returns:

5.016

(underlined)

Weird.

Best regards,

Jim

From: smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> [mailto:smf_addin@yahoogroups.com]
Sent: Sunday, March 15, 2015 12:19 PM
To: smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com>
Subject: Re: [smf_addin] Guru question

For me, the easiest thing is to use the HTML bold tags (i.e. <b>...</b>):

=smfConvertData(smfGetTagContent("http://www.gurufocus.com/analysis/NAS:DORM","b",1,"/Intrinsic Value"))
=smfConvertData(smfGetTagContent("http://www.gurufocus.com/analysis/NAS:DORM","b",1,">Margin of Safety"))

On Sun, Mar 15, 2015 at 8:57 AM, 'Jim Ranum' amt2100@gmail.com <mailto:amt2100@gmail.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:

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)

Sun Mar 15, 2015 10:28 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Using:

=smfConvertData(smfGetTagContent("http://www.gurufocus.com/analysis/NAS:DORM","b",1,"/Intrinsic
Value"))
=smfConvertData(smfGetTagContent("http://www.gurufocus.com/analysis/NAS:DORM","b",1,">Margin
of Safety"))

....I get 70.6 and 0.3475.

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

On Sun, Mar 15, 2015 at 10:00 AM, 'Jim Ranum' amt2100@gmail.com [smf_addin]
<smf_addin@yahoogroups.com> wrote:

>
>
>
> I get 2 strange answers with these instructions.
>
> The first one returns:
>
> *Normalized Discounted Cash Flow and Book Value of the company*
>
> (underlined)
>
> The second one returns:
>
> *5.016*
>
> (underlined)
>
>
>
> Weird.
>
>
>

Sun Mar 15, 2015 10:29 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

It doesn't hurt to add that search term. I get the same results with it or
without it:

=smfConvertData(smfGetTagContent("http://www.gurufocus.com/analysis/NAS:DORM","b",1,"Calculation:","/Intrinsic
Value"))
=smfConvertData(smfGetTagContent("http://www.gurufocus.com/analysis/NAS:DORM","b",1,"Calculation:",">Margin
of Safety"))

On Sun, Mar 15, 2015 at 10:03 AM, 'Jim Ranum' amt2100@gmail.com [smf_addin]
<smf_addin@yahoogroups.com> wrote:

>
> Since these terms occur numerous times on the page, can we use the term
> "Calculation" to start the search? That's the location on the page.
>
>
>

Sun Mar 15, 2015 11:12 am (PDT) . Posted by:

"Jim Ranum" amt2100

I copy and pasted the exact thing in your email to a clean cell with no formatting. I get the same results for this instruction with Calculation or the first one.

Why would I get something so different?

<http://www.gurufocus.com/analysis/NAS:DORM> normalized Discounted Cash Flow and Book Value of the company



<http://www.gurufocus.com/analysis/NAS:DORM> 5.016




Best regards,

Jim

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Sunday, March 15, 2015 1:30 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Guru question

It doesn't hurt to add that search term. I get the same results with it or without it:

=smfConvertData(smfGetTagContent("http://www.gurufocus.com/analysis/NAS:DORM","b",1,"Calculation:","/Intrinsic Value"))
=smfConvertData(smfGetTagContent("http://www.gurufocus.com/analysis/NAS:DORM","b",1,"Calculation:",">Margin of Safety"))

On Sun, Mar 15, 2015 at 10:03 AM, 'Jim Ranum' amt2100@gmail.com <mailto:amt2100@gmail.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:

Since these terms occur numerous times on the page, can we use the term "Calculation" to start the search? That's the location on the page.

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

"J@Y" g3m1n1980



Randy,

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.

Thanks

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

"Jim Ranum" amt2100

Hi Randy,

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)

Best regards,

Jim

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Sunday, March 15, 2015 1:30 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Guru question

It doesn't hurt to add that search term. I get the same results with it or without it:

=smfConvertData(smfGetTagContent("http://www.gurufocus.com/analysis/NAS:DORM","b",1,"Calculation:","/Intrinsic Value"))
=smfConvertData(smfGetTagContent("http://www.gurufocus.com/analysis/NAS:DORM","b",1,"Calculation:",">Margin of Safety"))

On Sun, Mar 15, 2015 at 10:03 AM, 'Jim Ranum' amt2100@gmail.com <mailto:amt2100@gmail.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:

Since these terms occur numerous times on the page, can we use the term "Calculation" to start the search? That's the location on the page.

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

"Randy Harmelink" rharmelink

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.

On Sun, Mar 15, 2015 at 1:35 PM, 'J@Y' xxjaysonxx@aol.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

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

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

"Randy Harmelink" rharmelink

I wonder if it has to do with how you paste it?

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)
>
>
>
Attachment(s) from Randy Harmelink
1 of 1 File(s)

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

"Jim Ranum" amt2100

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:

Best regards,

Jim

From: Jim Ranum [mailto:amt2100@gmail.com]
Sent: Sunday, March 15, 2015 4:39 PM
To: 'smf_addin@yahoogroups.com'
Subject: RE: [smf_addin] Guru question

Hi Randy,

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)

Best regards,

Jim

From: smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> [mailto:smf_addin@yahoogroups.com]
Sent: Sunday, March 15, 2015 1:30 PM
To: smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com>
Subject: Re: [smf_addin] Guru question

It doesn't hurt to add that search term. I get the same results with it or without it:

=smfConvertData(smfGetTagContent("http://www.gurufocus.com/analysis/NAS:DORM","b",1,"Calculation:","/Intrinsic Value"))
=smfConvertData(smfGetTagContent("http://www.gurufocus.com/analysis/NAS:DORM","b",1,"Calculation:",">Margin of Safety"))

On Sun, Mar 15, 2015 at 10:03 AM, 'Jim Ranum' amt2100@gmail.com <mailto:amt2100@gmail.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:

Since these terms occur numerous times on the page, can we use the term "Calculation" to start the search? That's the location on the page.

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

"Randy Harmelink" rharmelink

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

Sun Mar 15, 2015 3:10 pm (PDT) . Posted by:

"Jim Ranum" amt2100

Well you were right about the pasting issue. In your spreadsheet they are not underlined hyperlinks.

Unfortunately, they are still the same results I had previously, with the latest smf add-in files.

The only other think I can think of that would make our situations different is, I have a "Pro" membership to Guru, do you?

Best regards,

Jim

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Sunday, March 15, 2015 5:25 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Guru question [1 Attachment]

[Attachment(s) from Randy Harmelink included below]

I wonder if it has to do with how you paste it?

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 <mailto: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)

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 15.10

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)