Minggu, 14 Agustus 2016

[smf_addin] Digest Number 3771

7 Messages

Digest #3771
2a
Beta from Morningstar by "Jose Jacob" pepecan47
2b
Re: Beta from Morningstar by "Randy Harmelink" rharmelink
2c
Re: Beta from Morningstar by "Jose Jacob" pepecan47
3b
Re: RCHGetYahooHistory("INGA.AS") by "Randy Harmelink" rharmelink

Messages

Sat Aug 13, 2016 7:19 am (PDT) . Posted by:

sjagers

Hey Randy.... This question is a little off topic, but I was wondering if you knew if the following was possible:

1.) I have an Excel spreadsheet that I use to track stocks that hit a 52-week high, during each day's trading session.
2.) I populate the spreadsheet each night (copy & paste) with data from barchart.com: http://www.barchart.com/stocks/high.php?view=43198&_dtp1=0 http://www.barchart.com/stocks/high.php?view=43198&_dtp1=0
(I usually have to login to barchart.com to access my custom view of this web page.


I have to be away from my computer for a few days and I was wondering if there was a way to automate this process, so my computer could do it unattended? Microsoft Task Scheduler? VBA code? This is definitely over-my-head, but I thought I'd ask you if you knew whether it was possible or not.
Thanks. Steve

Sat Aug 13, 2016 12:51 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

It wouldn't be that hard to do with VBA. Take a look at this template on
the web site:

RCHGetYahooQuotes-Example-Timed-Update.xls

Just use the "Export" link with smfGetCSVFile() to place the data into a
new worksheet on each iteration. For example, something like this VBA code:

Call smfForceRecalculation
Sheets.Add Type:="Worksheet"
ActiveSheet.Range("B2").Resize(100, 50).Value = smfGetCSVFIle("
http://www.barchart.com/export.php?key=hig*&list=highslows&fields=symbol,name,last,change,pctchange,displaytime,open,high,low,volume,inf_52w_high_price,inf_52w_low_price&title=US+Exchanges+52+Week+Highs&extension=.csv",
pDim1:=100, pDim2:=50)

On Sat, Aug 13, 2016 at 7:19 AM, sjagers@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Hey Randy.... This question is a little off topic, but I was wondering if
> you knew if the following was possible:
>
> 1.) I have an Excel spreadsheet that I use to track stocks that hit a
> 52-week high, during each day's trading session.
> 2.) I populate the spreadsheet each night (copy & paste) with data from
> barchart.com: http://www.barchart.com/stocks/high.php?view=43198&_dtp1=0
> (I usually have to login to barchart.com to access my custom view of this
> web page.
>
> I have to be away from my computer for a few days and I was wondering if
> there was a way to automate this process, so my computer could do it
> unattended? Microsoft Task Scheduler? VBA code? This is definitely
> over-my-head, but I thought I'd ask you if you knew whether it was possible
> or not.
>
>

Sat Aug 13, 2016 2:35 pm (PDT) . Posted by:

"Jose Jacob" pepecan47

Hi Randy - is it possible to get the Beta for a stock from Morningstar?

I see it in the QUOTE page

Market Data MCD

Beta 0.66 
Below 52-Week High -9.43% 
50-Day Moving Average 121.34 
200-Day Moving Average 120.84 

Regards,
Jose L. Jacob

Sat Aug 13, 2016 3:32 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try:

=smfGetTagContent("http://quotes.morningstar.com/stockq/c-marketData?t=MCD
> ","td",1,">Beta",,,,1)
>

On Sat, Aug 13, 2016 at 2:35 PM, Jose Jacob pepecan47@
​...wrote:

> Hi Randy - is it possible to get the Beta for a stock from Morningstar?
>
> I see it in the QUOTE page
>
> Market Data MCD
>
> Beta 0.66
> Below 52-Week High -9.43%
> 50-Day Moving Average 121.34
> 200-Day Moving Average 120.84
>

Sat Aug 13, 2016 8:43 pm (PDT) . Posted by:

"Jose Jacob" pepecan47

Thank you Randy, works perfectly.

Regards,
Jose L. Jacob

--------------------------------------------
On Sat, 8/13/16, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] Beta from Morningstar
To: smf_addin@yahoogroups.com
Received: Saturday, August 13, 2016, 6:25 PM


 









Try:

=smfGetTagContent("http://quotes.morningstar.com/stockq/c-marketData?t=MCD","td",1,">Beta",,,,1)

On Sat, Aug 13, 2016 at
2:35 PM, Jose Jacob pepecan47@​...wrote:
Hi Randy - is it possible to get the Beta for a
stock from Morningstar?



I see it in the QUOTE page



Market Data MCD



Beta 0.66 

Below 52-Week High -9.43% 

50-Day Moving Average 121.34 

200-Day Moving Average 120.84












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

#yiv9372236111 #yiv9372236111ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv9372236111 #yiv9372236111ygrp-mkp #yiv9372236111hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv9372236111 #yiv9372236111ygrp-mkp #yiv9372236111ads {
margin-bottom:10px;}

#yiv9372236111 #yiv9372236111ygrp-mkp .yiv9372236111ad {
padding:0 0;}

#yiv9372236111 #yiv9372236111ygrp-mkp .yiv9372236111ad p {
margin:0;}

#yiv9372236111 #yiv9372236111ygrp-mkp .yiv9372236111ad a {
color:#0000ff;text-decoration:none;}
#yiv9372236111 #yiv9372236111ygrp-sponsor
#yiv9372236111ygrp-lc {
font-family:Arial;}

