Selasa, 05 Agustus 2014

[smf_addin] Digest Number 3140

9 Messages

Digest #3140
1b
Re: QuoteMedia Historical Data by "Randy Harmelink" rharmelink
2a
QuandL by g3m1n1980
2b
Re: QuandL by "Randy Harmelink" rharmelink
2c
Re: QuandL by "J@Y" g3m1n1980
3b
Re: Morningstar elements 889, 889, get "Error" by "Randy Harmelink" rharmelink
3d
Re: Morningstar elements 889, 889, get "Error" by "Randy Harmelink" rharmelink

Messages

Mon Aug 4, 2014 5:46 am (PDT) . Posted by:

szazdrew

Hi Randy!

Is there any possibility to extract historical prices from the QuoteMedia?
It seems to be dinamically generated by the script:
http://www.quotemedia.com/finance/quote/?qm_page=48513&qm_symbol=AAPL http://www.quotemedia.com/finance/quote/?qm_page=48513&qm_symbol=AAPL
May be You can give me an advice where to find raw data with latest QM history?

I have found TMXMoney website which based on QM Data. But can only extract data with SMF add-in from the main stock quote page: http://web.tmxmoney.com/quote.php?qm_symbol=AAPL:US http://web.tmxmoney.com/quote.php?qm_symbol=AAPL:US

All attempts to extract data from other menu items like Price History (http://web.tmxmoney.com/pricehistory.php?qm_symbol=AAPL:US) were ended with Errors.
Do You any thoughts why it is not worked?

Regards,
Stanley Z.

Mon Aug 4, 2014 9:43 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sorry, but I don't see a way to get at the historical data...it's not in
the source code of the web page.

On Mon, Aug 4, 2014 at 5:46 AM, szazdrew@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Is there any possibility to extract historical prices from the QuoteMedia?
> It seems to be dinamically generated by the script:
> http://www.quotemedia.com/finance/quote/?qm_page=48513&qm_symbol=AAPL
>
> May be You can give me an advice where to find raw data with latest QM
> history?
>
> I have found TMXMoney website which based on QM Data. But can only extract
> data with SMF add-in from the main stock quote page:
> http://web.tmxmoney.com/quote.php?qm_symbol=AAPL:US
>
> All attempts to extract data from other menu items like Price History (
> http://web.tmxmoney.com/pricehistory.php?qm_symbol=AAPL:US) were ended
> with Errors.
> Do You any thoughts why it is not worked?
>

Mon Aug 4, 2014 8:55 am (PDT) . Posted by:

g3m1n1980

Randy,

Can you help me get this function to work?


=RCHGetTableCell("http://www.quandl.com/c/stocks/="&G1&"",1,">Value",,,,-1,"</table",,"--")



I have the ticker in cell G1


Im trying to pull the data from the below site (table)


http://www.quandl.com/c/stocks/plug http://www.quandl.com/c/stocks/plug



Mon Aug 4, 2014 9:29 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Your formula below is incorrect, as it has an "=" in the URL. Try:

=RCHGetTableCell("http://www.quandl.com/c/stocks/
"&LOWER(G1),1,">Value",,,,1,"</table",,"--")

I added the LOWER() function on the ticker symbol, because the URL for the
site appears to be case sensitive and doesn't work with an upper case
ticker symbol.

On Mon, Aug 4, 2014 at 8:55 AM, xxjaysonxx@aol.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Can you help me get this function to work?
>
> =RCHGetTableCell("http://www.quandl.com/c/stocks/=
> "&G1&"",1,">Value",,,,-1,"</table",,"--")
>
> I have the ticker in cell G1
>
> Im trying to pull the data from the below site (table)
>
> http://www.quandl.com/c/stocks/plug
>

Mon Aug 4, 2014 9:56 am (PDT) . Posted by:

"J@Y" g3m1n1980

Thanks Randy - it worked well

Jason

-----Original Message-----
From: Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Mon, Aug 4, 2014 12:29 pm
Subject: Re: [smf_addin] QuandL

Your formula below is incorrect, as it has an "=" in the URL. Try:

=RCHGetTableCell("http://www.quandl.com/c/stocks/"&LOWER(G1),1,">Value",,,,1,"</table",,"--")

I added the LOWER() function on the ticker symbol, because the URL for the site appears to be case sensitive and doesn't work with an upper case ticker symbol.

On Mon, Aug 4, 2014 at 8:55 AM, xxjaysonxx@aol.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Can you help me get this function to work?

=RCHGetTableCell("http://www.quandl.com/c/stocks/="&G1&"",1,">Value",,,,-1,"</table",,"--")

I have the ticker in cell G1

Im trying to pull the data from the below site (table)

http://www.quandl.com/c/stocks/plug

Mon Aug 4, 2014 6:02 pm (PDT) . Posted by:

"Jose Jacob" pepecan47

Hi Randy, elements 889, Fair Value Uncertainty and element 890, Economic Moat are giving me "Error".

They used to work before. Did anything change?

Thx a lot.

Regards,
Jose L. Jacob

Mon Aug 4, 2014 6:21 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I just tried them both with ticker symbol MMM and they worked fine for me.

Did you log into MorningStar with either IE or the EXCEL Web Query dialog
(alt+d+d+w)? You do need an active IE security cookie to access those data
items.

After logging in, you may need to run the smfForceRecalculation macro to
have the add-in get fresh copies of the web page, post-login.

On Mon, Aug 4, 2014 at 6:02 PM, Jose Jacob pepecan47@... wrote:

> Hi Randy, elements 889, Fair Value Uncertainty and element 890, Economic
> Moat are giving me "Error".
>
> They used to work before. Did anything change?
>

Mon Aug 4, 2014 7:05 pm (PDT) . Posted by:

"Jose Jacob" pepecan47

Randy, yes, I am logged in to Morningstar, I have a premium membership.

This is a spreadsheet that I have been using for several months, no problems.

The only thing that is different is that now I have a new computer with Windows 8.1 and Excel 2013.

I tested other spreadsheets that use the SMF and everything is fine so far, except this one.

Do you think I am missing an Internet setting for the M* security cookies?

Regards,
Jose L. Jacob

--------------------------------------------
On Mon, 8/4/14, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] Morningstar elements 889, 889, get "Error"
To: smf_addin@yahoogroups.com
Received: Monday, August 4, 2014, 9:21 PM


 









I just tried them both
with ticker symbol MMM and they worked fine for me.

Did you log into
MorningStar with either IE or the EXCEL Web Query dialog
(alt+d+d+w)? You do need an active IE security cookie to
access those data items.


After logging in, you may need to run
the smfForceRecalculation macro to have the add-in get fresh
copies of the web page, post-login.

On Mon, Aug 4, 2014 at 6:02
PM, Jose Jacob pepecan47@...
wrote:

Hi Randy, elements 889,
Fair Value Uncertainty and element 890, Economic Moat are
giving me "Error".



They used to work before. Did anything change?












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

#yiv2754187897 #yiv2754187897ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv2754187897 #yiv2754187897ygrp-mkp #yiv2754187897hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv2754187897 #yiv2754187897ygrp-mkp #yiv2754187897ads {
margin-bottom:10px;}

#yiv2754187897 #yiv2754187897ygrp-mkp .yiv2754187897ad {
padding:0 0;}

#yiv2754187897 #yiv2754187897ygrp-mkp .yiv2754187897ad p {
margin:0;}

#yiv2754187897 #yiv2754187897ygrp-mkp .yiv2754187897ad a {
color:#0000ff;text-decoration:none;}
#yiv2754187897 #yiv2754187897ygrp-sponsor
#yiv2754187897ygrp-lc {
font-family:Arial;}

#yiv2754187897 #yiv2754187897ygrp-sponsor
#yiv2754187897ygrp-lc #yiv2754187897hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv2754187897 #yiv2754187897ygrp-sponsor
#yiv2754187897ygrp-lc .yiv2754187897ad {
margin-bottom:10px;padding:0 0;}

#yiv2754187897 #yiv2754187897actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv2754187897 #yiv2754187897activity span {
font-weight:700;}

#yiv2754187897 #yiv2754187897activity span:first-child {
text-transform:uppercase;}

#yiv2754187897 #yiv2754187897activity span a {
color:#5085b6;text-decoration:none;}

#yiv2754187897 #yiv2754187897activity span span {
color:#ff7900;}

