Selasa, 18 November 2014

[smf_addin] Digest Number 3241

13 Messages

Digest #3241
2a
Re: MSN data by mikeinpax
2b
Re: MSN data by "Randy Harmelink" rharmelink
3a
^gdaxi by ullikloeffel
3b
Re: ^gdaxi by "Randy Harmelink" rharmelink
4a
Get Web data function by indinvestor111
4b
Re: Get Web data function by "Randy Harmelink" rharmelink
4c
Re: Get Web data function by indinvestor111
5a
5b
Re: implied volatility by "Randy Harmelink" rharmelink

Messages

Sun Nov 16, 2014 8:23 am (PST) . Posted by:

"Jose Jacob" pepecan47

Hi Randy - this template is giving me all errors when using MCD as a ticker (or any US stock).

I am in Canada, if I enter IPL.TO, it works.

When accessing Yahoo via IE to get the Key statistics, the page for MCD is

https://ca.finance.yahoo.com/q?s=mcd&ql=1

Do you thing this "ca" prefix is causing problems?

Regards,
Jose L. Jacob

Sun Nov 16, 2014 10:32 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I just tried both MCD and IPL.TO here and both worked fine. Your issues
probably do have something to do with the redirection that is going on.

Have you applied the "cross domain" fix for AdvFN? I think that has fixed a
few redirections in the past. Might work. Might not.

On Sun, Nov 16, 2014 at 9:16 AM, Jose Jacob pepecan47@... wrote:

> Hi Randy - this template is giving me all errors when using MCD as a
> ticker (or any US stock).
>
> I am in Canada, if I enter IPL.TO, it works.
>
> When accessing Yahoo via IE to get the Key statistics, the page for MCD is
>
> https://ca.finance.yahoo.com/q?s=mcd&ql=1
>
> Do you thing this "ca" prefix is causing problems?
>

Sun Nov 16, 2014 10:55 am (PST) . Posted by:

"Jose Jacob" pepecan47

Hi Randy - are you referring to this fix?

"What you can do is create a file in the same folder as add-in, called "smf-AdvFN-Prefix.txt", All the file should contain is the two letters "uk". You can create the file with Notepad. This file overrides the add-in default, and the add-in will then use the "uk" version of the URL instead of the default "www" version of the URL.

You'll need the 2.1.2012.12.29 version of the add-in for this to work..."

I have this file for AdvFN, but I don't know how it can help for this Yahoo issue.


Regards,
Jose L. Jacob

--------------------------------------------
On Sun, 11/16/14, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] SMF-Template-Yahoo-Key-Statistics spreadsheet errors
To: smf_addin@yahoogroups.com
Received: Sunday, November 16, 2014, 1:32 PM


 









I just tried both MCD and
IPL.TO here and both worked fine.
Your issues probably do have something to do with the
redirection that is going on.

Have you applied the "cross
domain" fix for AdvFN? I think that has fixed a few
redirections in the past. Might work. Might not.

On Sun,
Nov 16, 2014 at 9:16 AM, Jose Jacob pepecan47@... wrote:
Hi Randy - this template is giving me all errors
when using MCD as a ticker (or any US stock).



 I am in Canada, if I enter IPL.TO, it
works.



When accessing Yahoo via IE to get the Key statistics, the
page for MCD is



https://ca.finance.yahoo.com/q?s=mcd&ql=1



Do you thing this "ca" prefix is causing
problems?












#yiv6817487673 #yiv6817487673 --
#yiv6817487673ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv6817487673 #yiv6817487673ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv6817487673 #yiv6817487673ygrp-mkp #yiv6817487673hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv6817487673 #yiv6817487673ygrp-mkp #yiv6817487673ads {
margin-bottom:10px;}

#yiv6817487673 #yiv6817487673ygrp-mkp .yiv6817487673ad {
padding:0 0;}

#yiv6817487673 #yiv6817487673ygrp-mkp .yiv6817487673ad p {
margin:0;}

#yiv6817487673 #yiv6817487673ygrp-mkp .yiv6817487673ad a {
color:#0000ff;text-decoration:none;}
#yiv6817487673 #yiv6817487673ygrp-sponsor
#yiv6817487673ygrp-lc {
font-family:Arial;}

#yiv6817487673 #yiv6817487673ygrp-sponsor
#yiv6817487673ygrp-lc #yiv6817487673hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv6817487673 #yiv6817487673ygrp-sponsor
#yiv6817487673ygrp-lc .yiv6817487673ad {
margin-bottom:10px;padding:0 0;}

#yiv6817487673 #yiv6817487673actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv6817487673 #yiv6817487673activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv6817487673 #yiv6817487673activity span {
font-weight:700;}

#yiv6817487673 #yiv6817487673activity span:first-child {
text-transform:uppercase;}

#yiv6817487673 #yiv6817487673activity span a {
color:#5085b6;text-decoration:none;}

#yiv6817487673 #yiv6817487673activity span span {
color:#ff7900;}

#yiv6817487673 #yiv6817487673activity span
.yiv6817487673underline {
text-decoration:underline;}

#yiv6817487673 .yiv6817487673attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv6817487673 .yiv6817487673attach div a {
text-decoration:none;}

#yiv6817487673 .yiv6817487673attach img {
border:none;padding-right:5px;}

#yiv6817487673 .yiv6817487673attach label {
display:block;margin-bottom:5px;}

#yiv6817487673 .yiv6817487673attach label a {
text-decoration:none;}

#yiv6817487673 blockquote {
margin:0 0 0 4px;}

#yiv6817487673 .yiv6817487673bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv6817487673 .yiv6817487673bold a {
text-decoration:none;}

#yiv6817487673 dd.yiv6817487673last p a {
font-family:Verdana;font-weight:700;}

#yiv6817487673 dd.yiv6817487673last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv6817487673 dd.yiv6817487673last p
span.yiv6817487673yshortcuts {
margin-right:0;}

#yiv6817487673 div.yiv6817487673attach-table div div a {
text-decoration:none;}

#yiv6817487673 div.yiv6817487673attach-table {
width:400px;}

#yiv6817487673 div.yiv6817487673file-title a, #yiv6817487673
div.yiv6817487673file-title a:active, #yiv6817487673
div.yiv6817487673file-title a:hover, #yiv6817487673
div.yiv6817487673file-title a:visited {
text-decoration:none;}

#yiv6817487673 div.yiv6817487673photo-title a,
#yiv6817487673 div.yiv6817487673photo-title a:active,
#yiv6817487673 div.yiv6817487673photo-title a:hover,
#yiv6817487673 div.yiv6817487673photo-title a:visited {
text-decoration:none;}

#yiv6817487673 div#yiv6817487673ygrp-mlmsg
#yiv6817487673ygrp-msg p a span.yiv6817487673yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv6817487673 .yiv6817487673green {
color:#628c2a;}

#yiv6817487673 .yiv6817487673MsoNormal {
margin:0 0 0 0;}

#yiv6817487673 o {
font-size:0;}

#yiv6817487673 #yiv6817487673photos div {
float:left;width:72px;}

#yiv6817487673 #yiv6817487673photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv6817487673 #yiv6817487673photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv6817487673 #yiv6817487673reco-category {
font-size:77%;}

#yiv6817487673 #yiv6817487673reco-desc {
font-size:77%;}

#yiv6817487673 .yiv6817487673replbq {
margin:4px;}

#yiv6817487673 #yiv6817487673ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv6817487673 #yiv6817487673ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv6817487673 #yiv6817487673ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv6817487673 #yiv6817487673ygrp-mlmsg select,
#yiv6817487673 input, #yiv6817487673 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv6817487673 #yiv6817487673ygrp-mlmsg pre, #yiv6817487673
code {
font:115% monospace;}

