Senin, 16 Maret 2015

[smf_addin] Digest Number 3358

10 Messages

Digest #3358
1a
Re: Guru question by "Jim Ranum" amt2100
1b
Re: Guru question by "Jim Ranum" amt2100
1c
Re: Guru question by "Randy Harmelink" rharmelink
1d
Re: Guru question by "Jim Ranum" amt2100
1e
Re: Guru question by "Randy Harmelink" rharmelink
2a
Corporate Bonds Yield by "Jose Jacob" pepecan47
2b
Re: Corporate Bonds Yield by "Randy Harmelink" rharmelink
3b
Re: Option data using smfGetOptionQuotes by "Randy Harmelink" rharmelink

Messages

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

"Jim Ranum" amt2100

I'm glad we're on a path to recovery here. A couple questions:

Do I have to use IE? I prefer Chrome.

Do I have to be logged in to Guru before I open the worksheet?

You have mentioned before about creating a security cookie or something to that effect in Excel before, unfortunately I didn't understand how to do it. So I'm sure this is the problem.

Best regards,

Jim

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

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 <mailto: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:15 pm (PDT) . Posted by:

"Jim Ranum" amt2100

Oh sorry, I still have the same result when I am logged in to Guru with IE.

Best regards,

Jim

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

I'm glad we're on a path to recovery here. A couple questions:

Do I have to use IE? I prefer Chrome.

Do I have to be logged in to Guru before I open the worksheet?

You have mentioned before about creating a security cookie or something to that effect in Excel before, unfortunately I didn't understand how to do it. So I'm sure this is the problem.

Best regards,

Jim

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

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 <mailto: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 4:39 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You don't have to use IE as your browser, but you do need to log in with
it. Because EXCEL and IE are both MicroSoft products, the Windows
communication libraries I'm using utilize the same Internet engine that
both of them use. So you do need to create the IE security cookie, by
logging in with IE.

EXCEL actually uses an IE object, so it may not match your installed IE
browser. If that's the case, you need to use the EXCEL Web Query dialog to
log in (alt+d+d+w). That's why I usually say it's the preferred method of
logging in.

And, be sure to either exit and restart EXCEL, or run the
smfForceRecalculation dialog after creating the security cookie, because
the add-in needs to get a new copy of the web page after the security
cookie is created.

Another potential issue is to make sure your Internet Options are set to
always get a fresh copy of a web page.

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

>
> I'm glad we're on a path to recovery here. A couple questions:
>
> Do I have to use IE? I prefer Chrome.
>
> Do I have to be logged in to Guru before I open the worksheet?
>
> You have mentioned before about creating a security cookie or something to
> that effect in Excel before, unfortunately I didn't understand how to do
> it. So I'm sure this is the problem.
>
>
>

Sun Mar 15, 2015 5:14 pm (PDT) . Posted by:

"Jim Ranum" amt2100

OK, this is about how far I got last time in this discussion when I had to abandon all hope.

I did the alt+d+d+w and log in to guru via the mini browser. Then what? I don't see anything to select to create cookie, or anything else.

