15 New Messages
Digest #2936
4a
I used to have a file to "read" a website different ways for diff fu by "Lal Echterhoff" bigzippy@bellsouth.net
4b
Re: I used to have a file to "read" a website different ways for dif by "Randy Harmelink" rharmelink
4c
Re: I used to have a file to "read" a website different ways for dif by "Lal Echterhoff" bigzippy@bellsouth.net
Messages
Tue Jan 21, 2014 5:06 am (PST) . Posted by:
sdavis81
Hi Randy,
One other quick question (I hope!)
In all of your examples, you arrayed this smfPricesbydates using a single reference cell for the ticker, like SPY for example.
What if you have a list of symbols (like my list of Fidelity Sector funds).
I arrayed one line of my list without trouble, for one ticker.
I have my funds list in cells A5 to A42. I have my time references in colums H-L (current, 1 mo, 3 mo, 6 mo, 12 mo).
I tried to array the following formula over the range of H5:L42, and got VALUE! errors.
=smfPricesByDates(
Do I need a different array formula for each ticker, or can the ticker symbol in syntax be arraryed also?
Thanks
Scott
Tue Jan 21, 2014 5:10 am (PST) . Posted by:
"Randy Harmelink" rharmelink
You need one function invocation per ticker symbol. There is no
array-entering it over multiple ticker symbols, just over multiple dates.
That's because there would be no advantage to using the function for
multiple ticker symbols. The add-in would still have to go to the Internet
once for each ticker symbol.
On Tue, Jan 21, 2014 at 6:06 AM, <sdavis81@yahoo.com> wrote:
> One other quick question (I hope!)
>
> In all of your examples, you arrayed this smfPricesbydates using a single
> reference cell for the ticker, like SPY for example.
>
> What if you have a list of symbols (like my list of Fidelity Sector funds).
>
> I arrayed one line of my list without trouble, for one ticker.
>
> II tried to array the following formula over the range of H5:L42, and got
> VALUE! errors.
>
> =smfPricesByDates(A5:A42,$H$4:$L$4)
>
> Do I need a different array formula for each ticker, or can the ticker
> symbol in syntax be arraryed also?
>
>
array-entering it over multiple ticker symbols, just over multiple dates.
That's because there would be no advantage to using the function for
multiple ticker symbols. The add-in would still have to go to the Internet
once for each ticker symbol.
On Tue, Jan 21, 2014 at 6:06 AM, <sdavis81@yahoo.
> One other quick question (I hope!)
>
> In all of your examples, you arrayed this smfPricesbydates using a single
> reference cell for the ticker, like SPY for example.
>
> What if you have a list of symbols (like my list of Fidelity Sector funds).
>
> I arrayed one line of my list without trouble, for one ticker.
>
> II tried to array the following formula over the range of H5:L42, and got
> VALUE! errors.
>
> =smfPricesByDates(
>
> Do I need a different array formula for each ticker, or can the ticker
> symbol in syntax be arraryed also?
>
>
Tue Jan 21, 2014 5:14 am (PST) . Posted by:
dwstelsel
That works. Thanks.
---In smf_addin@yahoogrou
Try NYSE:DOW as the ticker.
Tue Jan 21, 2014 1:31 pm (PST) . Posted by:
"Marco Deen" marco.deen
Well, it looks like getting option strike prices from Yahoo is finished as
well. Randy, I assume you are referring to *2.2 A step-by-step example of
using some of the new option functions *
On Wed, Jan 15, 2014 at 6:25 PM, Randy Harmelink <rharmelink@gmail.com>wrote:
>
>
> It's not possible to array-enter that one. In any case, it's actually
> retrieving the data with an RCHGetTableCell() function.
>
> BTW, I would advise against using ITMx and OTMx with Yahoo. It's
> unreliable whenever they have multiple expiration dates displayed in the
> same month. You're better off using the smfGetOptionStrikes() function to
> determine ITM and OTM strike prices.
>
> Check out the option quotes example in the LINKS area of the group.
>
> On Wed, Jan 15, 2014 at 3:13 PM, Marco Deen <marco.deen@gmail.com> wrote:
>
>>
>> Although functions like =smfGETYAHOOOPTIONQUOTE(A2,"P",$A$1,"ITM1","s")
>> do not seem to be affected (yet), is it possible (and advisable) to enter
>> these in an array? And if so how would one do that?
>>
>>
>
>
well. Randy, I assume you are referring to *2.2 A step-by-step example of
using some of the new option functions *
On Wed, Jan 15, 2014 at 6:25 PM, Randy Harmelink <rharmelink@gmail.
>
>
> It's not possible to array-enter that one. In any case, it's actually
> retrieving the data with an RCHGetTableCell(
>
> BTW, I would advise against using ITMx and OTMx with Yahoo. It's
> unreliable whenever they have multiple expiration dates displayed in the
> same month. You're better off using the smfGetOptionStrikes
> determine ITM and OTM strike prices.
>
> Check out the option quotes example in the LINKS area of the group.
>
> On Wed, Jan 15, 2014 at 3:13 PM, Marco Deen <marco.deen@gmail.
>
>>
>> Although functions like =smfGETYAHOOOPTIONQ
>> do not seem to be affected (yet), is it possible (and advisable) to enter
>> these in an array? And if so how would one do that?
>>
>>
>
>
Tue Jan 21, 2014 1:42 pm (PST) . Posted by:
"Marco Deen" marco.deen
Oops, CTRL + ENTERED.
Randy, what I'm trying to do is get the first ITM strike prices for some 10
to 80 securities. Once I have that I copy it into my broker's API
and request bid, ask and greeks there.
Up until last week =smfGETYAHOOOPTIONQUOTE(A2,"P",$A$1,"ITM1","s") worked
but now most of my cells return empty. ($A$1 is the cell where I specify my
expiration date)
Do you have suggestions for another source I could use?
On Tue, Jan 21, 2014 at 4:31 PM, Marco Deen <marco.deen@gmail.com> wrote:
> Well, it looks like getting option strike prices from Yahoo is finished as
> well. Randy, I assume you are referring to *2.2 A step-by-step example of
> using some of the new option functions *
>
>
> On Wed, Jan 15, 2014 at 6:25 PM, Randy Harmelink <rharmelink@gmail.com>wrote:
>
>>
>>
>> It's not possible to array-enter that one. In any case, it's actually
>> retrieving the data with an RCHGetTableCell() function.
>>
>> BTW, I would advise against using ITMx and OTMx with Yahoo. It's
>> unreliable whenever they have multiple expiration dates displayed in the
>> same month. You're better off using the smfGetOptionStrikes() function to
>> determine ITM and OTM strike prices.
>>
>> Check out the option quotes example in the LINKS area of the group.
>>
>> On Wed, Jan 15, 2014 at 3:13 PM, Marco Deen <marco.deen@gmail.com> wrote:
>>
>>>
>>> Although functions like =smfGETYAHOOOPTIONQUOTE(A2,"P",$A$1,"ITM1","s")
>>> do not seem to be affected (yet), is it possible (and advisable) to enter
>>> these in an array? And if so how would one do that?
>>>
>>>
>>
>>
>
>
Randy, what I'm trying to do is get the first ITM strike prices for some 10
to 80 securities. Once I have that I copy it into my broker's API
and request bid, ask and greeks there.
Up until last week =smfGETYAHOOOPTIONQ
but now most of my cells return empty. ($A$1 is the cell where I specify my
expiration date)
Do you have suggestions for another source I could use?
On Tue, Jan 21, 2014 at 4:31 PM, Marco Deen <marco.deen@gmail.
> Well, it looks like getting option strike prices from Yahoo is finished as
> well. Randy, I assume you are referring to *2.2 A step-by-step example of
> using some of the new option functions *
>
>
> On Wed, Jan 15, 2014 at 6:25 PM, Randy Harmelink <rharmelink@gmail.
>
>>
>>
>> It's not possible to array-enter that one. In any case, it's actually
>> retrieving the data with an RCHGetTableCell(
>>
>> BTW, I would advise against using ITMx and OTMx with Yahoo. It's
>> unreliable whenever they have multiple expiration dates displayed in the
>> same month. You're better off using the smfGetOptionStrikes
>> determine ITM and OTM strike prices.
>>
>> Check out the option quotes example in the LINKS area of the group.
>>
>> On Wed, Jan 15, 2014 at 3:13 PM, Marco Deen <marco.deen@gmail.
>>
>>>
>>> Although functions like =smfGETYAHOOOPTIONQ
>>> do not seem to be affected (yet), is it possible (and advisable) to enter
>>> these in an array? And if so how would one do that?
>>>
>>>
>>
>>
>
>
Tue Jan 21, 2014 4:25 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I would get the first ITM strike price with something like (not
array-entered):
=smfGetOptionStrikes("IWM";,"2/22/2014",,"Y",,2,1)
...and the first OTM strike price with something like:
=INDEX(smfGetOptionStrikes("IWM","2/22/2014",,"Y",,2,1),2)
The "2,1" parameters tell the function to return a 2-row by 1-column array.
That means the first row will be the first ITM price and the 2nd row with
be the first OTM price (hence the need for the INDEX function).
Or, you could array-enter this over a 2-row by 1-column range and get both
of them at the same time:
=smfGetOptionStrikes("IWM";,"2/22/2014",,"Y")
I use OptionsXPress instead of Yahoo. They are a bit slower, but the
results are more reliable (because people are actually using their data for
trading options). Just change the "Y" parameters above to "OX" to get
OptionsXPress data.
On Tue, Jan 21, 2014 at 2:42 PM, Marco Deen <marco.deen@gmail.com> wrote:
>
> Randy, what I'm trying to do is get the first ITM strike prices for some
> 10 to 80 securities. Once I have that I copy it into my broker's API
> and request bid, ask and greeks there.
>
> Up until last week =smfGETYAHOOOPTIONQUOTE(A2,"P",$A$1,"ITM1","s") worked
> but now most of my cells return empty. ($A$1 is the cell where I specify my
> expiration date)
> Do you have suggestions for another source I could use?
>
>
array-entered)
=smfGetOptionStrike
...and the first OTM strike price with something like:
=INDEX(smfGetOption
The "2,1" parameters tell the function to return a 2-row by 1-column array.
That means the first row will be the first ITM price and the 2nd row with
be the first OTM price (hence the need for the INDEX function).
Or, you could array-enter this over a 2-row by 1-column range and get both
of them at the same time:
=smfGetOptionStrike
I use OptionsXPress instead of Yahoo. They are a bit slower, but the
results are more reliable (because people are actually using their data for
trading options). Just change the "Y" parameters above to "OX" to get
OptionsXPress data.
On Tue, Jan 21, 2014 at 2:42 PM, Marco Deen <marco.deen@gmail.
>
> Randy, what I'm trying to do is get the first ITM strike prices for some
> 10 to 80 securities. Once I have that I copy it into my broker's API
> and request bid, ask and greeks there.
>
> Up until last week =smfGETYAHOOOPTIONQ
> but now most of my cells return empty. ($A$1 is the cell where I specify my
> expiration date)
> Do you have suggestions for another source I could use?
>
>
Tue Jan 21, 2014 7:21 am (PST) . Posted by:
weekeewawa
hi,
i would like to extract the data from businessweek
namely in a table format from this
http://investing.businessweek.com/research/stocks/financials/financials.asp?ticker=IBM&dataset=incomeStatement&period=A¤cy=native
1) Year over year, International Business Machines Corporation has seen revenues remain relatively flat.... (the paragraph from this page)
2) the income statement for it.
thanks
i would like to extract the data from businessweek
namely in a table format from this
http://investing.
1) Year over year, International Business Machines Corporation has seen revenues remain relatively flat.... (the paragraph from this page)
2) the income statement for it.
thanks
Tue Jan 21, 2014 7:52 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The description can be retrieved with:
=smfGetTagContent("
http://investing.businessweek.com/research/stocks/financials/financials.asp?ticker=IBM&dataset=incomeStatement&period=A¤cy=native
","div",-1,"financialsSmartText")
However, it will contain HTML markup. I have nothing to automatically
remove those items from the text.
To grab the income statement:
=RCHGetHTMLTable("
http://investing.businessweek.com/research/stocks/financials/financials.asp?ticker=IBM&dataset=incomeStatement&period=A¤cy=native","As
of:",-1,"",1)
On Tue, Jan 21, 2014 at 8:21 AM, <weekeewawa@yahoo.com> wrote:
>
> i would like to extract the data from businessweek
>
> namely in a table format from this
>
>
> http://investing.businessweek.com/research/stocks/financials/financials.asp?ticker=IBM&dataset=incomeStatement&period=A¤cy=native
>
> 1) Year over year, International Business Machines Corporation has seen
> revenues remain relatively flat.... (the paragraph from this page)
>
> 2) the income statement for it.
>
>
=smfGetTagContent(
http://investing.
","
However, it will contain HTML markup. I have nothing to automatically
remove those items from the text.
To grab the income statement:
=RCHGetHTMLTable(
http://investing.
of:",-1,
On Tue, Jan 21, 2014 at 8:21 AM, <weekeewawa@yahoo.
>
> i would like to extract the data from businessweek
>
> namely in a table format from this
>
>
> http://investing.
>
> 1) Year over year, International Business Machines Corporation has seen
> revenues remain relatively flat.... (the paragraph from this page)
>
> 2) the income statement for it.
>
>
Tue Jan 21, 2014 9:16 am (PST) . Posted by:
"Lal Echterhoff" bigzippy@bellsouth.net
I used to have a file to "read" a website different ways for gettablecell and/or other functions can you please post a link?
It had multiple tabs for different functions etc to read or diagnose a site you were trying to get data from.
Thanks
It had multiple tabs for different functions etc to read or diagnose a site you were trying to get data from.
Thanks
Tue Jan 21, 2014 9:44 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I think you mean the smfGetTagContent-Quick-Webpage-Examination.xls
template?
From here:
https://groups.yahoo.com/neo/groups/smf_addin/files/Templates%20and%20Examples/smfGetTagContent/
On Tue, Jan 21, 2014 at 10:16 AM, Lal Echterhoff <bigzippy@bellsouth.net>wrote:
> I used to have a file to "read" a website different ways for gettablecell
> and/or other functions can you please post a link?
> It had multiple tabs for different functions etc to read or diagnose a
> site you were trying to get data from.
> Thanks
>
template?
From here:
https://groups.
On Tue, Jan 21, 2014 at 10:16 AM, Lal Echterhoff <bigzippy@bellsouth.
> I used to have a file to "read" a website different ways for gettablecell
> and/or other functions can you please post a link?
> It had multiple tabs for different functions etc to read or diagnose a
> site you were trying to get data from.
> Thanks
>
Tue Jan 21, 2014 10:33 am (PST) . Posted by:
"Lal Echterhoff" bigzippy@bellsouth.net
Yes that is the one! Thank You
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I think you mean the smfGetTagContent-Quick-Webpage-Examination.xls
> template?
>
> From here:
>
> https://groups.yahoo.com/neo/groups/smf_addin/files/Templates%20and%20Examples/smfGetTagContent/
>
> On Tue, Jan 21, 2014 at 10:16 AM, Lal Echterhoff <bigzippy@...>wrote:
>
> > I used to have a file to "read" a website different ways for gettablecell
> > and/or other functions can you please post a link?
> > It had multiple tabs for different functions etc to read or diagnose a
> > site you were trying to get data from.
> > Thanks
> >
>
--- In smf_addin@yahoogrou
>
> I think you mean the smfGetTagContent-
> template?
>
> From here:
>
> https://groups.
>
> On Tue, Jan 21, 2014 at 10:16 AM, Lal Echterhoff <bigzippy@
>
> > I used to have a file to "read" a website different ways for gettablecell
> > and/or other functions can you please post a link?
> > It had multiple tabs for different functions etc to read or diagnose a
> > site you were trying to get data from.
> > Thanks
> >
>
Tue Jan 21, 2014 12:47 pm (PST) . Posted by:
mjdaumer
I am trying to extract mutual fund data from Fidelity. The problem I have is that Fidelity translates ticker signals into fund identifiers.
For example:
URL: https://screener.fidelity.com/ftgw/etf/goto/snapshot/snapshot.jhtml?symbols=FAIRX
opens a page at
URL: https://fundresearch.fidelity.com/mutual-funds/summary/304871106
Using the SMF add-in, is there a method to capture the returned URL.
I believe I can then use smfStrExtr() to strip out and save the fund identifier "304871106" that appears at the end of the URL. f
Thanks
For example:
URL: https://screener.
opens a page at
URL: https://fundresearc
Using the SMF add-in, is there a method to capture the returned URL.
I believe I can then use smfStrExtr() to strip out and save the fund identifier "304871106&quo
Thanks
Tue Jan 21, 2014 1:07 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The redirection on that original URL gives XMLHTTP a headache and it errors
out.
However, you can grab that fund identifier from Fidelity's popup quote page
for the mutual fund:
=smfstrExtr(RCHGetWebData("
https://fastquote.fidelity.com/webxpress/popup_quote.phtml?SID_VALUE_ID=
"&C16,"mfl_frame.shtml?"),"?","&")
...where C16 contains the mutual fund ticker symbol. But it does mean two
web page retrievals for each ticker symbol.
On Tue, Jan 21, 2014 at 1:47 PM, <mjdaumer@yahoo.com> wrote:
>
> I am trying to extract mutual fund data from Fidelity. The problem I have
> is that Fidelity translates ticker signals into fund identifiers.
>
> For example:
> URL:
> https://screener.fidelity.com/ftgw/etf/goto/snapshot/snapshot.jhtml?symbols=FAIRX
>
> opens a page at
>
> URL: https://fundresearch.fidelity.com/mutual-funds/summary/304871106
>
> Using the SMF add-in, is there a method to capture the returned URL.
>
> I believe I can then use smfStrExtr() to strip out and save the fund
> identifier "304871106" that appears at the end of the URL. f
>
out.
However, you can grab that fund identifier from Fidelity'
for the mutual fund:
=smfstrExtr(
https://fastquote.
"&C16,"
...where C16 contains the mutual fund ticker symbol. But it does mean two
web page retrievals for each ticker symbol.
On Tue, Jan 21, 2014 at 1:47 PM, <mjdaumer@yahoo.
>
> I am trying to extract mutual fund data from Fidelity. The problem I have
> is that Fidelity translates ticker signals into fund identifiers.
>
> For example:
> URL:
> https://screener.
>
> opens a page at
>
> URL: https://fundresearc
>
> Using the SMF add-in, is there a method to capture the returned URL.
>
> I believe I can then use smfStrExtr() to strip out and save the fund
> identifier "304871106&quo
>
Tue Jan 21, 2014 2:01 pm (PST) . Posted by:
"rumplestilskin" stanfordpatrick@sbcglobal.net
I've managed to build a spreadsheet that uses the RCHgetyahooQuotes
function in an array and it works well, using the codes such as n for name, I1 which pulls in last trade, c for change, r for PE ratio, etc.
However, I noticed that the dividend per share d, and dividend yield y, are pulling in trailing figures and hence are not accurate.
Does anyone know if there are codes for RCHgetyahooquotes that pull in the current dividend and current yield (also referred to on the yahoo site as "forward"
If there are no codes for this, what function would be a good replacement for RCHgetyahooquotes to utilize in an array (which I built using Randy's small example)?
Any help will be greatly appreciated.
Tue Jan 21, 2014 2:17 pm (PST) . Posted by:
mikemcq802
The short answer is you can use this but it does not work in an array (where C6 is the ticker):
=RCHGetElementNumber(C6,4925)
The longer answer is that Yahoo's forward yield is the most recent dividend annualized. This will only be useful when dividend amounts are consistent.
Trailing yields are not inaccurate as you stated. In fact, they are more useful when comparing tickers that have dividend payments that vary (funds, foreign companies, especially).
=RCHGetElementNumbe
The longer answer is that Yahoo's forward yield is the most recent dividend annualized. This will only be useful when dividend amounts are consistent.
Trailing yields are not inaccurate as you stated. In fact, they are more useful when comparing tickers that have dividend payments that vary (funds, foreign companies, especially).
Tidak ada komentar:
Posting Komentar