#yiv6817487673 #yiv6817487673ygrp-mlmsg * {
line-height:1.22em;}

#yiv6817487673 #yiv6817487673ygrp-mlmsg #yiv6817487673logo {
padding-bottom:10px;}


#yiv6817487673 #yiv6817487673ygrp-msg p a {
font-family:Verdana;}

#yiv6817487673 #yiv6817487673ygrp-msg
p#yiv6817487673attach-count span {
color:#1E66AE;font-weight:700;}

#yiv6817487673 #yiv6817487673ygrp-reco
#yiv6817487673reco-head {
color:#ff7900;font-weight:700;}

#yiv6817487673 #yiv6817487673ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv6817487673 #yiv6817487673ygrp-sponsor #yiv6817487673ov
li a {
font-size:130%;text-decoration:none;}

#yiv6817487673 #yiv6817487673ygrp-sponsor #yiv6817487673ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv6817487673 #yiv6817487673ygrp-sponsor #yiv6817487673ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv6817487673 #yiv6817487673ygrp-text {
font-family:Georgia;}

#yiv6817487673 #yiv6817487673ygrp-text p {
margin:0 0 1em 0;}

#yiv6817487673 #yiv6817487673ygrp-text tt {
font-size:120%;}

#yiv6817487673 #yiv6817487673ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv6817487673


Sun Nov 16, 2014 1:55 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

No, I was referring to the other one:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/10464

On Sun, Nov 16, 2014 at 11:55 AM, Jose Jacob pepecan47@... wrote:

> Hi Randy - are you referring to this fix?
>
> "What you can do is create a file in the same folder as add-in, called
> "smf-AdvFN-Prefix.txt", All the file should contain is the two letters
> "uk". You can create the file with Notepad. This file overrides the add-in
> default, and the add-in will then use the "uk" version of the URL instead
> of the default "www" version of the URL.
>
> You'll need the 2.1.2012.12.29 version of the add-in for this to work..."
>
> I have this file for AdvFN, but I don't know how it can help for this
> Yahoo issue.
>
>
>

Sun Nov 16, 2014 6:06 pm (PST) . Posted by:

mikeinpax

Randy,

I have also been crippled by the MSN changes. I see how your example extracts the annual data, but how can I get quarterly data? Also, any plans to update the "RCHGetElementNumber" functions, or will the MSN data become obsolete?


Thanks for all your hard work,
Michael

Sun Nov 16, 2014 6:21 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

It looks like they've got the data on static web pages, loading them onto a
dynamic web page, similar to what MorningStar is now doing. For ticker
symbol MMM, these appear to be the six pages of financial statement data:

http://www.msn.com/en-us/money/stockdetails/financials/balance_sheet/Annual/fi-126.1.MMM.NYS
http://www.msn.com/en-us/money/stockdetails/financials/balance_sheet/Quarterly/fi-126.1.MMM.NYS

http://www.msn.com/en-us/money/stockdetails/financials/income_statement/Annual/fi-126.1.MMM.NYS
http://www.msn.com/en-us/money/stockdetails/financials/income_statement/Quarterly/fi-126.1.MMM.NYS

http://www.msn.com/en-us/money/stockdetails/financials/cash_flow/Annual/fi-126.1.MMM.NYS
http://www.msn.com/en-us/money/stockdetails/financials/cash_flow/Quarterly/fi-126.1.MMM.NYS

At this point, it's unlikely I will update any elements for MSN data, since
the URLs above need more than just the ticker symbol to access the data for
a particular company (i.e the "126.1" and "NYS" values). I know "NYS" is
the exchange, but I have no idea what the "126.1" is. Plus, that means
every data retrieval would need to get multiple web pages, just to create
the URL for the data. Might be possible, but not pretty.

On Sun, Nov 16, 2014 at 5:59 PM, mikeinpax@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I have also been crippled by the MSN changes. I see how your example
> extracts the annual data, but how can I get quarterly data? Also, any
> plans to update the "RCHGetElementNumber" functions, or will the MSN data
> become obsolete?
>
>

Mon Nov 17, 2014 11:20 am (PST) . Posted by:

ullikloeffel

Hello!

Before 07.10.2014 the RCH Stock Markets Function shows only the daily "Close" and not the "Open", the "Max" or the"Min" of the ^gdaxi.

That is for example not by "IBM" or others.

What is wrong. After the 07.10.2014 all is allright.

Thanks
Ulli Kloeffel


Mon Nov 17, 2014 11:25 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I'll need more details -- specific function and parameters? I can't
understand what function or items you're having issues with. Nothing
off-hand comes to mind with "Min" and "Max" items.

On Mon, Nov 17, 2014 at 11:51 AM, ukloeffel@... wrote:

>
> Before 07.10.2014 the RCH Stock Markets Function shows only the daily
> "Close" and not the "Open", the "Max" or the"Min" of the ^gdaxi.
>
> That is for example not by "IBM" or others.
>
> What is wrong. After the 07.10.2014 all is allright.
>

Mon Nov 17, 2014 4:54 pm (PST) . Posted by:

indinvestor111

Hi Randy,


I've been trying to scrape some retail price data from a few different retailer's websites using the RCH Get Web Data-Function, but am having trouble retrieving prices from Amazon.


Would you suggest I use this function for this, or is there a better way?


Thanks

Mon Nov 17, 2014 5:05 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I pull data from Amazon every day, from searches for free Kindle books.
What kinds of things have you tried?

For example, if I put the book's ASIN in a cell, this grabs the price of
the eBook:

=RCHGetTableCell("http://www.amazon.com/gp/product/"&C5,1,"Kindle Price:")

RCHGetWebData() is usually my function of last resort. First shot is
usually RCHGetTableCell() when things are in a table. When things aren't in
a table, I usually go to smfGetTagContent().

On Mon, Nov 17, 2014 at 5:54 PM, elandry@bmlcapital.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I've been trying to scrape some retail price data from a few different
> retailer's websites using the RCH Get Web Data-Function, but am having
> trouble retrieving prices from Amazon.
>
> Would you suggest I use this function for this, or is there a better way?
>
>

Mon Nov 17, 2014 5:15 pm (PST) . Posted by:

indinvestor111

Thanks for the reply,

I'm looking for prices of, for instance, this TV:


Sony XBR70X850B 70-Inch 4K Ultra HD 120Hz 3D Smart LED TV http://www.amazon.com/Sony-XBR70X850B-70-Inch-Ultra-120Hz/dp/B00J585ORC/ref=sr_1_1?ie=UTF8&qid=1416270856&sr=8-1&keywords=XBR70X850B




Haven't had much luck finding the actual number. I'll try get table cell.


Mon Nov 17, 2014 7:07 pm (PST) . Posted by:

mohandesai

Hi Randy- I am getting an error message for =smfGetOptionQuotes(B4,"6",,"OX2") where B4 is QQQ Mar 2015 $103 Call

Any suggestions?

Mon Nov 17, 2014 7:34 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

The monthly code of "Mar" won't work because as of February of 2015,
they're realigning monthly expirations to Fridays to match the weeklies. It
works fine on my version of the add-in, because I made a change to the
routine earlier this year, on 2014-09-15. But if you don't have that
update, you'll need to use a workaround and have something like this in
cell B4:

QQQ 3/20 2015 $103 Call

The updates are in limbo right now because I made changes for the new
format of Yahoo option pages, which Yahoo backed out a week later. I expect
them to go back to the new format because Chrome and FireFox *are* using
it. But it has me befuddled right now.

On Mon, Nov 17, 2014 at 8:07 PM, mohandesai@...wrote:

>
> Hi Randy- I am getting an error message
> for =smfGetOptionQuotes(B4,"6",,"OX2") where B4 is QQQ Mar 2015 $103 Call
>
> Any suggestions?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.43

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)