#yiv2754187897 #yiv2754187897activity span
.yiv2754187897underline {
text-decoration:underline;}

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

#yiv2754187897 .yiv2754187897attach div a {
text-decoration:none;}

#yiv2754187897 .yiv2754187897attach img {
border:none;padding-right:5px;}

#yiv2754187897 .yiv2754187897attach label {
display:block;margin-bottom:5px;}

#yiv2754187897 .yiv2754187897attach label a {
text-decoration:none;}

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

#yiv2754187897 .yiv2754187897bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv2754187897 .yiv2754187897bold a {
text-decoration:none;}

#yiv2754187897 dd.yiv2754187897last p a {
font-family:Verdana;font-weight:700;}

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

#yiv2754187897 dd.yiv2754187897last p
span.yiv2754187897yshortcuts {
margin-right:0;}

#yiv2754187897 div.yiv2754187897attach-table div div a {
text-decoration:none;}

#yiv2754187897 div.yiv2754187897attach-table {
width:400px;}

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

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

#yiv2754187897 div#yiv2754187897ygrp-mlmsg
#yiv2754187897ygrp-msg p a span.yiv2754187897yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv2754187897 .yiv2754187897green {
color:#628c2a;}

#yiv2754187897 .yiv2754187897MsoNormal {
margin:0 0 0 0;}

#yiv2754187897 o {
font-size:0;}

#yiv2754187897 #yiv2754187897photos div {
float:left;width:72px;}

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

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

#yiv2754187897 #yiv2754187897reco-category {
font-size:77%;}

#yiv2754187897 #yiv2754187897reco-desc {
font-size:77%;}

#yiv2754187897 .yiv2754187897replbq {
margin:4px;}

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

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

#yiv2754187897 #yiv2754187897ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv2754187897 #yiv2754187897ygrp-mlmsg pre, #yiv2754187897
code {
font:115% monospace;}

#yiv2754187897 #yiv2754187897ygrp-mlmsg * {
line-height:1.22em;}

#yiv2754187897 #yiv2754187897ygrp-mlmsg #yiv2754187897logo {
padding-bottom:10px;}


#yiv2754187897 #yiv2754187897ygrp-msg p a {
font-family:Verdana;}

#yiv2754187897 #yiv2754187897ygrp-msg
p#yiv2754187897attach-count span {
color:#1E66AE;font-weight:700;}

#yiv2754187897 #yiv2754187897ygrp-reco
#yiv2754187897reco-head {
color:#ff7900;font-weight:700;}

#yiv2754187897 #yiv2754187897ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv2754187897 #yiv2754187897ygrp-sponsor #yiv2754187897ov
li a {
font-size:130%;text-decoration:none;}

#yiv2754187897 #yiv2754187897ygrp-sponsor #yiv2754187897ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv2754187897 #yiv2754187897ygrp-sponsor #yiv2754187897ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv2754187897 #yiv2754187897ygrp-text {
font-family:Georgia;}

#yiv2754187897 #yiv2754187897ygrp-text p {
margin:0 0 1em 0;}

#yiv2754187897 #yiv2754187897ygrp-text tt {
font-size:120%;}

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


Mon Aug 4, 2014 9:05 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Keep in mind that logging in with a browser other than IE doesn't do
anything for EXCEL or the add-in...just in case that is the issue.

The easiest way to check if you have the IE security cookie is to go into
the EXCEL Web Query dialog, keyboard shortcut alt+d+d+w, and then navigate
to morningstar.com. When I do that, I see "Welcome, Randy!" right next to
the M* logo in the upper left-hand corner. So I know I have the IE security
cookie. If I don't have the IE security cookie, all it says is "Welcome!".

On Mon, Aug 4, 2014 at 7:05 PM, Jose Jacob pepecan47@... wrote:

> Randy, yes, I am logged in to Morningstar, I have a premium membership.
>
> This is a spreadsheet that I have been using for several months, no
> problems.
>
> The only thing that is different is that now I have a new computer with
> Windows 8.1 and Excel 2013.
>
> I tested other spreadsheets that use the SMF and everything is fine so
> far, except this one.
>
> Do you think I am missing an Internet setting for the M* security cookies?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 01.19

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)