10 Messages
Digest #3358
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:
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@
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:
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@
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.
>
>
>
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
smfForceRecalculati
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.
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 smfForceRecalculati
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?
>
>
>
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
=RCHGetTableCell("http://finance.yahoo.com/bonds/composite_bond_rates",1,"
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")
>
>
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,"
> Bonds",
>
>
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
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?
>
>
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?
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