#yiv9372236111 #yiv9372236111ygrp-sponsor
#yiv9372236111ygrp-lc #yiv9372236111hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv9372236111 #yiv9372236111ygrp-sponsor
#yiv9372236111ygrp-lc .yiv9372236111ad {
margin-bottom:10px;padding:0 0;}

#yiv9372236111 #yiv9372236111actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv9372236111 #yiv9372236111activity span {
font-weight:700;}

#yiv9372236111 #yiv9372236111activity span:first-child {
text-transform:uppercase;}

#yiv9372236111 #yiv9372236111activity span a {
color:#5085b6;text-decoration:none;}

#yiv9372236111 #yiv9372236111activity span span {
color:#ff7900;}

#yiv9372236111 #yiv9372236111activity span
.yiv9372236111underline {
text-decoration:underline;}

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

#yiv9372236111 .yiv9372236111attach div a {
text-decoration:none;}

#yiv9372236111 .yiv9372236111attach img {
border:none;padding-right:5px;}

#yiv9372236111 .yiv9372236111attach label {
display:block;margin-bottom:5px;}

#yiv9372236111 .yiv9372236111attach label a {
text-decoration:none;}

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

#yiv9372236111 .yiv9372236111bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv9372236111 .yiv9372236111bold a {
text-decoration:none;}

#yiv9372236111 dd.yiv9372236111last p a {
font-family:Verdana;font-weight:700;}

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

#yiv9372236111 dd.yiv9372236111last p
span.yiv9372236111yshortcuts {
margin-right:0;}

#yiv9372236111 div.yiv9372236111attach-table div div a {
text-decoration:none;}

#yiv9372236111 div.yiv9372236111attach-table {
width:400px;}

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

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

#yiv9372236111 div#yiv9372236111ygrp-mlmsg
#yiv9372236111ygrp-msg p a span.yiv9372236111yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv9372236111 .yiv9372236111green {
color:#628c2a;}

#yiv9372236111 .yiv9372236111MsoNormal {
margin:0 0 0 0;}

#yiv9372236111 o {
font-size:0;}

#yiv9372236111 #yiv9372236111photos div {
float:left;width:72px;}

#yiv9372236111 #yiv9372236111photos div div {
border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}

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

#yiv9372236111 #yiv9372236111reco-category {
font-size:77%;}

#yiv9372236111 #yiv9372236111reco-desc {
font-size:77%;}

#yiv9372236111 .yiv9372236111replbq {
margin:4px;}

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

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

#yiv9372236111 #yiv9372236111ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv9372236111 #yiv9372236111ygrp-mlmsg pre, #yiv9372236111
code {
font:115% monospace;}

#yiv9372236111 #yiv9372236111ygrp-mlmsg * {
line-height:1.22em;}

#yiv9372236111 #yiv9372236111ygrp-mlmsg #yiv9372236111logo {
padding-bottom:10px;}


#yiv9372236111 #yiv9372236111ygrp-msg p a {
font-family:Verdana;}

#yiv9372236111 #yiv9372236111ygrp-msg
p#yiv9372236111attach-count span {
color:#1E66AE;font-weight:700;}

#yiv9372236111 #yiv9372236111ygrp-reco
#yiv9372236111reco-head {
color:#ff7900;font-weight:700;}

#yiv9372236111 #yiv9372236111ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv9372236111 #yiv9372236111ygrp-sponsor #yiv9372236111ov
li a {
font-size:130%;text-decoration:none;}

#yiv9372236111 #yiv9372236111ygrp-sponsor #yiv9372236111ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv9372236111 #yiv9372236111ygrp-sponsor #yiv9372236111ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv9372236111 #yiv9372236111ygrp-text {
font-family:Georgia;}

#yiv9372236111 #yiv9372236111ygrp-text p {
margin:0 0 1em 0;}

#yiv9372236111 #yiv9372236111ygrp-text tt {
font-size:120%;}

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


Sat Aug 13, 2016 5:06 pm (PDT) . Posted by:

peter.oliver

Hi,
Any idea why RCHGetYahooHistory("INGA.AS") is showing error? I've been following up dozens of stock symbols during the last years without a problem. A few days ago this error started showing only for this symbol. The problem is that all sum results from all different formulas I use now show #VALUE#. I would not like to eliminate this symbol because I own the stock and I'm following it up closely.
I'm using the Version 2.1.2016.08.07 in Windows 7 Ultimate 32 bits
Thank you for any help.
Thank you also for developing and sharing this extraordinary tool.
Peter.

Sat Aug 13, 2016 6:16 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The reason it's getting an "Error" result is because Yahoo is returning a
"404" error, or "Sorry, the page you requested was not found." when the
add-in goes to grab the CSV file.

I also get that error in my browser when I click the download link on the
historical quotes web page. So, although they are displaying data on that
page, it isn't available in CSV format. I suspect it's a temporary issue.
You can always raise the issue with Yahoo -- tell them that the download
link on that page isn't working.

On Sat, Aug 13, 2016 at 5:06 PM, peter.oliver@
​...wrote:

> Any idea why RCHGetYahooHistory("INGA.AS") is showing error? I've been
> following up dozens of stock symbols during the last years without a
> problem. A few days ago this error started showing only for this symbol.
> The problem is that all sum results from all different formulas I use now
> show #VALUE#. I would not like to eliminate this symbol because I own the
> stock and I'm following it up closely.
>
> I'm using the Version 2.1.2016.08.07 in Windows 7 Ultimate 32 bits
>
> Thank you for any help.
>
> Thank you also for developing and sharing this extraordinary tool.
>
> Peter.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.34

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)