Jumat, 17 April 2015

[smf_addin] Digest Number 3383

6 Messages

Digest #3383

Messages

Thu Apr 16, 2015 2:05 pm (PDT) . Posted by:

"Fred Wright" fredwwright

Is anyone else having a problem with getting the Morningstar Star rating (I subscribe).  
What worked up through yesterday was: 
=0+smfstrExtr(RCHGetWebData("http://quotes.morningstar.com/stock/s?t="&A3,"r_star"),"r_star","'")
Where A3 holds the ticker symbol.
Any advice?
Fred 

Thu Apr 16, 2015 2:44 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The URL you are using in your formula no longer exists, so they must have
phased it out. Try this instead (no subscription needed?):

=smfConvertData(smfStrExtr(RCHGetWebData("
http://financials.morningstar.com/company-profile/c.action?t=
"&A3,"r_star"),"r_star","'"))

On Thu, Apr 16, 2015 at 2:00 PM, Fred Wright fredwwright@...wrote:

>
> Is anyone else having a problem with getting the Morningstar Star rating
> (I subscribe).
>
> What worked up through yesterday was:
>
> =0+smfstrExtr(RCHGetWebData("http://quotes.morningstar.com/stock/s?t=
> "&A3,"r_star"),"r_star","'")
>
> Where A3 holds the ticker symbol.
>
> Any advice?
>
>
>

Thu Apr 16, 2015 4:09 pm (PDT) . Posted by:

baileywongpowers

I'm looking for an Excel Workbook that doesn't require installing the add-in into Excel. The only function that I'm looking for is the ability to download historical pricing from Yahoo. Thanks!

Thu Apr 16, 2015 4:18 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try out:

smfGetYahooHistory-Template.xls

in the "Templates and Examples > SMFLite" folder of the FILES area of the
Yahoo group. It may not be up-to-date with the current add-in documentation
and functioning, since easy updating is the very purpose of using the
add-in.

Another option:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/24212

On Thu, Apr 16, 2015 at 4:02 PM, baileywongpowers@... wrote:

> I'm looking for an Excel Workbook that doesn't require installing the
> add-in into Excel. The only function that I'm looking for is the ability to
> download historical pricing from Yahoo. Thanks!
>

Thu Apr 16, 2015 10:04 pm (PDT) . Posted by:

"Pete A" option2z

All,
I'm trying to back fill in the price of the underlying stock when I sell a
covered call. I've got the ticker, date and time of the option sell, but
can't seem to find a way to lookup the underlying price.
Example:

4/16/2015
11:50:49 AM
MAT
Price?
May not be able to do this on the web, but maybe someone knows where/how?

Thanks!

Pete A
<http://www.ttp-s.com/> TtP-S Investing

Thu Apr 16, 2015 10:55 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You can try barchart.com. It goes down to charts by minutes. For example:

http://www.barchart.com/chart.php?sym=MAT&style=technical&template=&p=I&d=L&im=1&sd=&ed=&size=M&log=0&t=BAR&v=1&g=1&evnt=1&late=1&o1=&o2=&o3=&sh=100&indicators=&addindicator=&submitted=1&fpage=&txtDate=

The data within the source code of the web page looks something like:

<area shape="rect" coords="431,242,431,258"
onmousemove="showOHLCTooltip(event, 'A', '[Thu. Apr 16, 2015 11:51:00]',
'MAT', '25.0800000', '25.1500000', '25.0800000', '25.1450000')">
<area shape="rect" coords="430,258,430,263"
onmousemove="showOHLCTooltip(event, 'A', '[Thu. Apr 16, 2015 11:50:00]',
'MAT', '25.0700000', '25.0800000', '25.0600000', '25.0800000')">
<area shape="rect" coords="429,259,429,264"
onmousemove="showOHLCTooltip(event, 'A', '[Thu. Apr 16, 2015 11:49:00]',
'MAT', '25.0700000', '25.0700000', '25.0600000', '25.0700000')">
<area shape="rect" coords="428,259,428,264"
onmousemove="showOHLCTooltip(event, 'A', '[Thu. Apr 16, 2015 11:48:00]',
'MAT', '25.0700000', '25.0700000', '25.0639000', '25.0700000')">
<area shape="rect" coords="428,260,428,265"
onmousemove="showOHLCTooltip(event, 'A', '[Thu. Apr 16, 2015 11:47:00]',
'MAT', '25.0600000', '25.0700000', '25.0548000', '25.0700000')">

If I use the RCHGetWebData-Template-BarChart-Quotes-Extract.xls template
and add the new 1-minute intervals as an extraction option, I end up with
this type of extraction:

*Date* *Open* *High* *Low* *Close* Thu. Apr 16, 2015 11:52:00 $25.15
$25.15 $25.14 $25.15 Thu. Apr 16, 2015 11:51:00 $25.08 $25.15 $25.08
$25.15 Thu.
Apr 16, 2015 11:50:00 $25.07 $25.08 $25.06 $25.08 Thu. Apr 16, 2015
11:49:00 $25.07 $25.07 $25.06 $25.07 Thu. Apr 16, 2015 11:48:00 $25.07
$25.07 $25.06 $25.07 Thu. Apr 16, 2015 11:47:00 $25.06 $25.07 $25.05
$25.07 Thu.
Apr 16, 2015 11:46:00 $25.06 $25.06 $25.05 $25.06

A straight extraction for high and low during that minute might be:

=smfConvertData(smfWord(RCHGetWebData("
http://www.barchart.com/chart.php?sym=MAT&style=technical&template=&p=I&d=L&im=1&sd=04%2F16%2F2015&ed=04%2F16%2F2015&size=M&log=0&t=BAR&v=1&g=1&evnt=1&late=1&o1=&o2=&o3=&sh=100&indicators=&addindicator=&submitted=1&fpage=&txtDate=","Thu.
Apr 16, 2015 11:50",100),4,"', '"))

=smfConvertData(smfWord(RCHGetWebData("
http://www.barchart.com/chart.php?sym=MAT&style=technical&template=&p=I&d=L&im=1&sd=04%2F16%2F2015&ed=04%2F16%2F2015&size=M&log=0&t=BAR&v=1&g=1&evnt=1&late=1&o1=&o2=&o3=&sh=100&indicators=&addindicator=&submitted=1&fpage=&txtDate=","Thu.
Apr 16, 2015 11:50",100),5,"', '"))

On Thu, Apr 16, 2015 at 10:04 PM, Pete A optionzz@outlook.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I'm trying to back fill in the price of the underlying stock when I sell
> a covered call. I've got the ticker, date and time of the option sell,
> but can't seem to find a way to lookup the underlying price.
>
> Example:
>
> 4/16/2015
>
> 11:50:49 AM
>
> MAT
>
> Price?
>
> May not be able to do this on the web, but maybe someone knows where/how?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.38

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)