9 Messages
Digest #4252
Messages
Thu Nov 30, 2017 4:46 am (PST) . Posted by:
"Peter Rogers" bollux2it
Try: https://finance.google.com/finance/historical?q=
as in:
https://finance.google.com/finance/historical?q=mmm
On Wednesday, November 29, 2017 8:32 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
Google "Finance" look like bare bones right now. About as bare as it can get.
On Wed, Nov 29, 2017 at 6:24 PM, Madhu Khemani madhu_98@... wrote:
Google Historical looks like it's gone now.
#yiv4363688177 #yiv4363688177 -- #yiv4363688177ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4363688177 #yiv4363688177ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4363688177 #yiv4363688177ygrp-mkp #yiv4363688177hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4363688177 #yiv4363688177ygrp-mkp #yiv4363688177ads {margin-bottom:10px;}#yiv4363688177 #yiv4363688177ygrp-mkp .yiv4363688177ad {padding:0 0;}#yiv4363688177 #yiv4363688177ygrp-mkp .yiv4363688177ad p {margin:0;}#yiv4363688177 #yiv4363688177ygrp-mkp .yiv4363688177ad a {color:#0000ff;text-decoration:none;}#yiv4363688177 #yiv4363688177ygrp-sponsor #yiv4363688177ygrp-lc {font-family:Arial;}#yiv4363688177 #yiv4363688177ygrp-sponsor #yiv4363688177ygrp-lc #yiv4363688177hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4363688177 #yiv4363688177ygrp-sponsor #yiv4363688177ygrp-lc .yiv4363688177ad {margin-bottom:10px;padding:0 0;}#yiv4363688177 #yiv4363688177actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4363688177 #yiv4363688177activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4363688177 #yiv4363688177activity span {font-weight:700;}#yiv4363688177 #yiv4363688177activity span:first-child {text-transform:uppercase;}#yiv4363688177 #yiv4363688177activity span a {color:#5085b6;text-decoration:none;}#yiv4363688177 #yiv4363688177activity span span {color:#ff7900;}#yiv4363688177 #yiv4363688177activity span .yiv4363688177underline {text-decoration:underline;}#yiv4363688177 .yiv4363688177attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4363688177 .yiv4363688177attach div a {text-decoration:none;}#yiv4363688177 .yiv4363688177attach img {border:none;padding-right:5px;}#yiv4363688177 .yiv4363688177attach label {display:block;margin-bottom:5px;}#yiv4363688177 .yiv4363688177attach label a {text-decoration:none;}#yiv4363688177 blockquote {margin:0 0 0 4px;}#yiv4363688177 .yiv4363688177bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4363688177 .yiv4363688177bold a {text-decoration:none;}#yiv4363688177 dd.yiv4363688177last p a {font-family:Verdana;font-weight:700;}#yiv4363688177 dd.yiv4363688177last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4363688177 dd.yiv4363688177last p span.yiv4363688177yshortcuts {margin-right:0;}#yiv4363688177 div.yiv4363688177attach-table div div a {text-decoration:none;}#yiv4363688177 div.yiv4363688177attach-table {width:400px;}#yiv4363688177 div.yiv4363688177file-title a, #yiv4363688177 div.yiv4363688177file-title a:active, #yiv4363688177 div.yiv4363688177file-title a:hover, #yiv4363688177 div.yiv4363688177file-title a:visited {text-decoration:none;}#yiv4363688177 div.yiv4363688177photo-title a, #yiv4363688177 div.yiv4363688177photo-title a:active, #yiv4363688177 div.yiv4363688177photo-title a:hover, #yiv4363688177 div.yiv4363688177photo-title a:visited {text-decoration:none;}#yiv4363688177 div#yiv4363688177ygrp-mlmsg #yiv4363688177ygrp-msg p a span.yiv4363688177yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4363688177 .yiv4363688177green {color:#628c2a;}#yiv4363688177 .yiv4363688177MsoNormal {margin:0 0 0 0;}#yiv4363688177 o {font-size:0;}#yiv4363688177 #yiv4363688177photos div {float:left;width:72px;}#yiv4363688177 #yiv4363688177photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv4363688177 #yiv4363688177photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4363688177 #yiv4363688177reco-category {font-size:77%;}#yiv4363688177 #yiv4363688177reco-desc {font-size:77%;}#yiv4363688177 .yiv4363688177replbq {margin:4px;}#yiv4363688177 #yiv4363688177ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4363688177 #yiv4363688177ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4363688177 #yiv4363688177ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4363688177 #yiv4363688177ygrp-mlmsg select, #yiv4363688177 input, #yiv4363688177 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4363688177 #yiv4363688177ygrp-mlmsg pre, #yiv4363688177 code {font:115% monospace;}#yiv4363688177 #yiv4363688177ygrp-mlmsg * {line-height:1.22em;}#yiv4363688177 #yiv4363688177ygrp-mlmsg #yiv4363688177logo {padding-bottom:10px;}#yiv4363688177 #yiv4363688177ygrp-msg p a {font-family:Verdana;}#yiv4363688177 #yiv4363688177ygrp-msg p#yiv4363688177attach-count span {color:#1E66AE;font-weight:700;}#yiv4363688177 #yiv4363688177ygrp-reco #yiv4363688177reco-head {color:#ff7900;font-weight:700;}#yiv4363688177 #yiv4363688177ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4363688177 #yiv4363688177ygrp-sponsor #yiv4363688177ov li a {font-size:130%;text-decoration:none;}#yiv4363688177 #yiv4363688177ygrp-sponsor #yiv4363688177ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4363688177 #yiv4363688177ygrp-sponsor #yiv4363688177ov ul {margin:0;padding:0 0 0 8px;}#yiv4363688177 #yiv4363688177ygrp-text {font-family:Georgia;}#yiv4363688177 #yiv4363688177ygrp-text p {margin:0 0 1em 0;}#yiv4363688177 #yiv4363688177ygrp-text tt {font-size:120%;}#yiv4363688177 #yiv4363688177ygrp-vital ul li:last-child {border-right:none !important;}#yiv4363688177
as in:
https://finance.google.com/finance/historical?q=mmm
On Wednesday, November 29, 2017 8:32 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
Google "Finance" look like bare bones right now. About as bare as it can get.
On Wed, Nov 29, 2017 at 6:24 PM, Madhu Khemani madhu_98@... wrote:
Google Historical looks like it's gone now.
#yiv4363688177 #yiv4363688177 -- #yiv4363688177ygrp-
Thu Nov 30, 2017 4:54 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Ahh. They changed their domain name, and the old URLs were redirecting to a
Google search instead of to Google Finance.
On Thu, Nov 30, 2017 at 5:36 AM, Peter Rogers bollux2it@
...
wrote:
>
> Try: https://finance.google.com/finance/historical?q=
>
> as in:
>
> https://finance.google.com/finance/historical?q=mmm
>
>
>
Google search instead of to Google Finance.
On Thu, Nov 30, 2017 at 5:36 AM, Peter Rogers bollux2it@
...
wrote:
>
> Try: https://finance.google.com/finance/historical?q=
>
> as in:
>
> https://finance.google.com/finance/historical?q=mmm
>
>
>
Thu Nov 30, 2017 5:31 am (PST) . Posted by:
arthuja
Hi Randy,
Thank you for this great project. I am trying to set up automated refresh of the data collected via smfGetYahooPortfolioView.. Can you recommend a way this could be implemented.
I have been trying to call smfForceRecalculation, which works one time only after each use the cell right click SMF menu, after which it runs to completion but fails to update the data.
regards
Justin
Thank you for this great project. I am trying to set up automated refresh of the data collected via smfGetYahooPortfoli
I have been trying to call smfForceRecalculati
regards
Justin
Thu Nov 30, 2017 5:38 am (PST) . Posted by:
"Randy Harmelink" rharmelink
When the market is open, my last traded date and time change each time I
run the smfForceRecalculation macro.
One issue may be if your Internet Options (for IE) aren't set to always get
a fresh copy of a web page. Since the add-in uses the same Microsoft
Internet engine that IE uses, it would use the IE settings. So if your
Internet Options are set to allow the use of cached pages, the add-in
request for a fresh copy of a web page might end up getting the cached
pages returned, resulting in no update of the data.
On Thu, Nov 30, 2017 at 6:28 AM, arthuja@
...
wrote:
>
> Thank you for this great project. I am trying to set up automated refresh
> of the data collected via smfGetYahooPortfolioView.. Can you recommend a
> way this could be implemented.
> I have been trying to call smfForceRecalculation, which works one time
> only after each use the cell right click SMF menu, after which it runs to
> completion but fails to update the data.
>
>
run the smfForceRecalculati
One issue may be if your Internet Options (for IE) aren't set to always get
a fresh copy of a web page. Since the add-in uses the same Microsoft
Internet engine that IE uses, it would use the IE settings. So if your
Internet Options are set to allow the use of cached pages, the add-in
request for a fresh copy of a web page might end up getting the cached
pages returned, resulting in no update of the data.
On Thu, Nov 30, 2017 at 6:28 AM, arthuja@
...
wrote:
>
> Thank you for this great project. I am trying to set up automated refresh
> of the data collected via smfGetYahooPortfoli
> way this could be implemented.
> I have been trying to call smfForceRecalculati
> only after each use the cell right click SMF menu, after which it runs to
> completion but fails to update the data.
>
>
Thu Nov 30, 2017 5:54 am (PST) . Posted by:
arthuja
Thank you for your response.
I saw your suggestion regarding the IE cache settings in another post and changed them accordingly.
My problem may have something to do with the way I am accessing the smfForceRecalculation macro. Initially I tried to call the smfForceRecalculation macro from my own macro, but got an "unknown function" error. I then coppied the content of the smfUtilities_ module and pasted it into a module in my own project. Now it runs but updates correctly only once after time the gui calls the original function in its original location.
I saw your suggestion regarding the IE cache settings in another post and changed them accordingly.
My problem may have something to do with the way I am accessing the smfForceRecalculati
Thu Nov 30, 2017 6:03 am (PST) . Posted by:
"Randy Harmelink" rharmelink
You're probably getting the "unknown function" error because you haven't
set the add-in up as a reference library in your VBA project? You need to
do that for your project to have access to the add-in functions and
subroutines.
If you just copied the one module over, you'll be executing THAT instance
of the function and not the add-in instance of the function. It won't clear
out anything in the add-in's processing of web pages. It's basically just
doing an F9-style recalculate. The whole purpose of the
smfForceRecalculation macro is to have it purge the saved copy of web pages
so that it needs to get a fresh copy. Your instance of the function won't
have access to those saved copies of the web pages.
On Thu, Nov 30, 2017 at 6:54 AM, arthuja@
...
wrote:
>
> I saw your suggestion regarding the IE cache settings in another post and
> changed them accordingly.
>
> My problem may have something to do with the way I am accessing the smfForceRecalculation
> macro. Initially I tried to call the smfForceRecalculation macro from my
> own macro, but got an "unknown function" error. I then coppied the content
> of the smfUtilities_ module and pasted it into a module in my own project.
> Now it runs but updates correctly only once after time the gui calls the
> original function in its original location.
>
set the add-in up as a reference library in your VBA project? You need to
do that for your project to have access to the add-in functions and
subroutines.
If you just copied the one module over, you'll be executing THAT instance
of the function and not the add-in instance of the function. It won't clear
out anything in the add-in's processing of web pages. It's basically just
doing an F9-style recalculate. The whole purpose of the
smfForceRecalculati
so that it needs to get a fresh copy. Your instance of the function won't
have access to those saved copies of the web pages.
On Thu, Nov 30, 2017 at 6:54 AM, arthuja@
...
wrote:
>
> I saw your suggestion regarding the IE cache settings in another post and
> changed them accordingly.
>
> My problem may have something to do with the way I am accessing the smfForceRecalculati
> macro. Initially I tried to call the smfForceRecalculati
> own macro, but got an "unknown function" error. I then coppied the content
> of the smfUtilities_ module and pasted it into a module in my own project.
> Now it runs but updates correctly only once after time the gui calls the
> original function in its original location.
>
Thu Nov 30, 2017 6:57 am (PST) . Posted by:
arthuja
Problem fixed. Thank you I really appreciate your time in steering me on to the right path here.
Thu Nov 30, 2017 12:19 pm (PST) . Posted by:
a.bereziuk
Hi Randy,
smfGetYahooPortfolioView delivers some values up to 7 digits, i.e. %Chg.: +2.8968236%. Simply reducing the number of digits in Excel format did not work. Is there a way to change it?
smfGetYahooPortfoli
Thu Nov 30, 2017 1:07 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I would say that sounds like the data is text data, not numeric data.
When I use the published example, I can increase or decrease the number of
decimals to display. No clue why you can't.
Which version of the add-in are you using? Which field numbers are you
having issues with?
On Thu, Nov 30, 2017 at 1:19 PM, a.bereziuk@
...
wrote:
>
> smfGetYahooPortfolioView delivers some values up to 7 digits, i.e. %Chg.:
> +2.8968236%. Simply reducing the number of digits in Excel format did not
> work. Is there a way to change it?
>
>
When I use the published example, I can increase or decrease the number of
decimals to display. No clue why you can't.
Which version of the add-in are you using? Which field numbers are you
having issues with?
On Thu, Nov 30, 2017 at 1:19 PM, a.bereziuk@
...
wrote:
>
> smfGetYahooPortfoli
> +2.8968236%. Simply reducing the number of digits in Excel format did not
> work. Is there a way to change it?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar