8 Messages
Digest #4289
1b
Re: Using GetYahooPortfolioView for a handful of Stocks and one stoc by "Randy Harmelink" rharmelink
Messages
Thu Jan 11, 2018 8:10 pm (PST) . Posted by:
"Linda K" lk1_2000
Thank you for your response. I figured it out. It was kind of dumb.
In response to your question about what happened when I put SO in the first ticker spots: I got the double dashes no matter where I put it. But I could put in other symbols into the same slot and get good numbers. Then I happened to try another symbol from my list in that slot, and I also got double dashes. Now I had TWO rows of double dashes. Hmmm...
Then I realized I actually had another sheet that had good quotes for SO .... HMMMM.
Then I realized SO was ALREADY on the list, just higher up! Duh, I forgot about it! I added 9 more ticker symbols, but I forgot SO was already on the list way toward the top.
So that must be the issue! When you put in a ticker that you ALREADY have in the list, apparently you get double dashes. Problem solved!
By the way, the version:
Stock Market Functions add-in, Version 2.1.2017.11.11 (C:\SMF Add-In; Windows (32-bit) NT 6.01; 11.0; ; ; 1)
Thank you,Linda
On Wednesday, January 10, 2018 8:12 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
That's not much information to work with.... :(
I just opened up the template and entered the SO ticker symbol, and it is working fine. So it's not an issue with the ticker symbol.
What happens if you change the first ticker symbols in the list to be SO?
What do you get with:
=RCHGetElementNumber("Version")
On Wed, Jan 10, 2018 at 3:46 PM, lk1_2000@... wrote:
Hi, I'm using a "Master" list of mutual funds and stocks built with GetYahooPortfolioView in an Excel 2003 spreadsheet (Windows 7, 64). I added 9 stocks to my list today, and everything is working smoothly except ONE stock, Southern Company (SO) - nothing but the dreaded double dashes for the fields below. Using = smfGetYahooPortfolioView(B4: B38,C2:G2,,1)
Any ideas? Is it just a SO thing for today, or is there something wrong?
| 15 | 78 | 79 | 17 | 52 |
| Last Price | Last Traded Date | Last Traded Time | Change | % Chg |
#yiv1804794219 -- #yiv1804794219ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1804794219 #yiv1804794219ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1804794219 #yiv1804794219ygrp-mkp #yiv1804794219hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1804794219 #yiv1804794219ygrp-mkp #yiv1804794219ads {margin-bottom:10px;}#yiv1804794219 #yiv1804794219ygrp-mkp .yiv1804794219ad {padding:0 0;}#yiv1804794219 #yiv1804794219ygrp-mkp .yiv1804794219ad p {margin:0;}#yiv1804794219 #yiv1804794219ygrp-mkp .yiv1804794219ad a {color:#0000ff;text-decoration:none;}#yiv1804794219 #yiv1804794219ygrp-sponsor #yiv1804794219ygrp-lc {font-family:Arial;}#yiv1804794219 #yiv1804794219ygrp-sponsor #yiv1804794219ygrp-lc #yiv1804794219hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1804794219 #yiv1804794219ygrp-sponsor #yiv1804794219ygrp-lc .yiv1804794219ad {margin-bottom:10px;padding:0 0;}#yiv1804794219 #yiv1804794219actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1804794219 #yiv1804794219activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1804794219 #yiv1804794219activity span {font-weight:700;}#yiv1804794219 #yiv1804794219activity span:first-child {text-transform:uppercase;}#yiv1804794219 #yiv1804794219activity span a {color:#5085b6;text-decoration:none;}#yiv1804794219 #yiv1804794219activity span span {color:#ff7900;}#yiv1804794219 #yiv1804794219activity span .yiv1804794219underline {text-decoration:underline;}#yiv1804794219 .yiv1804794219attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1804794219 .yiv1804794219attach div a {text-decoration:none;}#yiv1804794219 .yiv1804794219attach img {border:none;padding-right:5px;}#yiv1804794219 .yiv1804794219attach label {display:block;margin-bottom:5px;}#yiv1804794219 .yiv1804794219attach label a {text-decoration:none;}#yiv1804794219 blockquote {margin:0 0 0 4px;}#yiv1804794219 .yiv1804794219bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1804794219 .yiv1804794219bold a {text-decoration:none;}#yiv1804794219 dd.yiv1804794219last p a {font-family:Verdana;font-weight:700;}#yiv1804794219 dd.yiv1804794219last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1804794219 dd.yiv1804794219last p span.yiv1804794219yshortcuts {margin-right:0;}#yiv1804794219 div.yiv1804794219attach-table div div a {text-decoration:none;}#yiv1804794219 div.yiv1804794219attach-table {width:400px;}#yiv1804794219 div.yiv1804794219file-title a, #yiv1804794219 div.yiv1804794219file-title a:active, #yiv1804794219 div.yiv1804794219file-title a:hover, #yiv1804794219 div.yiv1804794219file-title a:visited {text-decoration:none;}#yiv1804794219 div.yiv1804794219photo-title a, #yiv1804794219 div.yiv1804794219photo-title a:active, #yiv1804794219 div.yiv1804794219photo-title a:hover, #yiv1804794219 div.yiv1804794219photo-title a:visited {text-decoration:none;}#yiv1804794219 div#yiv1804794219ygrp-mlmsg #yiv1804794219ygrp-msg p a span.yiv1804794219yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1804794219 .yiv1804794219green {color:#628c2a;}#yiv1804794219 .yiv1804794219MsoNormal {margin:0 0 0 0;}#yiv1804794219 o {font-size:0;}#yiv1804794219 #yiv1804794219photos div {float:left;width:72px;}#yiv1804794219 #yiv1804794219photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv1804794219 #yiv1804794219photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1804794219 #yiv1804794219reco-category {font-size:77%;}#yiv1804794219 #yiv1804794219reco-desc {font-size:77%;}#yiv1804794219 .yiv1804794219replbq {margin:4px;}#yiv1804794219 #yiv1804794219ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1804794219 #yiv1804794219ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1804794219 #yiv1804794219ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1804794219 #yiv1804794219ygrp-mlmsg select, #yiv1804794219 input, #yiv1804794219 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1804794219 #yiv1804794219ygrp-mlmsg pre, #yiv1804794219 code {font:115% monospace;}#yiv1804794219 #yiv1804794219ygrp-mlmsg * {line-height:1.22em;}#yiv1804794219 #yiv1804794219ygrp-mlmsg #yiv1804794219logo {padding-bottom:10px;}#yiv1804794219 #yiv1804794219ygrp-msg p a {font-family:Verdana;}#yiv1804794219 #yiv1804794219ygrp-msg p#yiv1804794219attach-count span {color:#1E66AE;font-weight:700;}#yiv1804794219 #yiv1804794219ygrp-reco #yiv1804794219reco-head {color:#ff7900;font-weight:700;}#yiv1804794219 #yiv1804794219ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1804794219 #yiv1804794219ygrp-sponsor #yiv1804794219ov li a {font-size:130%;text-decoration:none;}#yiv1804794219 #yiv1804794219ygrp-sponsor #yiv1804794219ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1804794219 #yiv1804794219ygrp-sponsor #yiv1804794219ov ul {margin:0;padding:0 0 0 8px;}#yiv1804794219 #yiv1804794219ygrp-text {font-family:Georgia;}#yiv1804794219 #yiv1804794219ygrp-text p {margin:0 0 1em 0;}#yiv1804794219 #yiv1804794219ygrp-text tt {font-size:120%;}#yiv1804794219 #yiv1804794219ygrp-vital ul li:last-child {border-right:none !important;}#yiv1804794219
In response to your question about what happened when I put SO in the first ticker spots: I got the double dashes no matter where I put it. But I could put in other symbols into the same slot and get good numbers. Then I happened to try another symbol from my list in that slot, and I also got double dashes. Now I had TWO rows of double dashes. Hmmm...
Then I realized I actually had another sheet that had good quotes for SO .... HMMMM.
Then I realized SO was ALREADY on the list, just higher up! Duh, I forgot about it! I added 9 more ticker symbols, but I forgot SO was already on the list way toward the top.
So that must be the issue! When you put in a ticker that you ALREADY have in the list, apparently you get double dashes. Problem solved!
By the way, the version:
Stock Market Functions add-in, Version 2.1.2017.11.11 (C:\SMF Add-In; Windows (32-bit) NT 6.01; 11.0; ; ; 1)
Thank you,Linda
On Wednesday, January 10, 2018 8:12 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
That's not much information to work with.... :(
I just opened up the template and entered the SO ticker symbol, and it is working fine. So it's not an issue with the ticker symbol.
What happens if you change the first ticker symbols in the list to be SO?
What do you get with:
=RCHGetElementNumbe
On Wed, Jan 10, 2018 at 3:46 PM, lk1_2000@... wrote:
Hi, I'm using a "Master" list of mutual funds and stocks built with GetYahooPortfolioVi
Any ideas? Is it just a SO thing for today, or is there something wrong?
| 15 | 78 | 79 | 17 | 52 |
| Last Price | Last Traded Date | Last Traded Time | Change | % Chg |
#yiv1804794219 -- #yiv1804794219ygrp-
Fri Jan 12, 2018 12:16 am (PST) . Posted by:
"Randy Harmelink" rharmelink
With the most recent release if you set the third parameter of
smfGetYahooPortfolioView() to "Y", it should populate duplicate symbols. It
does require a bit of additional processing though.
On Thu, Jan 11, 2018 at 9:06 PM, Linda K lk1_2000@
...
wrote:
>
> Thank you for your response. I figured it out. It was kind of dumb.
>
> In response to your question about what happened when I put SO in the
> first ticker spots: I got the double dashes no matter where I put it. But I
> could put in other symbols into the same slot and get good numbers. Then I
> happened to try another symbol from my list in that slot, and I also got
> double dashes. Now I had TWO rows of double dashes. Hmmm...
>
> Then I realized I actually had another sheet that had good quotes for SO
> ... HMMMM.
>
> Then I realized SO was ALREADY on the list, just higher up! Duh, I forgot
> about it! I added 9 more ticker symbols, but I forgot SO was already on the
> list way toward the top.
>
> So that must be the issue! When you put in a ticker that you ALREADY have
> in the list, apparently you get double dashes. Problem solved!
>
> By the way, the version:
>
> Stock Market Functions add-in, Version 2.1.2017.11.11 (C:\SMF Add-In;
> Windows (32-bit) NT 6.01; 11.0; ; ; 1)
>
>
>
smfGetYahooPortfoli
does require a bit of additional processing though.
On Thu, Jan 11, 2018 at 9:06 PM, Linda K lk1_2000@
...
wrote:
>
> Thank you for your response. I figured it out. It was kind of dumb.
>
> In response to your question about what happened when I put SO in the
> first ticker spots: I got the double dashes no matter where I put it. But I
> could put in other symbols into the same slot and get good numbers. Then I
> happened to try another symbol from my list in that slot, and I also got
> double dashes. Now I had TWO rows of double dashes. Hmmm...
>
> Then I realized I actually had another sheet that had good quotes for SO
> ... HMMMM.
>
> Then I realized SO was ALREADY on the list, just higher up! Duh, I forgot
> about it! I added 9 more ticker symbols, but I forgot SO was already on the
> list way toward the top.
>
> So that must be the issue! When you put in a ticker that you ALREADY have
> in the list, apparently you get double dashes. Problem solved!
>
> By the way, the version:
>
> Stock Market Functions add-in, Version 2.1.2017.11.
> Windows (32-bit) NT 6.01; 11.0; ; ; 1)
>
>
>
Fri Jan 12, 2018 9:51 am (PST) . Posted by:
"Linda K" lk1_2000
That's good to know, thank you Randy.
On Friday, January 12, 2018 3:19 AM, "Randy Harmelink rharmelink@gmail..com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
With the most recent release if you set the third parameter of smfGetYahooPortfolioView() to "Y", it should populate duplicate symbols. It does require a bit of additional processing though.
On Thu, Jan 11, 2018 at 9:06 PM, Linda K lk1_2000@... wrote:
Thank you for your response. I figured it out. It was kind of dumb.
In response to your question about what happened when I put SO in the first ticker spots: I got the double dashes no matter where I put it. But I could put in other symbols into the same slot and get good numbers. Then I happened to try another symbol from my list in that slot, and I also got double dashes. Now I had TWO rows of double dashes. Hmmm...
Then I realized I actually had another sheet that had good quotes for SO .... HMMMM.
Then I realized SO was ALREADY on the list, just higher up! Duh, I forgot about it! I added 9 more ticker symbols, but I forgot SO was already on the list way toward the top.
So that must be the issue! When you put in a ticker that you ALREADY have in the list, apparently you get double dashes. Problem solved!
By the way, the version:
Stock Market Functions add-in, Version 2.1.2017.11.11 (C:\SMF Add-In; Windows (32-bit) NT 6.01; 11.0; ; ; 1)
#yiv2485910868 #yiv2485910868 -- #yiv2485910868ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2485910868 #yiv2485910868ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2485910868 #yiv2485910868ygrp-mkp #yiv2485910868hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2485910868 #yiv2485910868ygrp-mkp #yiv2485910868ads {margin-bottom:10px;}#yiv2485910868 #yiv2485910868ygrp-mkp .yiv2485910868ad {padding:0 0;}#yiv2485910868 #yiv2485910868ygrp-mkp .yiv2485910868ad p {margin:0;}#yiv2485910868 #yiv2485910868ygrp-mkp .yiv2485910868ad a {color:#0000ff;text-decoration:none;}#yiv2485910868 #yiv2485910868ygrp-sponsor #yiv2485910868ygrp-lc {font-family:Arial;}#yiv2485910868 #yiv2485910868ygrp-sponsor #yiv2485910868ygrp-lc #yiv2485910868hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2485910868 #yiv2485910868ygrp-sponsor #yiv2485910868ygrp-lc .yiv2485910868ad {margin-bottom:10px;padding:0 0;}#yiv2485910868 #yiv2485910868actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2485910868 #yiv2485910868activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2485910868 #yiv2485910868activity span {font-weight:700;}#yiv2485910868 #yiv2485910868activity span:first-child {text-transform:uppercase;}#yiv2485910868 #yiv2485910868activity span a {color:#5085b6;text-decoration:none;}#yiv2485910868 #yiv2485910868activity span span {color:#ff7900;}#yiv2485910868 #yiv2485910868activity span .yiv2485910868underline {text-decoration:underline;}#yiv2485910868 .yiv2485910868attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2485910868 .yiv2485910868attach div a {text-decoration:none;}#yiv2485910868 .yiv2485910868attach img {border:none;padding-right:5px;}#yiv2485910868 .yiv2485910868attach label {display:block;margin-bottom:5px;}#yiv2485910868 .yiv2485910868attach label a {text-decoration:none;}#yiv2485910868 blockquote {margin:0 0 0 4px;}#yiv2485910868 .yiv2485910868bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2485910868 .yiv2485910868bold a {text-decoration:none;}#yiv2485910868 dd.yiv2485910868last p a {font-family:Verdana;font-weight:700;}#yiv2485910868 dd.yiv2485910868last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2485910868 dd.yiv2485910868last p span.yiv2485910868yshortcuts {margin-right:0;}#yiv2485910868 div.yiv2485910868attach-table div div a {text-decoration:none;}#yiv2485910868 div.yiv2485910868attach-table {width:400px;}#yiv2485910868 div.yiv2485910868file-title a, #yiv2485910868 div.yiv2485910868file-title a:active, #yiv2485910868 div.yiv2485910868file-title a:hover, #yiv2485910868 div.yiv2485910868file-title a:visited {text-decoration:none;}#yiv2485910868 div.yiv2485910868photo-title a, #yiv2485910868 div.yiv2485910868photo-title a:active, #yiv2485910868 div.yiv2485910868photo-title a:hover, #yiv2485910868 div.yiv2485910868photo-title a:visited {text-decoration:none;}#yiv2485910868 div#yiv2485910868ygrp-mlmsg #yiv2485910868ygrp-msg p a span.yiv2485910868yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2485910868 .yiv2485910868green {color:#628c2a;}#yiv2485910868 .yiv2485910868MsoNormal {margin:0 0 0 0;}#yiv2485910868 o {font-size:0;}#yiv2485910868 #yiv2485910868photos div {float:left;width:72px;}#yiv2485910868 #yiv2485910868photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2485910868 #yiv2485910868photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2485910868 #yiv2485910868reco-category {font-size:77%;}#yiv2485910868 #yiv2485910868reco-desc {font-size:77%;}#yiv2485910868 .yiv2485910868replbq {margin:4px;}#yiv2485910868 #yiv2485910868ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2485910868 #yiv2485910868ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2485910868 #yiv2485910868ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2485910868 #yiv2485910868ygrp-mlmsg select, #yiv2485910868 input, #yiv2485910868 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2485910868 #yiv2485910868ygrp-mlmsg pre, #yiv2485910868 code {font:115% monospace;}#yiv2485910868 #yiv2485910868ygrp-mlmsg * {line-height:1.22em;}#yiv2485910868 #yiv2485910868ygrp-mlmsg #yiv2485910868logo {padding-bottom:10px;}#yiv2485910868 #yiv2485910868ygrp-msg p a {font-family:Verdana;}#yiv2485910868 #yiv2485910868ygrp-msg p#yiv2485910868attach-count span {color:#1E66AE;font-weight:700;}#yiv2485910868 #yiv2485910868ygrp-reco #yiv2485910868reco-head {color:#ff7900;font-weight:700;}#yiv2485910868 #yiv2485910868ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2485910868 #yiv2485910868ygrp-sponsor #yiv2485910868ov li a {font-size:130%;text-decoration:none;}#yiv2485910868 #yiv2485910868ygrp-sponsor #yiv2485910868ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2485910868 #yiv2485910868ygrp-sponsor #yiv2485910868ov ul {margin:0;padding:0 0 0 8px;}#yiv2485910868 #yiv2485910868ygrp-text {font-family:Georgia;}#yiv2485910868 #yiv2485910868ygrp-text p {margin:0 0 1em 0;}#yiv2485910868 #yiv2485910868ygrp-text tt {font-size:120%;}#yiv2485910868 #yiv2485910868ygrp-vital ul li:last-child {border-right:none !important;}#yiv2485910868
On Friday, January 12, 2018 3:19 AM, "Randy Harmelink rharmelink@gmail..com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
With the most recent release if you set the third parameter of smfGetYahooPortfoli
On Thu, Jan 11, 2018 at 9:06 PM, Linda K lk1_2000@... wrote:
Thank you for your response. I figured it out. It was kind of dumb.
In response to your question about what happened when I put SO in the first ticker spots: I got the double dashes no matter where I put it. But I could put in other symbols into the same slot and get good numbers. Then I happened to try another symbol from my list in that slot, and I also got double dashes. Now I had TWO rows of double dashes. Hmmm...
Then I realized I actually had another sheet that had good quotes for SO .... HMMMM.
Then I realized SO was ALREADY on the list, just higher up! Duh, I forgot about it! I added 9 more ticker symbols, but I forgot SO was already on the list way toward the top.
So that must be the issue! When you put in a ticker that you ALREADY have in the list, apparently you get double dashes. Problem solved!
By the way, the version:
Stock Market Functions add-in, Version 2.1.2017.11.
#yiv2485910868 #yiv2485910868 -- #yiv2485910868ygrp-
Thu Jan 11, 2018 8:24 pm (PST) . Posted by:
peterebali
In the last couple of weeks, I have noticed a drastic slowdown when I update my data using smfGetYahooPortfolioView. I had cleaned up my spreadsheet when I converted to smfGetYahooPortfolioView and have only one array function to pull down all of my data in one go. I noted a distinct improvement in updates when I did that.
I have an older i7-2600 Intel chip and I am suspecting the recent patches, described in the attached article could be what has impacted the update speed. I may have to consider updating my computer.
https://en.softonic.com/articles/the-spectre-and-meltdown-security-updates-will-slow-down-your-windows-pc?utm_medium=push&utm_source=softonic&utm_campaign=cbb614cb-b4a4-4aeb-85ec-6365956ef55b&utm_content= https://en.softonic.com/articles/the-spectre-and-meltdown-security-updates-will-slow-down-your-windows-pc?utm_medium=push&utm_source=softonic&utm_campaign=cbb614cb-b4a4-4aeb-85ec-6365956ef55b&utm_content=
Has anybody else noticed a slowing down of the updates recently? It appears the slowdown is related to internet activity which is what the smf-addin is all about.
Regards... Peter
I have an older i7-2600 Intel chip and I am suspecting the recent patches, described in the attached article could be what has impacted the update speed. I may have to consider updating my computer.
https://en.softonic.com/articles/the-spectre-and-meltdown-security-updates-will-slow-down-your-windows-pc?utm_medium=push&utm_source=softonic&utm_campaign=cbb614cb-b4a4-4aeb-85ec-6365956ef55b&utm_content= https://en.softonic.com/articles/the-spectre-and-meltdown-security-updates-will-slow-down-your-windows-pc?utm_medium=push&utm_source=softonic&utm_campaign=cbb614cb-b4a4-4aeb-85ec-6365956ef55b&utm_content=
Has anybody else noticed a slowing down of the updates recently? It appears the slowdown is related to internet activity which is what the smf-addin is all about.
Regards... Peter
Fri Jan 12, 2018 12:29 pm (PST) . Posted by:
doghandler978
I've also noticed slower response but don't have and idea of how long things should take. Using portfolioview with 1 table on 1 year old computer. I tested response to do various sizes of downloads. Example: 35 seconds to download a 200 stock list.
I disabled smf-add-in to test without downloads, and the excel sheet loads in about 2 seconds so the slowness appears to be associated with download functions. Maybe its just a bandwidth issue?
I disabled smf-add-in to test without downloads, and the excel sheet loads in about 2 seconds so the slowness appears to be associated with download functions. Maybe its just a bandwidth issue?
Fri Jan 12, 2018 12:54 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Here's what I just did:
1. Opened the template from the web site.
2. Put these formulas in the workbook:
B1: =NOW()
C1: =NOW()+0*D4
D1: =(C1-B1)*86400
3. Re-entered the array-entered formula as:
=smfGetYahooPortfolioView($B$4:$B$411,$C$2:$AJ$2,,1+0*B1)
4. Copied the S&P 500 stock ticker symbols (as values) starting in cell B4
(gives the function 408 tickers to process)
5. Ran smfForceRecalculation
6. Checked my add-in log file
The value in cell D1 says there were 1.63 seconds elapsed from start to
finish. The log tells me it took 0.48 seconds to retrieve the web page.
This is on my "slow" computer, a new desktop I got last May. :)
First thing you should do is check the log (see
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/34208)..
It can tell you how long it took to get the data for
smfGetYahooPortfolioView(), as well as whether other data retrievals
occurred around the same time.
But elapsed time will be a combination of retrieval time, CPU speed, amount
of RAM, as well as the version of EXCEL and the operating system. Even
other things running at the same time. But 35 seconds seems like an awful
long time for something that is next to trivial here.
On Fri, Jan 12, 2018 at 12:59 PM, doghandler978@
...
wrote:
>
> I've also noticed slower response but don't have and idea of how long
> things should take. Using portfolioview with 1 table on 1 year old
> computer. I tested response to do various sizes of downloads. Example: 35
> seconds to download a 200 stock list.
>
> I disabled smf-add-in to test without downloads, and the excel sheet loads
> in about 2 seconds so the slowness appears to be associated with download
> functions. Maybe its just a bandwidth issue?
>
1. Opened the template from the web site.
2. Put these formulas in the workbook:
B1: =NOW()
C1: =NOW()+0*D4
D1: =(C1-B1)*86400
3. Re-entered the array-entered formula as:
=smfGetYahooPortfolioView($B$4:$B$411,$C$2:$AJ$2,,1+0*B1)
4. Copied the S&P 500 stock ticker symbols (as values) starting in cell B4
(gives the function 408 tickers to process)
5. Ran smfForceRecalculation
6. Checked my add-in log file
The value in cell D1 says there were 1.63 seconds elapsed from start to
finish. The log tells me it took 0.48 seconds to retrieve the web page.
This is on my "slow" computer, a new desktop I got last May. :)
First thing you should do is check the log (see
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/34208)..
It can tell you how long it took to get the data for
smfGetYahooPortfoli
occurred around the same time.
But elapsed time will be a combination of retrieval time, CPU speed, amount
of RAM, as well as the version of EXCEL and the operating system. Even
other things running at the same time. But 35 seconds seems like an awful
long time for something that is next to trivial here.
On Fri, Jan 12, 2018 at 12:59 PM, doghandler978@
...
wrote:
>
> I've also noticed slower response but don't have and idea of how long
> things should take. Using portfolioview with 1 table on 1 year old
> computer. I tested response to do various sizes of downloads. Example: 35
> seconds to download a 200 stock list.
>
> I disabled smf-add-in to test without downloads, and the excel sheet loads
> in about 2 seconds so the slowness appears to be associated with download
> functions. Maybe its just a bandwidth issue?
>
Thu Jan 11, 2018 9:52 pm (PST) . Posted by:
rimanda1
Randy,
Back on may 31 2017 I posted a question regarding only getting 5 years data returned from the following function call:
=smfGetCSVFile("http://financials.morningstar.com/ajax/ReportProcess4CSV.html?t=" & A1 & "&reportType=is&period=12&dataType=A&order=asc&columnYear=10&rounding=3&denominatorView=raw")
You responded as follows:
When I cut and pasted your formula, I also only got five years. So I went to the morningstar.com http://morningstar.com/ website using the EXCEL Web Query dialog (alt+d+d+w) and logged in, creating a security cookie. Then I ran the smfForceRecalculation macro, and 10 years + TTM appeared.
Unfortunately, the issue is back, and now, changing pages in Morning Star WEB site using the EXCEL Web Query dialog makes no difference and in addition using the smfforcerecalculation macro no longer brings back the 10 years data.
Can you assist please?
David Gorr
Back on may 31 2017 I posted a question regarding only getting 5 years data returned from the following function call:
=smfGetCSVFile("http://financials.morningstar.com/ajax/ReportProcess4CSV.html?t=" & A1 & "&reportType=is&period=12&dataType=A&order=asc&columnYear=10&rounding=3&denominatorView=raw")
You responded as follows:
When I cut and pasted your formula, I also only got five years. So I went to the morningstar.com http://morningstar.com/ website using the EXCEL Web Query dialog (alt+d+d+w) and logged in, creating a security cookie. Then I ran the smfForceRecalculati
Unfortunately, the issue is back, and now, changing pages in Morning Star WEB site using the EXCEL Web Query dialog makes no difference and in addition using the smfforcerecalculati
Can you assist please?
David Gorr
Fri Jan 12, 2018 12:22 am (PST) . Posted by:
"Randy Harmelink" rharmelink
It's still working here, so I'm not sure what I can do? Are you able to log
in using the EXCEL Web Query dialog?
I am baffled by you comment of, "
changing pages in Morning Star WEB site using the EXCEL Web Query dialog
makes no difference". Changing pages? .
On Thu, Jan 11, 2018 at 10:52 PM, rimanda1@
...
wrote:
> Back on may 31 2017 I posted a question regarding only getting 5 years
> data returned from the following function call:
>
> =smfGetCSVFile("http://financials.morningstar.com/
> ajax/ReportProcess4CSV.html?t=" & A1 & "&reportType=is&period=12&
> dataType=A&order=asc&columnYear=10&rounding=3&denominatorView=raw")
>
> You responded as follows:
>
> When I cut and pasted your formula, I also only got five years. So I went
> to the morningstar.com website using the EXCEL Web Query dialog
> (alt+d+d+w) and logged in, creating a security cookie. Then I ran the
> smfForceRecalculation macro, and 10 years + TTM appeared.
>
> Unfortunately, the issue is back, and now,
>
> changing pages in Morning Star WEB site using the EXCEL Web Query dialog
> makes no difference and in addition using the smfforcerecalculation macro
> no longer brings back the 10 years data.
>
> Can you assist please?
>
>
>
in using the EXCEL Web Query dialog?
I am baffled by you comment of, "
changing pages in Morning Star WEB site using the EXCEL Web Query dialog
makes no difference". Changing pages? .
On Thu, Jan 11, 2018 at 10:52 PM, rimanda1@
...
wrote:
> Back on may 31 2017 I posted a question regarding only getting 5 years
> data returned from the following function call:
>
> =smfGetCSVFile("http://financials.morningstar.com/
> ajax/ReportProcess4
> dataType=A&order=
>
> You responded as follows:
>
> When I cut and pasted your formula, I also only got five years. So I went
> to the morningstar.
> (alt+d+d+w) and logged in, creating a security cookie. Then I ran the
> smfForceRecalculati
>
> Unfortunately, the issue is back, and now,
>
> changing pages in Morning Star WEB site using the EXCEL Web Query dialog
> makes no difference and in addition using the smfforcerecalculati
> no longer brings back the 10 years data.
>
> Can you assist please?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar