12 Messages
Digest #4056
6b
Re: Stockcharts pulled into Excel for Daily Weekly and Monthly Chart by "Randy Harmelink" rharmelink
Messages
Sat Jun 10, 2017 7:31 pm (PDT) . Posted by:
sjagers
Randy..... Thanks for your help. Your workaround formulas work great.
I wish these websites would quite changing stuff. They need a new policy: "if it's not broken, don't fix it."
I'm sure you're overwhelmed with all the changes. Be assured, however, that we all appreciate your hard work. Your SMF function is SO useful.
Thanks again. Best regards.
I wish these websites would quite changing stuff. They need a new policy: "if it's not broken, don't fix it."
I'm sure you're overwhelmed with all the changes. Be assured, however, that we all appreciate your hard work. Your SMF function is SO useful.
Thanks again. Best regards.
Sat Jun 10, 2017 7:36 pm (PDT) . Posted by:
"Wasi"
Hi,
As you go on this website: http://financials.morningstar.com/income-statement/is.html?t=AAPL <http://financials.morningstar.com/income-statement/is.html?t=AAPL®ion=USA&culture=en_US> ®ion=USA&culture=en_US
And use the "Rounding" button for increasing decimals. And then hit the "Export" button. So, to achieve both of these objectives, are there some instruction you would type in at the above website. To get it done in one key stroke?
Thanks
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Saturday, June 10, 2017 2:18 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: Exporting financials from morningstar.com.
Which button is that?
On Fri, Jun 9, 2017 at 8:29 PM, 'Wasi' wasi.rahim@
...
wrote:
I am wondering if there is a way to export financials from Morningstar.com without decreasing decimal places? I meant, by typing some special instructions in the url of Morningstar.com to do it. One other way is to increase the decimal place by clicking on the button situated on the financials page and then hit "export" to bring on to your computer.
But I am just wondering?
As you go on this website: http://financials.morningstar.com/income-statement/is.html?t=AAPL <http://financials.morningstar.com/income-statement/is.html?t=AAPL®ion=USA&culture=en_US> ®ion=USA&culture=en_US
And use the "Rounding" button for increasing decimals. And then hit the "Export" button. So, to achieve both of these objectives, are there some instruction you would type in at the above website. To get it done in one key stroke?
Thanks
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Saturday, June 10, 2017 2:18 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: Exporting financials from morningstar.
Which button is that?
On Fri, Jun 9, 2017 at 8:29 PM, 'Wasi' wasi.rahim@
...
wrote:
I am wondering if there is a way to export financials from Morningstar.
But I am just wondering?
Sat Jun 10, 2017 8:55 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
See this link from the "Tips and FAQs" web page:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/19776
It appears the parameters for rounding:
"&number=1&rounding=1" for dollars
"&number=2&rounding=2" for thousands
"&number=3&rounding=3" for millions
"&number=4&rounding=4" for billions
On Sat, Jun 10, 2017 at 7:35 PM, 'Wasi' wasi.rahim@
...
wrote:
>
>
> As you go on this website: http://financials.morningstar.
> com/income-statement/is.html?t=AAPL®ion=USA&culture=en_US
>
> And use the "Rounding" button for increasing decimals. And then hit the
> "Export" button. So, to achieve both of these objectives, are there some
> instruction you would type in at the above website. To get it done in one
> key stroke?
>
>
>
>
>
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/19776
It appears the parameters for rounding:
"&number=1&rounding=1" for dollars
"&number=2&rounding=2" for thousands
"&number=3&rounding=3" for millions
"&number=4&rounding=4" for billions
On Sat, Jun 10, 2017 at 7:35 PM, 'Wasi' wasi.rahim@
...
wrote:
>
>
> As you go on this website: http://financials.morningstar.
> com/income-statemen
>
> And use the "Rounding" button for increasing decimals. And then hit the
> "Export" button. So, to achieve both of these objectives, are there some
> instruction you would type in at the above website. To get it done in one
> key stroke?
>
>
>
>
>
Sun Jun 11, 2017 11:29 am (PDT) . Posted by:
"Yahoo!" lewglenn
What's different in this latest version?
On Saturday, June 10, 2017, 3:28:29 PM PDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
I just had to change the beta again yesterday:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32537
On Sat, Jun 10, 2017 at 1:47 PM, marksimms@... wrote:
Any ETA on having this ability to reference the new Yahoo history ?
#yiv0146751690 #yiv0146751690 -- #yiv0146751690ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0146751690 #yiv0146751690ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0146751690 #yiv0146751690ygrp-mkp #yiv0146751690hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0146751690 #yiv0146751690ygrp-mkp #yiv0146751690ads {margin-bottom:10px;}#yiv0146751690 #yiv0146751690ygrp-mkp .yiv0146751690ad {padding:0 0;}#yiv0146751690 #yiv0146751690ygrp-mkp .yiv0146751690ad p {margin:0;}#yiv0146751690 #yiv0146751690ygrp-mkp .yiv0146751690ad a {color:#0000ff;text-decoration:none;}#yiv0146751690 #yiv0146751690ygrp-sponsor #yiv0146751690ygrp-lc {font-family:Arial;}#yiv0146751690 #yiv0146751690ygrp-sponsor #yiv0146751690ygrp-lc #yiv0146751690hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0146751690 #yiv0146751690ygrp-sponsor #yiv0146751690ygrp-lc .yiv0146751690ad {margin-bottom:10px;padding:0 0;}#yiv0146751690 #yiv0146751690actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0146751690 #yiv0146751690activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0146751690 #yiv0146751690activity span {font-weight:700;}#yiv0146751690 #yiv0146751690activity span:first-child {text-transform:uppercase;}#yiv0146751690 #yiv0146751690activity span a {color:#5085b6;text-decoration:none;}#yiv0146751690 #yiv0146751690activity span span {color:#ff7900;}#yiv0146751690 #yiv0146751690activity span .yiv0146751690underline {text-decoration:underline;}#yiv0146751690 .yiv0146751690attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0146751690 .yiv0146751690attach div a {text-decoration:none;}#yiv0146751690 .yiv0146751690attach img {border:none;padding-right:5px;}#yiv0146751690 .yiv0146751690attach label {display:block;margin-bottom:5px;}#yiv0146751690 .yiv0146751690attach label a {text-decoration:none;}#yiv0146751690 blockquote {margin:0 0 0 4px;}#yiv0146751690 .yiv0146751690bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0146751690 .yiv0146751690bold a {text-decoration:none;}#yiv0146751690 dd.yiv0146751690last p a {font-family:Verdana;font-weight:700;}#yiv0146751690 dd.yiv0146751690last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0146751690 dd.yiv0146751690last p span.yiv0146751690yshortcuts {margin-right:0;}#yiv0146751690 div.yiv0146751690attach-table div div a {text-decoration:none;}#yiv0146751690 div.yiv0146751690attach-table {width:400px;}#yiv0146751690 div.yiv0146751690file-title a, #yiv0146751690 div.yiv0146751690file-title a:active, #yiv0146751690 div.yiv0146751690file-title a:hover, #yiv0146751690 div.yiv0146751690file-title a:visited {text-decoration:none;}#yiv0146751690 div.yiv0146751690photo-title a, #yiv0146751690 div.yiv0146751690photo-title a:active, #yiv0146751690 div.yiv0146751690photo-title a:hover, #yiv0146751690 div.yiv0146751690photo-title a:visited {text-decoration:none;}#yiv0146751690 div#yiv0146751690ygrp-mlmsg #yiv0146751690ygrp-msg p a span.yiv0146751690yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0146751690 .yiv0146751690green {color:#628c2a;}#yiv0146751690 .yiv0146751690MsoNormal {margin:0 0 0 0;}#yiv0146751690 o {font-size:0;}#yiv0146751690 #yiv0146751690photos div {float:left;width:72px;}#yiv0146751690 #yiv0146751690photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv0146751690 #yiv0146751690photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0146751690 #yiv0146751690reco-category {font-size:77%;}#yiv0146751690 #yiv0146751690reco-desc {font-size:77%;}#yiv0146751690 .yiv0146751690replbq {margin:4px;}#yiv0146751690 #yiv0146751690ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0146751690 #yiv0146751690ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0146751690 #yiv0146751690ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0146751690 #yiv0146751690ygrp-mlmsg select, #yiv0146751690 input, #yiv0146751690 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0146751690 #yiv0146751690ygrp-mlmsg pre, #yiv0146751690 code {font:115% monospace;}#yiv0146751690 #yiv0146751690ygrp-mlmsg * {line-height:1.22em;}#yiv0146751690 #yiv0146751690ygrp-mlmsg #yiv0146751690logo {padding-bottom:10px;}#yiv0146751690 #yiv0146751690ygrp-msg p a {font-family:Verdana;}#yiv0146751690 #yiv0146751690ygrp-msg p#yiv0146751690attach-count span {color:#1E66AE;font-weight:700;}#yiv0146751690 #yiv0146751690ygrp-reco #yiv0146751690reco-head {color:#ff7900;font-weight:700;}#yiv0146751690 #yiv0146751690ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0146751690 #yiv0146751690ygrp-sponsor #yiv0146751690ov li a {font-size:130%;text-decoration:none;}#yiv0146751690 #yiv0146751690ygrp-sponsor #yiv0146751690ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0146751690 #yiv0146751690ygrp-sponsor #yiv0146751690ov ul {margin:0;padding:0 0 0 8px;}#yiv0146751690 #yiv0146751690ygrp-text {font-family:Georgia;}#yiv0146751690 #yiv0146751690ygrp-text p {margin:0 0 1em 0;}#yiv0146751690 #yiv0146751690ygrp-text tt {font-size:120%;}#yiv0146751690 #yiv0146751690ygrp-vital ul li:last-child {border-right:none !important;}#yiv0146751690
On Saturday, June 10, 2017, 3:28:29 PM PDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
I just had to change the beta again yesterday:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32537
On Sat, Jun 10, 2017 at 1:47 PM, marksimms@... wrote:
Any ETA on having this ability to reference the new Yahoo history ?
#yiv0146751690 #yiv0146751690 -- #yiv0146751690ygrp-
Sun Jun 11, 2017 11:48 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32537
Most important change to smfGetYahooHistory() was the removal of dividend
adjustments because Yahoo is now doing them.
On Sun, Jun 11, 2017 at 11:29 AM, Yahoo! lewglenn@
...
wrote:
>
> What's different in this latest version?
>
>
>
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32537
Most important change to smfGetYahooHistory(
adjustments because Yahoo is now doing them.
On Sun, Jun 11, 2017 at 11:29 AM, Yahoo! lewglenn@
...
wrote:
>
> What's different in this latest version?
>
>
>
Mon Jun 12, 2017 11:19 am (PDT) . Posted by:
"Madhu Khemani" madhu_98
blockquote, div.yahoo_quoted { margin-left: 0 !important; border-left:1px #715FFA solid !important; padding-left:1ex !important; background-color:white !important; } Randy, I'm just starting off with your tools, and I've loaded the beta files correctly, and gotten things to work. However, inputting =smfGetYahooHistory("IBM") in a 9x7 array as an example, just returns blanks. Other add-in calls work for me.
Thanks in advance for your help and patience!
Sent from Yahoo Mail for iPhone
On Sunday, June 11, 2017, 2:48 PM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
See: https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32537
Most important change to smfGetYahooHistory() was the removal of dividend adjustments because Yahoo is now doing them.
On Sun, Jun 11, 2017 at 11:29 AM, Yahoo! lewglenn@... wrote:
What's different in this latest version?
#yiv1074538864 #yiv1074538864 -- #yiv1074538864ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1074538864 #yiv1074538864ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1074538864 #yiv1074538864ygrp-mkp #yiv1074538864hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1074538864 #yiv1074538864ygrp-mkp #yiv1074538864ads {margin-bottom:10px;}#yiv1074538864 #yiv1074538864ygrp-mkp .yiv1074538864ad {padding:0 0;}#yiv1074538864 #yiv1074538864ygrp-mkp .yiv1074538864ad p {margin:0;}#yiv1074538864 #yiv1074538864ygrp-mkp .yiv1074538864ad a {color:#0000ff;text-decoration:none;}#yiv1074538864 #yiv1074538864ygrp-sponsor #yiv1074538864ygrp-lc {font-family:Arial;}#yiv1074538864 #yiv1074538864ygrp-sponsor #yiv1074538864ygrp-lc #yiv1074538864hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1074538864 #yiv1074538864ygrp-sponsor #yiv1074538864ygrp-lc .yiv1074538864ad {margin-bottom:10px;padding:0 0;}#yiv1074538864 #yiv1074538864actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1074538864 #yiv1074538864activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1074538864 #yiv1074538864activity span {font-weight:700;}#yiv1074538864 #yiv1074538864activity span:first-child {text-transform:uppercase;}#yiv1074538864 #yiv1074538864activity span a {color:#5085b6;text-decoration:none;}#yiv1074538864 #yiv1074538864activity span span {color:#ff7900;}#yiv1074538864 #yiv1074538864activity span .yiv1074538864underline {text-decoration:underline;}#yiv1074538864 .yiv1074538864attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1074538864 .yiv1074538864attach div a {text-decoration:none;}#yiv1074538864 .yiv1074538864attach img {border:none;padding-right:5px;}#yiv1074538864 .yiv1074538864attach label {display:block;margin-bottom:5px;}#yiv1074538864 .yiv1074538864attach label a {text-decoration:none;}#yiv1074538864 blockquote {margin:0 0 0 4px;}#yiv1074538864 .yiv1074538864bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1074538864 .yiv1074538864bold a {text-decoration:none;}#yiv1074538864 dd.yiv1074538864last p a {font-family:Verdana;font-weight:700;}#yiv1074538864 dd.yiv1074538864last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1074538864 dd.yiv1074538864last p span.yiv1074538864yshortcuts {margin-right:0;}#yiv1074538864 div.yiv1074538864attach-table div div a {text-decoration:none;}#yiv1074538864 div.yiv1074538864attach-table {width:400px;}#yiv1074538864 div.yiv1074538864file-title a, #yiv1074538864 div.yiv1074538864file-title a:active, #yiv1074538864 div.yiv1074538864file-title a:hover, #yiv1074538864 div.yiv1074538864file-title a:visited {text-decoration:none;}#yiv1074538864 div.yiv1074538864photo-title a, #yiv1074538864 div.yiv1074538864photo-title a:active, #yiv1074538864 div.yiv1074538864photo-title a:hover, #yiv1074538864 div.yiv1074538864photo-title a:visited {text-decoration:none;}#yiv1074538864 div#yiv1074538864ygrp-mlmsg #yiv1074538864ygrp-msg p a span.yiv1074538864yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1074538864 .yiv1074538864green {color:#628c2a;}#yiv1074538864 .yiv1074538864MsoNormal {margin:0 0 0 0;}#yiv1074538864 o {font-size:0;}#yiv1074538864 #yiv1074538864photos div {float:left;width:72px;}#yiv1074538864 #yiv1074538864photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv1074538864 #yiv1074538864photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1074538864 #yiv1074538864reco-category {font-size:77%;}#yiv1074538864 #yiv1074538864reco-desc {font-size:77%;}#yiv1074538864 .yiv1074538864replbq {margin:4px;}#yiv1074538864 #yiv1074538864ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1074538864 #yiv1074538864ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1074538864 #yiv1074538864ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1074538864 #yiv1074538864ygrp-mlmsg select, #yiv1074538864 input, #yiv1074538864 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1074538864 #yiv1074538864ygrp-mlmsg pre, #yiv1074538864 code {font:115% monospace;}#yiv1074538864 #yiv1074538864ygrp-mlmsg * {line-height:1.22em;}#yiv1074538864 #yiv1074538864ygrp-mlmsg #yiv1074538864logo {padding-bottom:10px;}#yiv1074538864 #yiv1074538864ygrp-msg p a {font-family:Verdana;}#yiv1074538864 #yiv1074538864ygrp-msg p#yiv1074538864attach-count span {color:#1E66AE;font-weight:700;}#yiv1074538864 #yiv1074538864ygrp-reco #yiv1074538864reco-head {color:#ff7900;font-weight:700;}#yiv1074538864 #yiv1074538864ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1074538864 #yiv1074538864ygrp-sponsor #yiv1074538864ov li a {font-size:130%;text-decoration:none;}#yiv1074538864 #yiv1074538864ygrp-sponsor #yiv1074538864ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1074538864 #yiv1074538864ygrp-sponsor #yiv1074538864ov ul {margin:0;padding:0 0 0 8px;}#yiv1074538864 #yiv1074538864ygrp-text {font-family:Georgia;}#yiv1074538864 #yiv1074538864ygrp-text p {margin:0 0 1em 0;}#yiv1074538864 #yiv1074538864ygrp-text tt {font-size:120%;}#yiv1074538864 #yiv1074538864ygrp-vital ul li:last-child {border-right:none !important;}#yiv1074538864
Thanks in advance for your help and patience!
Sent from Yahoo Mail for iPhone
On Sunday, June 11, 2017, 2:48 PM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
See: https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32537
Most important change to smfGetYahooHistory(
On Sun, Jun 11, 2017 at 11:29 AM, Yahoo! lewglenn@... wrote:
What's different in this latest version?
#yiv1074538864 #yiv1074538864 -- #yiv1074538864ygrp-
Mon Jun 12, 2017 12:30 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I just cut and pasted your formula here and I got data back. Try exiting
and restarting EXCEL, and trying it again. And if it still doesn't work,
check the version of the add-in, with:
=RCHGetElementNumber("Version")
On Mon, Jun 12, 2017 at 11:15 AM, Madhu Khemani madhu_98@
...
wrote:
>
> Randy, I'm just starting off with your tools, and I've loaded the beta
> files correctly, and gotten things to work. However, inputting
> =smfGetYahooHistory("IBM") in a 9x7 array as an example, just returns
> blanks. Other add-in calls work for me.
>
> Thanks in advance for your help and patience!
>
>
and restarting EXCEL, and trying it again. And if it still doesn't work,
check the version of the add-in, with:
=RCHGetElementNumbe
On Mon, Jun 12, 2017 at 11:15 AM, Madhu Khemani madhu_98@
...
wrote:
>
> Randy, I'm just starting off with your tools, and I've loaded the beta
> files correctly, and gotten things to work. However, inputting
> =smfGetYahooHistory
> blanks. Other add-in calls work for me.
>
> Thanks in advance for your help and patience!
>
>
Mon Jun 12, 2017 4:40 pm (PDT) . Posted by:
"Madhu Khemani" madhu_98
blockquote, div.yahoo_quoted { margin-left: 0 !important; border-left:1px #715FFA solid !important; padding-left:1ex !important; background-color:white !important; } All good now. Had an older version.
Thanks again!
Sent from Yahoo Mail for iPhone
On Monday, June 12, 2017, 3:30 PM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
I just cut and pasted your formula here and I got data back. Try exiting and restarting EXCEL, and trying it again. And if it still doesn't work, check the version of the add-in, with:
=RCHGetElementNumber("Version")
On Mon, Jun 12, 2017 at 11:15 AM, Madhu Khemani madhu_98@... wrote:
Randy, I'm just starting off with your tools, and I've loaded the beta files correctly, and gotten things to work. However, inputting =smfGetYahooHistory("IBM") in a 9x7 array as an example, just returns blanks. Other add-in calls work for me.
Thanks in advance for your help and patience!
#yiv3928452050 #yiv3928452050 -- #yiv3928452050ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3928452050 #yiv3928452050ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3928452050 #yiv3928452050ygrp-mkp #yiv3928452050hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3928452050 #yiv3928452050ygrp-mkp #yiv3928452050ads {margin-bottom:10px;}#yiv3928452050 #yiv3928452050ygrp-mkp .yiv3928452050ad {padding:0 0;}#yiv3928452050 #yiv3928452050ygrp-mkp .yiv3928452050ad p {margin:0;}#yiv3928452050 #yiv3928452050ygrp-mkp .yiv3928452050ad a {color:#0000ff;text-decoration:none;}#yiv3928452050 #yiv3928452050ygrp-sponsor #yiv3928452050ygrp-lc {font-family:Arial;}#yiv3928452050 #yiv3928452050ygrp-sponsor #yiv3928452050ygrp-lc #yiv3928452050hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3928452050 #yiv3928452050ygrp-sponsor #yiv3928452050ygrp-lc .yiv3928452050ad {margin-bottom:10px;padding:0 0;}#yiv3928452050 #yiv3928452050actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3928452050 #yiv3928452050activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3928452050 #yiv3928452050activity span {font-weight:700;}#yiv3928452050 #yiv3928452050activity span:first-child {text-transform:uppercase;}#yiv3928452050 #yiv3928452050activity span a {color:#5085b6;text-decoration:none;}#yiv3928452050 #yiv3928452050activity span span {color:#ff7900;}#yiv3928452050 #yiv3928452050activity span .yiv3928452050underline {text-decoration:underline;}#yiv3928452050 .yiv3928452050attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3928452050 .yiv3928452050attach div a {text-decoration:none;}#yiv3928452050 .yiv3928452050attach img {border:none;padding-right:5px;}#yiv3928452050 .yiv3928452050attach label {display:block;margin-bottom:5px;}#yiv3928452050 .yiv3928452050attach label a {text-decoration:none;}#yiv3928452050 blockquote {margin:0 0 0 4px;}#yiv3928452050 .yiv3928452050bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3928452050 .yiv3928452050bold a {text-decoration:none;}#yiv3928452050 dd.yiv3928452050last p a {font-family:Verdana;font-weight:700;}#yiv3928452050 dd.yiv3928452050last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3928452050 dd.yiv3928452050last p span.yiv3928452050yshortcuts {margin-right:0;}#yiv3928452050 div.yiv3928452050attach-table div div a {text-decoration:none;}#yiv3928452050 div.yiv3928452050attach-table {width:400px;}#yiv3928452050 div.yiv3928452050file-title a, #yiv3928452050 div.yiv3928452050file-title a:active, #yiv3928452050 div.yiv3928452050file-title a:hover, #yiv3928452050 div.yiv3928452050file-title a:visited {text-decoration:none;}#yiv3928452050 div.yiv3928452050photo-title a, #yiv3928452050 div.yiv3928452050photo-title a:active, #yiv3928452050 div.yiv3928452050photo-title a:hover, #yiv3928452050 div.yiv3928452050photo-title a:visited {text-decoration:none;}#yiv3928452050 div#yiv3928452050ygrp-mlmsg #yiv3928452050ygrp-msg p a span.yiv3928452050yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3928452050 .yiv3928452050green {color:#628c2a;}#yiv3928452050 .yiv3928452050MsoNormal {margin:0 0 0 0;}#yiv3928452050 o {font-size:0;}#yiv3928452050 #yiv3928452050photos div {float:left;width:72px;}#yiv3928452050 #yiv3928452050photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv3928452050 #yiv3928452050photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3928452050 #yiv3928452050reco-category {font-size:77%;}#yiv3928452050 #yiv3928452050reco-desc {font-size:77%;}#yiv3928452050 .yiv3928452050replbq {margin:4px;}#yiv3928452050 #yiv3928452050ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3928452050 #yiv3928452050ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3928452050 #yiv3928452050ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3928452050 #yiv3928452050ygrp-mlmsg select, #yiv3928452050 input, #yiv3928452050 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3928452050 #yiv3928452050ygrp-mlmsg pre, #yiv3928452050 code {font:115% monospace;}#yiv3928452050 #yiv3928452050ygrp-mlmsg * {line-height:1.22em;}#yiv3928452050 #yiv3928452050ygrp-mlmsg #yiv3928452050logo {padding-bottom:10px;}#yiv3928452050 #yiv3928452050ygrp-msg p a {font-family:Verdana;}#yiv3928452050 #yiv3928452050ygrp-msg p#yiv3928452050attach-count span {color:#1E66AE;font-weight:700;}#yiv3928452050 #yiv3928452050ygrp-reco #yiv3928452050reco-head {color:#ff7900;font-weight:700;}#yiv3928452050 #yiv3928452050ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3928452050 #yiv3928452050ygrp-sponsor #yiv3928452050ov li a {font-size:130%;text-decoration:none;}#yiv3928452050 #yiv3928452050ygrp-sponsor #yiv3928452050ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3928452050 #yiv3928452050ygrp-sponsor #yiv3928452050ov ul {margin:0;padding:0 0 0 8px;}#yiv3928452050 #yiv3928452050ygrp-text {font-family:Georgia;}#yiv3928452050 #yiv3928452050ygrp-text p {margin:0 0 1em 0;}#yiv3928452050 #yiv3928452050ygrp-text tt {font-size:120%;}#yiv3928452050 #yiv3928452050ygrp-vital ul li:last-child {border-right:none !important;}#yiv3928452050
Thanks again!
Sent from Yahoo Mail for iPhone
On Monday, June 12, 2017, 3:30 PM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
I just cut and pasted your formula here and I got data back. Try exiting and restarting EXCEL, and trying it again. And if it still doesn't work, check the version of the add-in, with:
=RCHGetElementNumbe
On Mon, Jun 12, 2017 at 11:15 AM, Madhu Khemani madhu_98@... wrote:
Randy, I'm just starting off with your tools, and I've loaded the beta files correctly, and gotten things to work. However, inputting =smfGetYahooHistory
Thanks in advance for your help and patience!
#yiv3928452050 #yiv3928452050 -- #yiv3928452050ygrp-
Mon Jun 12, 2017 7:17 am (PDT) . Posted by:
msimmsx
Wow Randy..thanks so much. It's been a blizzard of changes with Yahoo...
No surprise there !!
No surprise there !!
Mon Jun 12, 2017 5:58 pm (PDT) . Posted by:
lutherkinchen
I set up an excel spreadsheet to pull in a 6month daily, 2yr weekly and 10yr monthly chart. I have a subscription to Stockcharts.com but the 10Yr Monthly chart will not pull in correctly. It will pull in 10Yrs of data, but the OpenHighLowClose bars in the chart reflecting Daily bars and not monthly bars.
Here are my formulas for each. The Daily and Weekly work correctly, but the monthly just will default back to daily bars.
When I copy the formula of the Daily and Weekly Chart to the next row, in my spreadsheet, the new symbols and pull in the daily and weekly chart perfect.
I just cannot seem to figure out what I'm doing wrong with the Monthly Chart. Here are my formulas.
6-month Daily =RCHCreateComment("http://stockcharts.com/c-sc/sc?s="&A124&"&p=D&yr=0&mn=6&dy=0&id=p13134626187&a=510131038&r=1488426797628",99,,,)
2-year Weekly =RCHCreateComment("http://stockcharts.com/c-sc/sc?s="&A124&"&p=W&yr=2&mn=0&dy=0&id=p73277972368&a=504870090&r=1486502422475",99,,,)
10-year Monthly =RCHCreateComment("http://stockcharts.com/c-sc/sc?s="&A124&"&p=M&yr=10&mn=0&dy=0&i=p36716490093&a=528958528&r=1497238911396",99,,,)
Any ideas or advice on what I'm missing would be greatly appreciated.
Luther
Here are my formulas for each. The Daily and Weekly work correctly, but the monthly just will default back to daily bars.
When I copy the formula of the Daily and Weekly Chart to the next row, in my spreadsheet, the new symbols and pull in the daily and weekly chart perfect.
I just cannot seem to figure out what I'm doing wrong with the Monthly Chart. Here are my formulas.
6-month Daily =RCHCreateComment("http://stockcharts.com/c-sc/sc?s="&A124&"&p=D&yr=0&mn=6&dy=0&id=p13134626187&a=510131038&r=1488426797628",99,,,)
2-year Weekly =RCHCreateComment("http://stockcharts.com/c-sc/sc?s="&A124&"&p=W&yr=2&mn=0&dy=0&id=p73277972368&a=504870090&r=1486502422475",99,,,)
10-year Monthly =RCHCreateComment("http://stockcharts.com/c-sc/sc?s="&A124&"
Any ideas or advice on what I'm missing would be greatly appreciated.
Luther
Mon Jun 12, 2017 6:49 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You probably need to log into stockcharts.com with the EXCEL Web Query
dialog (keyboard shortcut alt+d+d+w). That creates a security cookie that
EXCEL and the add-in can use when pulling the chart/data in.
You can try entering the image URLs in the EXCEL Web Query dialog object,
to see if they will display there. I can't even get them to display here
from a browser (I get "site can't be reached"), so I'm assuming they have
something in them that requires a login.
On Mon, Jun 12, 2017 at 5:58 PM, lutherkinchen@
...
wrote:
>
> I set up an excel spreadsheet to pull in a 6month daily, 2yr weekly and
> 10yr monthly chart.
> I have a subscription to Stockcharts.com but the 10Yr Monthly chart will
> not pull in correctly. It will pull in 10Yrs of data, but the
> OpenHighLowClose bars in the chart reflecting Daily bars and not monthly
> bars.
>
> Here are my formulas for each. The Daily and Weekly work correctly, but
> the monthly just will default back to daily bars.
> When I copy the formula of the Daily and Weekly Chart to the next row, in
> my spreadsheet, the new symbols and pull in the daily and weekly chart
> perfect.
>
> I just cannot seem to figure out what I'm doing wrong with the Monthly
> Chart. Here are my formulas.
>
> 6-month Daily =RCHCreateComment("
>
> http://stockcharts.com/c-sc/sc?s="&A124&"&p=D&yr=0&mn=6&
> dy=0&id=p13134626187&a=510131038&r=1488426797628",99,,,)
>
> 2-year Weekly =RCHCreateComment("http://stockcharts.com/c-sc/sc?s="&A124&"
> &p=W&yr=2&mn=0&dy=0&id=p73277972368&a=504870090&r=1486502422475",99,,,)
>
> 10-year Monthly =RCHCreateComment("
>
> http://stockcharts.com/c-sc/sc?s="&A124&"&p=M&yr=10&mn=0&dy=
> 0&i=p36716490093&a=528958528&r=1497238911396",99,,,)
>
> Any ideas or advice on what I'm missing would be greatly appreciated.
>
>
dialog (keyboard shortcut alt+d+d+w). That creates a security cookie that
EXCEL and the add-in can use when pulling the chart/data in.
You can try entering the image URLs in the EXCEL Web Query dialog object,
to see if they will display there. I can't even get them to display here
from a browser (I get "site can't be reached"), so I'm assuming they have
something in them that requires a login.
On Mon, Jun 12, 2017 at 5:58 PM, lutherkinchen@
...
wrote:
>
> I set up an excel spreadsheet to pull in a 6month daily, 2yr weekly and
> 10yr monthly chart.
> I have a subscription to Stockcharts.com but the 10Yr Monthly chart will
> not pull in correctly. It will pull in 10Yrs of data, but the
> OpenHighLowClose bars in the chart reflecting Daily bars and not monthly
> bars.
>
> Here are my formulas for each. The Daily and Weekly work correctly, but
> the monthly just will default back to daily bars.
> When I copy the formula of the Daily and Weekly Chart to the next row, in
> my spreadsheet, the new symbols and pull in the daily and weekly chart
> perfect.
>
> I just cannot seem to figure out what I'm doing wrong with the Monthly
> Chart. Here are my formulas.
>
> 6-month Daily =RCHCreateComment("
>
> http://stockcharts.com/c-sc/sc?s="&A124&"&p=D&yr=0&mn=6&
> dy=0&id=p13134626187&a=510131038&r=1488426797628",99,,,)
>
> 2-year Weekly =RCHCreateComment("http://stockcharts.com/c-sc/sc?s="&A124&"
> &p=W&yr=2&mn=0&dy=0&id=p73277972368&a=504870090&r=1486502422475",99,,,)
>
> 10-year Monthly =RCHCreateComment("
>
> http://stockcharts.com/c-sc/sc?s="&A124&"
> 0&i=p36716490093&a=
>
> Any ideas or advice on what I'm missing would be greatly appreciated.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar