Sabtu, 28 Maret 2015

[smf_addin] Digest Number 3370

2 Messages

Digest #3370

Messages

Fri Mar 27, 2015 7:31 pm (PDT) . Posted by:

mhho092

Hi,

I have been using a SMF-add-in-powered spreadsheet to get 10-year financials from gurufocus for US stocks.

I've just started the free trial with gurufocus premium membership because I'd like to get 10-year financials for certain London and Toronto listed stocks.

How do I get Excel to send the proper session cookie so that gurufocus knows my Excel session represents a premium membership?

I've got IE 10 running as well and I'm logged into gurufocus with the premium account there.

I have an odd-ball setup - Windows 8, Excel 2002, IE 10. So maybe Excel 2002 is using an older version of IE dll.

Have any of you got your spreadsheet to pull financials from gurufocus' premium area such as foreign stocks? I wouldn't mind buying a newer version of Excel, so that all I have to do is to login on IE. Just want to make sure it actually works.

Thanks,
Marshall


============== fiddler output - note the cookie is not set properly ==================

HTTP/1.1 200 OK
Date: Sat, 28 Mar 2015 02:13:48 GMT
Content-Type: text/html; charset=utf-8
Connection: keep-alive
X-Powered-By: PHP/5.4.39
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0
Pragma: no-cache
Set-Cookie: PRF_1=TSX%3AMTY%2CAZO%2CORCL%2CMSFT%2CIBM%2CMMM%2CLSE%3ASSPG%2CKO%2CTSE%3ADOL%2CTSX%3ADOL; expires=Sun, 27-Mar-2016 02:13:48 GMT; path=/
Set-Cookie: phorum_tmp_cookie=this+will+be+destroyed+once+logged+in; path=/
Server: cloudflare-nginx
CF-RAY: 1cdfd15ec2cc0528-YYZ
Content-Length: 121416

Fri Mar 27, 2015 10:14 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

If logging in to IE doesn't create the necessary cookie, try logging in
with the EXCEL Web Query Dialog (keyboard shortcut alt+d+d+w). In rare
situations, not exactly sure why, EXCEL appears to use an IE object that is
a different version than the browser, so the security cookie needs to be
created by the IE object instead of the browser.

With your old version of EXCEL, it may also have an old version of the IE
object? Hard to say...

On Fri, Mar 27, 2015 at 7:31 PM, mhho092@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I have been using a SMF-add-in-powered spreadsheet to get 10-year
> financials from gurufocus for US stocks.
>
> I've just started the free trial with gurufocus premium membership because
> I'd like to get 10-year financials for certain London and Toronto listed
> stocks.
>
> How do I get Excel to send the proper session cookie so that gurufocus
> knows my Excel session represents a premium membership?
>
> I've got IE 10 running as well and I'm logged into gurufocus with the
> premium account there.
>
> I have an odd-ball setup - Windows 8, Excel 2002, IE 10. So maybe Excel
> 2002 is using an older version of IE dll.
>
> Have any of you got your spreadsheet to pull financials from gurufocus'
> premium area such as foreign stocks? I wouldn't mind buying a newer
> version of Excel, so that all I have to do is to login on IE. Just want to
> make sure it actually works.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar