Kamis, 23 Februari 2017

[smf_addin] Digest Number 3927

6 Messages

Digest #3927

Messages

Wed Feb 22, 2017 7:00 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

​I can't imagine what the issue might be, so let's try a few formulas and
see what you get:

=RCHGetElementNumber("Version")​

Open a fresh copy of the smfGetOptionQuotes-Template-CC-Roll.xls and enter
"MMM" as your ticker symbol (cell H3). Enter these formulas in the
indicated cells, and let me know what you get back for each:

O8: =rOptTicker
P8: =rBid
Q8:=$H8
R8: =smfGetOptionQuotes($H8,"b",,LEFT($H5,1))

---------- Forwarded message ----------
From: conlonrc@comcast.net [justcoveredcalls] <
justcoveredcalls@yahoogroups.com>
Date: Wed, Feb 22, 2017 at 6:18 PM
Subject: [justcoveredcalls] Re: New file uploaded to justcoveredcalls
To: justcoveredcalls@yahoogroups.com

Randy, I have the latest add-in (Version 2.1.2017.02.15), but the
spreadsheet only gets the Price, the ExDiv, the Earn, and the list of
Option Symbols. It does not get the Bid Price, Extrinsic, Profit, aROI,
Dividends, EarnRpt. All I get in those cells is #NAME?

Any help will be appreciated.

Wed Feb 22, 2017 11:05 pm (PST) . Posted by:

bobc94595

Got the following in those four cells:

MMM 2/24 2017 $175.00 Call #NAME? MMM 2/24 2017 $175.00 Call

10.6






Thu Feb 23, 2017 12:54 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Hmmm. For some reason, the named range "rBid" isn't working on your
machine. I downloaded the file from the Yahoo group and it's working fine
for me.

If you are looking at cell P8, what is the definition of "rBid" for you
(keyboard shortcut alt+i+n+d? Mine is:

=smfGetOptionQuotes(rOptTicker,"b",,LEFT(rSource,1))

Maybe try getting a new copy of the workbook from the group?

On Thu, Feb 23, 2017 at 12:05 AM, conlonrc@
​...wrote:

>
> Got the following in those four cells:
>
> MMM 2/24 2017 $175.00 Call #NAME? MMM 2/24 2017 $175.00 Call
>
> 10.6
>
>

Thu Feb 23, 2017 7:27 am (PST) . Posted by:

aadkruit@ymail.com

Hi Randy,

First and above all, I wish you healthiness. I appreciate and admire your unselfish sharing of your works with us and the patience and devotion you show (more than 10 year) to all of your members.

With smfGetTagContent-Quick-Web-Examination I've tried to find out whether grabbing data is possible from this url:

"http://en.boerse-frankfurt.de/equities/equities-analyser#IndexID=2108198&view=financial" (english version for your convenience).

This smfGet tool works fine with the url for Yahoo Key Statistics but no data other than 'error&#39; are generated when applied to the above url.

When examining the codepage of 'boerse........&#39;(with key F12 in IE or FF) no tablecontent, mentioned in key figures, can be retrieved.
In 'Conversations&#39; I read your comments that, when webpage content is created dynamically it is not within the sourcecode and this will frustrate grabbing data. And elsewhere, if frame and/or Json code is within, this might be helpful to restore operation. For these I'm not sure about their significance regarding this matter.

My question is:
Will grabbing data from this site be possible with one of the SMF Add in tools. And if so, could you be helpful to deploy this.
Your answer and help will be greatly appreciated.

Aad



Thu Feb 23, 2017 8:40 am (PST) . Posted by:

"Randy Harmelink" rharmelink

That web page is indeed generated dynamically. Using my HttpFox add-on with
FireFox, I can see which URLs are invoked when a page is being built. It
says the search results are generated with this URL:

http://en.boerse-frankfurt.de/search/advancedsharesearchresults?IndexID=2108198&view=financial&p=1&count=100

Data can be extracted from that URL.

In general, the add-in doesn't work with the positional directive in a URL
(i.e. the "#" character).

On Thu, Feb 23, 2017 at 8:27 AM, ajk@
​...wrote:

>
> With smfGetTagContent-Quick-Web-Examination I've tried to find out
> whether grabbing data is possible from this url:
>
> "http://en.boerse-frankfurt.de/equities/equities-analyser#
> IndexID=2108198&view=financial"; (english version for your
> convenience).
>
> This smfGet tool works fine with the url for Yahoo Key Statistics but no
> data other than 'error&#39; are generated when applied to the above url.
>
> When examining the codepage of 'boerse........&#39;(with key F12 in IE or FF)
> no tablecontent, mentioned in key figures, can be retrieved.
> In 'Conversations&#39; I read your comments that, when webpage content is
> created dynamically it is not within the sourcecode and this will frustrate
> grabbing data. And elsewhere, if frame and/or Json code is within, this
> might be helpful to restore operation. For these I'm not sure about their
> significance regarding this matter.
>
> My question is:
> Will grabbing data from this site be possible with one of the SMF Add in
> tools. And if so, could you be helpful to deploy this.
> Your answer and help will be greatly appreciated.
>

Thu Feb 23, 2017 2:26 pm (PST) . Posted by:

aadkruit@ymail.com

Hi Randy,

Thank you for your quick reply.
This opens new opportunities and I intend to use this Add-on.
Although, due to Firefox version I think, this seems a problem up till now.

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

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)