And how would I know if Excel is using an incompatible IE object? (I'm guessing it is) And how would I match them up?

And why would I have had no problems with this prior to this issue today?

Would I need to do this alt+d+d+w thing every time I open Excel to use Guru from now on?

Sorry completely ignorant on this topic.

Best regards,

Jim

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

You don't have to use IE as your browser, but you do need to log in with it. Because EXCEL and IE are both MicroSoft products, the Windows communication libraries I'm using utilize the same Internet engine that both of them use. So you do need to create the IE security cookie, by logging in with IE.

EXCEL actually uses an IE object, so it may not match your installed IE browser. If that's the case, you need to use the EXCEL Web Query dialog to log in (alt+d+d+w). That's why I usually say it's the preferred method of logging in.

And, be sure to either exit and restart EXCEL, or run the smfForceRecalculation dialog after creating the security cookie, because the add-in needs to get a new copy of the web page after the security cookie is created.

Another potential issue is to make sure your Internet Options are set to always get a fresh copy of a web page.

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

I'm glad we're on a path to recovery here. A couple questions:

Do I have to use IE? I prefer Chrome.

Do I have to be logged in to Guru before I open the worksheet?

You have mentioned before about creating a security cookie or something to that effect in Excel before, unfortunately I didn't understand how to do it. So I'm sure this is the problem.

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

"Randy Harmelink" rharmelink

When you use alt+d+d+w to log in, THAT creates the cookie. Then you just
CANCEL out.

Sorry, but I don't know how to tell what version of IE EXCEL is using, or
what it wouldn't match what the browser is. But I do know that some people
that didn't have things work when logged in with IE as a browser did have
things work when logged in using the IE object. So I'm assuming that it's
because they were out of sync.

How often you would need to do it depends on the expiration period of the
security cookie. So far, I've not had to log in again when using GuruFocus.
But I've used other web sites where the cookie expires at the end of the
day.

Prior to today, were you accessing items that required a log in?

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

>
> OK, this is about how far I got last time in this discussion when I had to
> abandon all hope.
>
> I did the alt+d+d+w and log in to guru via the mini browser. Then what? I
> don't see anything to select to create cookie, or anything else.
>
> And how would I know if Excel is using an incompatible IE object? (I'm
> guessing it is) And how would I match them up?
>
>
>
> And why would I have had no problems with this prior to this issue today?
>
> Would I need to do this alt+d+d+w thing every time I open Excel to use
> Guru from now on?
>
>
>

Sun Mar 15, 2015 5:09 pm (PDT) . Posted by:

"Jose Jacob" pepecan47

Hi Randy - I am trying to get the 5Y AAA yield of corporate bonds. I get "FALSE".

=RCHGetTableCell("http://finance.yahoo.com/bonds/composite_bond_rates",1,">Corporate Bonds",">5yr AAA")

Regards,
Jose L. Jacob

Sun Mar 15, 2015 11:38 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Not sure what to tell you -- I just pasted that formula into EXCEL and got
back 1.83.

In the past, I've had people report TRUE or FALSE when they actually had
pasted two formulas into the cell, so the second "=" makes it a comparison
of the two formula values. But since you're giving me the formula, that
doesn't seem like it should apply...

On Sun, Mar 15, 2015 at 5:09 PM, Jose Jacob pepecan47@wrote:

> Hi Randy - I am trying to get the 5Y AAA yield of corporate bonds. I get
> "FALSE".
>
> =RCHGetTableCell("http://finance.yahoo.com/bonds/composite_bond_rates",1,">Corporate
> Bonds",">5yr AAA")
>
>

Sun Mar 15, 2015 9:03 pm (PDT) . Posted by:

"Pete Guy" yvrflyguy

Hi Randy,
Is it possible to get a date & time stamp with the options data, specifically data downloaded using OX or OX2 as the source?
Thanks,
Peter

Sun Mar 15, 2015 11:33 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

If you mean when they were last traded, no. I don't see that data on the
web pages that can be accessed from OptionsXPress without a log in.

On Sun, Mar 15, 2015 at 9:01 PM, Pete Guy a330pete@... wrote:

>
> Is it possible to get a date & time stamp with the options data,
> specifically data downloaded using OX or OX2 as the source?
>
>

Mon Mar 16, 2015 12:54 am (PDT) . Posted by:

"Pete Guy" yvrflyguy

No, not the last last trade time, just the date/time at which the bid/offer being extracted was a valid quote. I'm assuming the data coming back is a delayed quote.

To: smf_addin@yahoogroups.com
From: smf_addin@yahoogroups.com
Date: Sun, 15 Mar 2015 23:33:37 -0700
Subject: Re: [smf_addin] Option data using smfGetOptionQuotes

If you mean when they were last traded, no. I don't see that data on the web pages that can be accessed from OptionsXPress without a log in.

On Sun, Mar 15, 2015 at 9:01 PM, Pete Guy a330pete@... wrote:

Is it possible to get a date & time stamp with the options data, specifically data downloaded using OX or OX2 as the source?

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

Tidak ada komentar:

Posting Komentar