15 Messages
Digest #4040
3c
Re: Shift f9 nothing happens, hit calculate sheet nothing happens. [ by "Randy Harmelink" rharmelink
Messages
Sun May 28, 2017 8:18 pm (PDT) . Posted by:
h.tong92
Date Open High Low Close Volume Unadj Div Adj Split Adj Dividend Split 2017-05-25 $198.41 $199.61 $197.75 $199.54 1460300 $199.54 1.0000 1.0000 2017-05-24 $198.49 $198.53 $197.28 $197.49 1206400 $197.49 1.0000 1.0000 2017-05-23 $198.73 $198.97 $197.52 $197.73 1514200 $197.73 1.0000 1.0000 2017-05-22 $196.35 $198.67 $196.35 $198.51 1835900 $198.51 1.0000 1.0000 2017-05-19 $196.30 $196.30 $194.45 $195.80 1894700 $195.80 1.0000 1.0000 2017-05-18 $194.50 $195.82 $193.54 $195.24 1929000 $195.24 1.0000 1.0000 2017-05-17 $196.74 $196.74 $194.72 $194.84 1881800 $194.84 1.0000 1.0000 $1.18 2017-05-16 $196.31 $196.76 $195.69 $196.74 1183600 $197.91 0.9941 1.0000 2017-05-15 $195.50 $196.57 $195.07 $196.46 1474500 $197.63 0.9941 1.0000
Hi Randy, I noticed your adjusted closes before the dividend payout is different from Yahoo's (see 2017-05-15 & 2017-05-16). Is this an error?
Hi Randy, I noticed your adjusted closes before the dividend payout is different from Yahoo's (see 2017-05-15 & 2017-05-16). Is this an error?
Sun May 28, 2017 8:18 pm (PDT) . Posted by:
h.tong92
Hey Randy, I noticed your adjusted closes before the dividend payouts are different from Yahoo's closes (see 2017-05-15 & 2017-05-16 for MMM). Is there a way around this?
Sun May 28, 2017 8:21 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
No error. That's exactly what adjusting for dividends is supposed to do.
Just like you would adjust for a stock split.
It's a matter of making historical prices be on par with the current price.
On Sun, May 28, 2017 at 8:11 PM, h.tong92@
...wrote:
>
> *Date* *Open* *High* *Low* *Close* *Volume* *Unadj* *Div Adj* *Split Adj*
> *Dividend* *Split*
> 2017-05-25 $198.41 $199.61 $197.75 $199.54 1460300 $199.54 1.0000 1.0000
>
> 2017-05-24 $198.49 $198.53 $197.28 $197.49 1206400 $197.49 1.0000 1.0000
>
> 2017-05-23 $198.73 $198.97 $197.52 $197.73 1514200 $197.73 1.0000 1.0000
>
> 2017-05-22 $196.35 $198.67 $196.35 $198.51 1835900 $198.51 1.0000 1.0000
>
> 2017-05-19 $196.30 $196.30 $194.45 $195.80 1894700 $195.80 1.0000 1.0000
>
> 2017-05-18 $194.50 $195.82 $193.54 $195.24 1929000 $195.24 1.0000 1.0000
>
> 2017-05-17 $196.74 $196.74 $194.72 $194.84 1881800 $194.84 1.0000 1.0000
> $1.18
> 2017-05-16 $196.31 $196.76 $195.69 $196.74 1183600 $197.91 0.9941 1.0000
>
> 2017-05-15 $195.50 $196.57 $195.07 $196.46 1474500 $197.63 0.9941 1.0000
>
> Hi Randy, I noticed your adjusted closes before the dividend payout is
> different from Yahoo's (see 2017-05-15 & 2017-05-16). Is this an error?
>
>
Just like you would adjust for a stock split.
It's a matter of making historical prices be on par with the current price.
On Sun, May 28, 2017 at 8:11 PM, h.tong92@
...wrote:
>
> *Date* *Open* *High* *Low* *Close* *Volume* *Unadj* *Div Adj* *Split Adj*
> *Dividend* *Split*
> 2017-05-25 $198.41 $199.61 $197.75 $199.54 1460300 $199.54 1.0000 1.0000
>
> 2017-05-24 $198.49 $198.53 $197.28 $197.49 1206400 $197.49 1.0000 1.0000
>
> 2017-05-23 $198.73 $198.97 $197.52 $197.73 1514200 $197.73 1.0000 1.0000
>
> 2017-05-22 $196.35 $198.67 $196.35 $198.51 1835900 $198.51 1.0000 1.0000
>
> 2017-05-19 $196.30 $196.30 $194.45 $195.80 1894700 $195.80 1.0000 1.0000
>
> 2017-05-18 $194.50 $195.82 $193.54 $195.24 1929000 $195.24 1.0000 1.0000
>
> 2017-05-17 $196.74 $196.74 $194.72 $194.84 1881800 $194.84 1.0000 1.0000
> $1.18
> 2017-05-16 $196.31 $196.76 $195.69 $196.74 1183600 $197.91 0.9941 1.0000
>
> 2017-05-15 $195.50 $196.57 $195.07 $196.46 1474500 $197.63 0.9941 1.0000
>
> Hi Randy, I noticed your adjusted closes before the dividend payout is
> different from Yahoo's (see 2017-05-15 & 2017-05-16). Is this an error?
>
>
Sun May 28, 2017 8:21 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You can always use the unadjusted price.
On Sun, May 28, 2017 at 8:08 PM, h.tong92@
...wrote:
>
> Hey Randy, I noticed your adjusted closes before the dividend payouts are
> different from Yahoo's closes (see 2017-05-15 & 2017-05-16 for MMM). Is
> there a way around this?
>
>
On Sun, May 28, 2017 at 8:08 PM, h.tong92@
...wrote:
>
> Hey Randy, I noticed your adjusted closes before the dividend payouts are
> different from Yahoo's closes (see 2017-05-15 & 2017-05-16 for MMM). Is
> there a way around this?
>
>
Sun May 28, 2017 8:24 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I want to have a solution to weekly/monthly/quarterly/annual data before I
do an official release.
I've not found an acceptable source of free historical quotes. None have
adjustments for dividends. The main pay service I saw a mention of was not
acceptable. Something like $30 a month...
On Sun, May 28, 2017 at 6:56 PM, jason@
...wrote:
>
> I am waiting patiently (and hopeful) for the new version of
> smf_getyahoohistory to become available. Seeing Yahoo could become a less
> and less reliable as a data source, is there any alternative sources to get
> historical prices? I did notice that Google has historical prices but do
> not see it as an element in smf-elements-3.
>
> Also, do you know of any paid services offering similar functionality
> should this be the end of the road for historical prices? :(
>
>
>
do an official release.
I've not found an acceptable source of free historical quotes. None have
adjustments for dividends. The main pay service I saw a mention of was not
acceptable. Something like $30 a month...
On Sun, May 28, 2017 at 6:56 PM, jason@
...wrote:
>
> I am waiting patiently (and hopeful) for the new version of
> smf_getyahoohistory to become available. Seeing Yahoo could become a less
> and less reliable as a data source, is there any alternative sources to get
> historical prices? I did notice that Google has historical prices but do
> not see it as an element in smf-elements-
>
> Also, do you know of any paid services offering similar functionality
> should this be the end of the road for historical prices? :(
>
>
>
Mon May 29, 2017 5:50 am (PDT) . Posted by:
bamzoomalice
Have you tried pulling from Investopedia? They have a historical price function with an adjusted close field.
Jason
Jason
Mon May 29, 2017 11:03 am (PDT) . Posted by:
eadamy
> Also, do you know of any paid services offering similar functionality should this be the end of the road for historical prices?
Depending on your need, you could try Quandl's Quote Media Premium service at $50/month or $450+- per year. The CSV format is readily loaded into Excel arrays similar to the old Yahoo data. The closing price data is decent; however I found many errors in the adjusted close data which I use for much of my work. I found Yahoo's adjusted close data from Randy's smfGetYahooHistory function to be more accurate than Quote Media's however I ran into a fair number of corrupted data streams with Yahoo.
Ultimately, I ended up building my own solution using multiple sources; however Yahoo would be my first choice for free data with possible backup using Google's historical data (which has more problems than Yahoo's).
Earl Adamy
Depending on your need, you could try Quandl's Quote Media Premium service at $50/month or $450+- per year. The CSV format is readily loaded into Excel arrays similar to the old Yahoo data. The closing price data is decent; however I found many errors in the adjusted close data which I use for much of my work. I found Yahoo's adjusted close data from Randy's smfGetYahooHistory function to be more accurate than Quote Media's however I ran into a fair number of corrupted data streams with Yahoo.
Ultimately, I ended up building my own solution using multiple sources; however Yahoo would be my first choice for free data with possible backup using Google's historical data (which has more problems than Yahoo's)
Earl Adamy
Mon May 29, 2017 11:06 am (PDT) . Posted by:
eadamy
One more source for free company historical price data only (no indexes, ETFs, etc) is Quandl's end of day WIKI database. That data is readily available with a URL fetch in various formats and since it is curated by a volunteer group, is probably of decent quality.
Earl Adamy
Earl Adamy
Sun May 28, 2017 8:26 pm (PDT) . Posted by:
"Joe" jtassielli2003
Randy,
My goof. Fixed the problem, very simple.
thanks, and sorry about taking up some of your time.
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Sunday, May 28, 2017 3:07 PM
Subject: Re: [smf_addin] Shift f9 nothing happens, hit calculate sheet nothing happens.
Example of formula please.
On Sun, May 28, 2017 at 10:43 AM, Joe jtassielli2003@...wrote:
I tried recalculating the worksheet. Always worked before. Tried Developer/Tools/Macros/smf force calculation.
Nothing happens.
#yiv0189496706 #yiv0189496706 -- #yiv0189496706ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0189496706 #yiv0189496706ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0189496706 #yiv0189496706ygrp-mkp #yiv0189496706hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0189496706 #yiv0189496706ygrp-mkp #yiv0189496706ads {margin-bottom:10px;}#yiv0189496706 #yiv0189496706ygrp-mkp .yiv0189496706ad {padding:0 0;}#yiv0189496706 #yiv0189496706ygrp-mkp .yiv0189496706ad p {margin:0;}#yiv0189496706 #yiv0189496706ygrp-mkp .yiv0189496706ad a {color:#0000ff;text-decoration:none;}#yiv0189496706 #yiv0189496706ygrp-sponsor #yiv0189496706ygrp-lc {font-family:Arial;}#yiv0189496706 #yiv0189496706ygrp-sponsor #yiv0189496706ygrp-lc #yiv0189496706hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0189496706 #yiv0189496706ygrp-sponsor #yiv0189496706ygrp-lc .yiv0189496706ad {margin-bottom:10px;padding:0 0;}#yiv0189496706 #yiv0189496706actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0189496706 #yiv0189496706activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0189496706 #yiv0189496706activity span {font-weight:700;}#yiv0189496706 #yiv0189496706activity span:first-child {text-transform:uppercase;}#yiv0189496706 #yiv0189496706activity span a {color:#5085b6;text-decoration:none;}#yiv0189496706 #yiv0189496706activity span span {color:#ff7900;}#yiv0189496706 #yiv0189496706activity span .yiv0189496706underline {text-decoration:underline;}#yiv0189496706 .yiv0189496706attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0189496706 .yiv0189496706attach div a {text-decoration:none;}#yiv0189496706 .yiv0189496706attach img {border:none;padding-right:5px;}#yiv0189496706 .yiv0189496706attach label {display:block;margin-bottom:5px;}#yiv0189496706 .yiv0189496706attach label a {text-decoration:none;}#yiv0189496706 blockquote {margin:0 0 0 4px;}#yiv0189496706 .yiv0189496706bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0189496706 .yiv0189496706bold a {text-decoration:none;}#yiv0189496706 dd.yiv0189496706last p a {font-family:Verdana;font-weight:700;}#yiv0189496706 dd.yiv0189496706last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0189496706 dd.yiv0189496706last p span.yiv0189496706yshortcuts {margin-right:0;}#yiv0189496706 div.yiv0189496706attach-table div div a {text-decoration:none;}#yiv0189496706 div.yiv0189496706attach-table {width:400px;}#yiv0189496706 div.yiv0189496706file-title a, #yiv0189496706 div.yiv0189496706file-title a:active, #yiv0189496706 div.yiv0189496706file-title a:hover, #yiv0189496706 div.yiv0189496706file-title a:visited {text-decoration:none;}#yiv0189496706 div.yiv0189496706photo-title a, #yiv0189496706 div.yiv0189496706photo-title a:active, #yiv0189496706 div.yiv0189496706photo-title a:hover, #yiv0189496706 div.yiv0189496706photo-title a:visited {text-decoration:none;}#yiv0189496706 div#yiv0189496706ygrp-mlmsg #yiv0189496706ygrp-msg p a span.yiv0189496706yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0189496706 .yiv0189496706green {color:#628c2a;}#yiv0189496706 .yiv0189496706MsoNormal {margin:0 0 0 0;}#yiv0189496706 o {font-size:0;}#yiv0189496706 #yiv0189496706photos div {float:left;width:72px;}#yiv0189496706 #yiv0189496706photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0189496706 #yiv0189496706photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0189496706 #yiv0189496706reco-category {font-size:77%;}#yiv0189496706 #yiv0189496706reco-desc {font-size:77%;}#yiv0189496706 .yiv0189496706replbq {margin:4px;}#yiv0189496706 #yiv0189496706ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0189496706 #yiv0189496706ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0189496706 #yiv0189496706ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0189496706 #yiv0189496706ygrp-mlmsg select, #yiv0189496706 input, #yiv0189496706 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0189496706 #yiv0189496706ygrp-mlmsg pre, #yiv0189496706 code {font:115% monospace;}#yiv0189496706 #yiv0189496706ygrp-mlmsg * {line-height:1.22em;}#yiv0189496706 #yiv0189496706ygrp-mlmsg #yiv0189496706logo {padding-bottom:10px;}#yiv0189496706 #yiv0189496706ygrp-msg p a {font-family:Verdana;}#yiv0189496706 #yiv0189496706ygrp-msg p#yiv0189496706attach-count span {color:#1E66AE;font-weight:700;}#yiv0189496706 #yiv0189496706ygrp-reco #yiv0189496706reco-head {color:#ff7900;font-weight:700;}#yiv0189496706 #yiv0189496706ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0189496706 #yiv0189496706ygrp-sponsor #yiv0189496706ov li a {font-size:130%;text-decoration:none;}#yiv0189496706 #yiv0189496706ygrp-sponsor #yiv0189496706ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0189496706 #yiv0189496706ygrp-sponsor #yiv0189496706ov ul {margin:0;padding:0 0 0 8px;}#yiv0189496706 #yiv0189496706ygrp-text {font-family:Georgia;}#yiv0189496706 #yiv0189496706ygrp-text p {margin:0 0 1em 0;}#yiv0189496706 #yiv0189496706ygrp-text tt {font-size:120%;}#yiv0189496706 #yiv0189496706ygrp-vital ul li:last-child {border-right:none !important;}#yiv0189496706
My goof. Fixed the problem, very simple.
thanks, and sorry about taking up some of your time.
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Sunday, May 28, 2017 3:07 PM
Subject: Re: [smf_addin] Shift f9 nothing happens, hit calculate sheet nothing happens.
Example of formula please.
On Sun, May 28, 2017 at 10:43 AM, Joe jtassielli2003@...wrote:
I tried recalculating the worksheet. Always worked before. Tried Developer/Tools/
Nothing happens.
#yiv0189496706 #yiv0189496706 -- #yiv0189496706ygrp-
Mon May 29, 2017 11:03 am (PDT) . Posted by:
herbshack13
I'm having a similar issue with formulas such as:
=rchgettablecell("http://sportsdatabase.com/mlb/query?su=1&sdql=o%3ASTL",1,"SU:")
Sometimes, IE will go to the regular page and I'll get the string: '9556-9551 (-0.02, 50.0%)' returned;
however, if the site is getting a lot of traffic, sometimes an open to the public query like that one will result in a 500 timeout page: (See Attachment)
Now, usually, if / when this happens, I can just run 'smfforcerecalculation'
but lately, it seems that the macro doesn't do anything.
Did something change where the smf plugin used to be able to recognize a 500 error page as an error that needs to be smfforcerecalculation macro'd? (rather than recognizing it as a successful query with a parse error)
Thanks!
=rchgettablecell("http://sportsdatabase.com/mlb/query?su=1&sdql=o%3ASTL",1,"
Sometimes, IE will go to the regular page and I'll get the string: '9556-9551 (-0.02, 50.0%)&#
however, if the site is getting a lot of traffic, sometimes an open to the public query like that one will result in a 500 timeout page: (See Attachment)
Now, usually, if / when this happens, I can just run 'smfforcerecalc
but lately, it seems that the macro doesn't do anything.
Did something change where the smf plugin used to be able to recognize a 500 error page as an error that needs to be smfforcerecalculati
Thanks!
Attachment(s) from
1 of 1 Photo(s)
Mon May 29, 2017 11:43 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Nothing has changed regarding recognizing an error. I'm not even sure the
add-in could recognize the error, because a web page *is* returned. It's
just that it contains an error message.
You can always check the log to see what kinds of things are going on...
On Mon, May 29, 2017 at 11:03 AM, therber2@
...wrote:
>
> I'm having a similar issue with formulas such as:
>
> =rchgettablecell("http://sportsdatabase.com/mlb/query?su=1&sdql=o%3ASTL
> ",1,"SU:")
>
> Sometimes, IE will go to the regular page and I'll get the string:
> '9556-9551 (-0.02, 50.0%)' returned;
> however, if the site is getting a lot of traffic, sometimes an open to the
> public query like that one will result in a 500 timeout page: (See
> Attachment)
>
> Now, usually, if / when this happens, I can just run
> 'smfforcerecalculation'
> but lately, it seems that the macro doesn't do anything.
>
> Did something change where the smf plugin used to be able to recognize a
> 500 error page as an error that needs to be smfforcerecalculation macro'd?
> (rather than recognizing it as a successful query with a parse error)
>
>
>
add-in could recognize the error, because a web page *is* returned. It's
just that it contains an error message.
You can always check the log to see what kinds of things are going on...
On Mon, May 29, 2017 at 11:03 AM, therber2@
...wrote:
>
> I'm having a similar issue with formulas such as:
>
> =rchgettablecell("http://sportsdatabase.com/mlb/query?su=1&sdql=o%3ASTL
> ",1,"
>
> Sometimes, IE will go to the regular page and I'll get the string:
> '9556-9551 (-0.02, 50.0%)&#
> however, if the site is getting a lot of traffic, sometimes an open to the
> public query like that one will result in a 500 timeout page: (See
> Attachment)
>
> Now, usually, if / when this happens, I can just run
> 'smfforcerecalc
> but lately, it seems that the macro doesn't do anything.
>
> Did something change where the smf plugin used to be able to recognize a
> 500 error page as an error that needs to be smfforcerecalculati
> (rather than recognizing it as a successful query with a parse error)
>
>
>
Mon May 29, 2017 10:40 am (PDT) . Posted by:
"Joe" jtassielli2003
Perfect, used the 1st one.
thanks.
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Friday, May 26, 2017 4:27 PM
Subject: Re: [smf_addin] Extract a cell from web based excel file, morning star #28540
Try:
=smfConvertData(smfWord(RCHGetWebData("http://performance.morningstar.com/Performance/stock/exportStockPrice.action?pd=10y&freq=a&t=PM","12/30/2016,",100),5,","))
Or, if you know where it will be on the returned file:
=INDEX(smfGetCSVFile("http://performance.morningstar.com/Performance/stock/exportStockPrice.action?pd=10y&freq=a&t=PM",,4,5),4,5)
On Fri, May 26, 2017 at 1:01 PM, jtassielli2003@...wrote:
I just wish to extract a single cell, E4: 91.49.
I used
http://performance. morningstar.com/Performance/ stock/exportStockPrice.action? pd=10y&freq=a&t=PM
thanks
| Date | Open | High | Low | Close | Volume |
| 5/25/2017 | 91.49 | 119.78 | 89.97 | 119.48 | 4,226,889 |
| 12/30/2016 | 87.91 | 104.2 | 84.46 | 91.49 | 4,470,395 |
#yiv9334846094 #yiv9334846094 -- #yiv9334846094ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9334846094 #yiv9334846094ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9334846094 #yiv9334846094ygrp-mkp #yiv9334846094hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9334846094 #yiv9334846094ygrp-mkp #yiv9334846094ads {margin-bottom:10px;}#yiv9334846094 #yiv9334846094ygrp-mkp .yiv9334846094ad {padding:0 0;}#yiv9334846094 #yiv9334846094ygrp-mkp .yiv9334846094ad p {margin:0;}#yiv9334846094 #yiv9334846094ygrp-mkp .yiv9334846094ad a {color:#0000ff;text-decoration:none;}#yiv9334846094 #yiv9334846094ygrp-sponsor #yiv9334846094ygrp-lc {font-family:Arial;}#yiv9334846094 #yiv9334846094ygrp-sponsor #yiv9334846094ygrp-lc #yiv9334846094hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9334846094 #yiv9334846094ygrp-sponsor #yiv9334846094ygrp-lc .yiv9334846094ad {margin-bottom:10px;padding:0 0;}#yiv9334846094 #yiv9334846094actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9334846094 #yiv9334846094activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9334846094 #yiv9334846094activity span {font-weight:700;}#yiv9334846094 #yiv9334846094activity span:first-child {text-transform:uppercase;}#yiv9334846094 #yiv9334846094activity span a {color:#5085b6;text-decoration:none;}#yiv9334846094 #yiv9334846094activity span span {color:#ff7900;}#yiv9334846094 #yiv9334846094activity span .yiv9334846094underline {text-decoration:underline;}#yiv9334846094 .yiv9334846094attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9334846094 .yiv9334846094attach div a {text-decoration:none;}#yiv9334846094 .yiv9334846094attach img {border:none;padding-right:5px;}#yiv9334846094 .yiv9334846094attach label {display:block;margin-bottom:5px;}#yiv9334846094 .yiv9334846094attach label a {text-decoration:none;}#yiv9334846094 blockquote {margin:0 0 0 4px;}#yiv9334846094 .yiv9334846094bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9334846094 .yiv9334846094bold a {text-decoration:none;}#yiv9334846094 dd.yiv9334846094last p a {font-family:Verdana;font-weight:700;}#yiv9334846094 dd.yiv9334846094last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9334846094 dd.yiv9334846094last p span.yiv9334846094yshortcuts {margin-right:0;}#yiv9334846094 div.yiv9334846094attach-table div div a {text-decoration:none;}#yiv9334846094 div.yiv9334846094attach-table {width:400px;}#yiv9334846094 div.yiv9334846094file-title a, #yiv9334846094 div.yiv9334846094file-title a:active, #yiv9334846094 div.yiv9334846094file-title a:hover, #yiv9334846094 div.yiv9334846094file-title a:visited {text-decoration:none;}#yiv9334846094 div.yiv9334846094photo-title a, #yiv9334846094 div.yiv9334846094photo-title a:active, #yiv9334846094 div.yiv9334846094photo-title a:hover, #yiv9334846094 div.yiv9334846094photo-title a:visited {text-decoration:none;}#yiv9334846094 div#yiv9334846094ygrp-mlmsg #yiv9334846094ygrp-msg p a span.yiv9334846094yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9334846094 .yiv9334846094green {color:#628c2a;}#yiv9334846094 .yiv9334846094MsoNormal {margin:0 0 0 0;}#yiv9334846094 o {font-size:0;}#yiv9334846094 #yiv9334846094photos div {float:left;width:72px;}#yiv9334846094 #yiv9334846094photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9334846094 #yiv9334846094photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9334846094 #yiv9334846094reco-category {font-size:77%;}#yiv9334846094 #yiv9334846094reco-desc {font-size:77%;}#yiv9334846094 .yiv9334846094replbq {margin:4px;}#yiv9334846094 #yiv9334846094ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9334846094 #yiv9334846094ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9334846094 #yiv9334846094ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9334846094 #yiv9334846094ygrp-mlmsg select, #yiv9334846094 input, #yiv9334846094 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9334846094 #yiv9334846094ygrp-mlmsg pre, #yiv9334846094 code {font:115% monospace;}#yiv9334846094 #yiv9334846094ygrp-mlmsg * {line-height:1.22em;}#yiv9334846094 #yiv9334846094ygrp-mlmsg #yiv9334846094logo {padding-bottom:10px;}#yiv9334846094 #yiv9334846094ygrp-msg p a {font-family:Verdana;}#yiv9334846094 #yiv9334846094ygrp-msg p#yiv9334846094attach-count span {color:#1E66AE;font-weight:700;}#yiv9334846094 #yiv9334846094ygrp-reco #yiv9334846094reco-head {color:#ff7900;font-weight:700;}#yiv9334846094 #yiv9334846094ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9334846094 #yiv9334846094ygrp-sponsor #yiv9334846094ov li a {font-size:130%;text-decoration:none;}#yiv9334846094 #yiv9334846094ygrp-sponsor #yiv9334846094ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9334846094 #yiv9334846094ygrp-sponsor #yiv9334846094ov ul {margin:0;padding:0 0 0 8px;}#yiv9334846094 #yiv9334846094ygrp-text {font-family:Georgia;}#yiv9334846094 #yiv9334846094ygrp-text p {margin:0 0 1em 0;}#yiv9334846094 #yiv9334846094ygrp-text tt {font-size:120%;}#yiv9334846094 #yiv9334846094ygrp-vital ul li:last-child {border-right:none !important;}#yiv9334846094
thanks.
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Friday, May 26, 2017 4:27 PM
Subject: Re: [smf_addin] Extract a cell from web based excel file, morning star #28540
Try:
=smfConvertData(smfWord(RCHGetWebData("http://performance.morningstar.com/Performance/stock/exportStockPrice.action?pd=10y&freq=a&t=PM","12/30/2016,",100),5,","))
Or, if you know where it will be on the returned file:
=INDEX(smfGetCSVFile("http://performance.morningstar.com/Performance/stock/exportStockPrice.action?pd=10y&freq=a&t=PM",,4,5),4,5)
On Fri, May 26, 2017 at 1:01 PM, jtassielli2003@...wrote:
I just wish to extract a single cell, E4: 91.49.
I used
http://performance. morningstar.
thanks
| Date | Open | High | Low | Close | Volume |
| 5/25/2017 | 91.49 | 119.78 | 89.97 | 119.48 | 4,226,889 |
| 12/30/2016 | 87.91 | 104.2 | 84.46 | 91.49 | 4,470,395 |
#yiv9334846094 #yiv9334846094 -- #yiv9334846094ygrp-
Mon May 29, 2017 11:46 am (PDT) . Posted by:
raffrobb@gmail.com
Thanks so much, I am so glad you have a handle on yahoo! I sure don't.
Out of curiosity, why the switch to JSON by Yahoo?
Out of curiosity, why the switch to JSON by Yahoo?
Mon May 29, 2017 11:51 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
JSON seems to be the new way to handle the data. More and more services are
going to it. That's why I ended up finding and adapting some JSON parsing
routines.
On Mon, May 29, 2017 at 11:46 AM, raffrobb@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Out of curiosity, why the switch to JSON by Yahoo?
>
>
going to it. That's why I ended up finding and adapting some JSON parsing
routines.
On Mon, May 29, 2017 at 11:46 AM, raffrobb@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Out of curiosity, why the switch to JSON by Yahoo?
>
>
Mon May 29, 2017 1:07 pm (PDT) . Posted by:
"Leo Bueno" leobueno
I am seeing an odd behavior in the add-in.
When I open an Excel 2010 spreadsheet which uses the add-in, for example, to get current prices of a list of stocks from Yahoo, the numbers do not update automatically.
I have to toggle the add-in in order for it to work. That is, I have to follow this sequence of steps:
File/Options/Add-Ins/Go then either check or uncheck the SMF-Add-In box.
What am I doing wrong?
[cid:image001.png@01D1DD1A.2A187870]
Leo Bueno
305-669-5260
1825 Ponce de Leon Boulevard # 483
Coral Gables, FL 33134
Skype: BuenoLaw
Leo@BuenoLaw.com<mailto:Leo@BuenoLaw.com>
When I open an Excel 2010 spreadsheet which uses the add-in, for example, to get current prices of a list of stocks from Yahoo, the numbers do not update automatically.
I have to toggle the add-in in order for it to work. That is, I have to follow this sequence of steps:
File/Options/Add-Ins/Go then either check or uncheck the SMF-Add-In box.
What am I doing wrong?
[cid:image001.png@01D1DD1A.2A187870]
Leo Bueno
305-669-5260
1825 Ponce de Leon Boulevard # 483
Coral Gables, FL 33134
Skype: BuenoLaw
Leo@BuenoLaw.com<mailto:Leo@BuenoLaw.com>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar