15 Messages
Digest #4202
7b
Re: I have always used RCHGetYahooQuotes for my current or last day by "Randy Harmelink" rharmelink
Messages
Fri Nov 3, 2017 12:16 pm (PDT) . Posted by:
"Michael Henry" midhenry1
Got it. That works.
- Michael
On Friday, November 3, 2017 10:40 AM, "Michael Henry midhenry1@yahoo.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
OK, makes sense, but how do I get the smfForceRecalculation macro ? (BTW, that date conversion function worked just fine)
Thanks,
- Michael
On Friday, November 3, 2017 10:07 AM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
This, like most add-in functions, do not change when you do an F9 to recalculate, because the add-in saves the web page first, then extracts the data from that saved copy of the web page. So using F9 to recalculate would just re-extract the data from the same saved copy of the web page. You would need to use the smfForceRecalculation macro to do a proper recalculation. That purges the saved copy of the web page, forcing the add-in to get a fresh copy.
All of the dates in the JSON file are in UNIX format, not EXCEL serial date format. To convert:
=smfUNIX2Date(B3)
You should be able to apply normal EXCEL date/time formats to the result.
I had planned to do that conversion in the function itself. However, Yahoo dropping the current quotes CSV file forced me to release the smfGetYahooPortfolioView() function early. So some plans that were in the pipeline are still in the pipeline. At this point, the plan is to add additional data items, including some that would have the UNIX date/time values converted to EXCEL date/time values.
On Fri, Nov 3, 2017 at 8:58 AM, Michael Henry midhenry1@... wrote:
Thanks for the pointer to the latest version. I get:Stock Market Functions add-in, Version 2.1.2017.11.02 (C:\SMF Add-in; Windows (32-bit) NT 10.00; 16.0; ; ; 1)
The sample worksheet also works.
However, how do I refresh the data? I heard mention of a macro.......? Why not just the usual F9 refresh?
Also, the "Last Traded" data is a complete mystery to me. How is this translated into a time and date?
#yiv0774293254 #yiv0774293254 -- #yiv0774293254ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0774293254 #yiv0774293254ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0774293254 #yiv0774293254ygrp-mkp #yiv0774293254hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0774293254 #yiv0774293254ygrp-mkp #yiv0774293254ads {margin-bottom:10px;}#yiv0774293254 #yiv0774293254ygrp-mkp .yiv0774293254ad {padding:0 0;}#yiv0774293254 #yiv0774293254ygrp-mkp .yiv0774293254ad p {margin:0;}#yiv0774293254 #yiv0774293254ygrp-mkp .yiv0774293254ad a {color:#0000ff;text-decoration:none;}#yiv0774293254 #yiv0774293254ygrp-sponsor #yiv0774293254ygrp-lc {font-family:Arial;}#yiv0774293254 #yiv0774293254ygrp-sponsor #yiv0774293254ygrp-lc #yiv0774293254hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0774293254 #yiv0774293254ygrp-sponsor #yiv0774293254ygrp-lc .yiv0774293254ad {margin-bottom:10px;padding:0 0;}#yiv0774293254 #yiv0774293254actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0774293254 #yiv0774293254activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0774293254 #yiv0774293254activity span {font-weight:700;}#yiv0774293254 #yiv0774293254activity span:first-child {text-transform:uppercase;}#yiv0774293254 #yiv0774293254activity span a {color:#5085b6;text-decoration:none;}#yiv0774293254 #yiv0774293254activity span span {color:#ff7900;}#yiv0774293254 #yiv0774293254activity span .yiv0774293254underline {text-decoration:underline;}#yiv0774293254 .yiv0774293254attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0774293254 .yiv0774293254attach div a {text-decoration:none;}#yiv0774293254 .yiv0774293254attach img {border:none;padding-right:5px;}#yiv0774293254 .yiv0774293254attach label {display:block;margin-bottom:5px;}#yiv0774293254 .yiv0774293254attach label a {text-decoration:none;}#yiv0774293254 blockquote {margin:0 0 0 4px;}#yiv0774293254 .yiv0774293254bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0774293254 .yiv0774293254bold a {text-decoration:none;}#yiv0774293254 dd.yiv0774293254last p a {font-family:Verdana;font-weight:700;}#yiv0774293254 dd.yiv0774293254last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0774293254 dd.yiv0774293254last p span.yiv0774293254yshortcuts {margin-right:0;}#yiv0774293254 div.yiv0774293254attach-table div div a {text-decoration:none;}#yiv0774293254 div.yiv0774293254attach-table {width:400px;}#yiv0774293254 div.yiv0774293254file-title a, #yiv0774293254 div.yiv0774293254file-title a:active, #yiv0774293254 div.yiv0774293254file-title a:hover, #yiv0774293254 div.yiv0774293254file-title a:visited {text-decoration:none;}#yiv0774293254 div.yiv0774293254photo-title a, #yiv0774293254 div.yiv0774293254photo-title a:active, #yiv0774293254 div.yiv0774293254photo-title a:hover, #yiv0774293254 div.yiv0774293254photo-title a:visited {text-decoration:none;}#yiv0774293254 div#yiv0774293254ygrp-mlmsg #yiv0774293254ygrp-msg p a span.yiv0774293254yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0774293254 .yiv0774293254green {color:#628c2a;}#yiv0774293254 .yiv0774293254MsoNormal {margin:0 0 0 0;}#yiv0774293254 o {font-size:0;}#yiv0774293254 #yiv0774293254photos div {float:left;width:72px;}#yiv0774293254 #yiv0774293254photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv0774293254 #yiv0774293254photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0774293254 #yiv0774293254reco-category {font-size:77%;}#yiv0774293254 #yiv0774293254reco-desc {font-size:77%;}#yiv0774293254 .yiv0774293254replbq {margin:4px;}#yiv0774293254 #yiv0774293254ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0774293254 #yiv0774293254ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0774293254 #yiv0774293254ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0774293254 #yiv0774293254ygrp-mlmsg select, #yiv0774293254 input, #yiv0774293254 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0774293254 #yiv0774293254ygrp-mlmsg pre, #yiv0774293254 code {font:115% monospace;}#yiv0774293254 #yiv0774293254ygrp-mlmsg * {line-height:1.22em;}#yiv0774293254 #yiv0774293254ygrp-mlmsg #yiv0774293254logo {padding-bottom:10px;}#yiv0774293254 #yiv0774293254ygrp-msg p a {font-family:Verdana;}#yiv0774293254 #yiv0774293254ygrp-msg p#yiv0774293254attach-count span {color:#1E66AE;font-weight:700;}#yiv0774293254 #yiv0774293254ygrp-reco #yiv0774293254reco-head {color:#ff7900;font-weight:700;}#yiv0774293254 #yiv0774293254ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0774293254 #yiv0774293254ygrp-sponsor #yiv0774293254ov li a {font-size:130%;text-decoration:none;}#yiv0774293254 #yiv0774293254ygrp-sponsor #yiv0774293254ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0774293254 #yiv0774293254ygrp-sponsor #yiv0774293254ov ul {margin:0;padding:0 0 0 8px;}#yiv0774293254 #yiv0774293254ygrp-text {font-family:Georgia;}#yiv0774293254 #yiv0774293254ygrp-text p {margin:0 0 1em 0;}#yiv0774293254 #yiv0774293254ygrp-text tt {font-size:120%;}#yiv0774293254 #yiv0774293254ygrp-vital ul li:last-child {border-right:none !important;}#yiv0774293254
- Michael
On Friday, November 3, 2017 10:40 AM, "Michael Henry midhenry1@yahoo.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
OK, makes sense, but how do I get the smfForceRecalculation macro ? (BTW, that date conversion function worked just fine)
Thanks,
- Michael
On Friday, November 3, 2017 10:07 AM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
This, like most add-in functions, do not change when you do an F9 to recalculate, because the add-in saves the web page first, then extracts the data from that saved copy of the web page. So using F9 to recalculate would just re-extract the data from the same saved copy of the web page. You would need to use the smfForceRecalculati
All of the dates in the JSON file are in UNIX format, not EXCEL serial date format. To convert:
=smfUNIX2Date(
You should be able to apply normal EXCEL date/time formats to the result.
I had planned to do that conversion in the function itself. However, Yahoo dropping the current quotes CSV file forced me to release the smfGetYahooPortfoli
On Fri, Nov 3, 2017 at 8:58 AM, Michael Henry midhenry1@... wrote:
Thanks for the pointer to the latest version. I get:Stock Market Functions add-in, Version 2.1.2017.11.
The sample worksheet also works.
However, how do I refresh the data? I heard mention of a macro.......
Also, the "Last Traded" data is a complete mystery to me. How is this translated into a time and date?
#yiv0774293254 #yiv0774293254 -- #yiv0774293254ygrp-
Fri Nov 3, 2017 12:38 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Check your version:
=RCHGetElementNumber("Version")
This is what I'm seeing with the latest version:
1 15 33 34
Symbol Last Price Dividends Per Share Dividend Yield
MO 63.89 2.44 4.07
GD 203.62 3.2 1.64
PG 86.56 2.72 3.17
O 55.12 2.51 4.74
On Fri, Nov 3, 2017 at 11:36 AM, rcstrauss@
...
wrote:
> Randy - Thanks for all you do to keep us in data. I am using your latest
> version of the smfGetPortfolioView()
>
> function to get price and other data on about 40 securities. Everything
> works fine except for securities with on two letter symbols (GD, MO, PG,
> etc) that return --- for values. Are others having this problem and is
> there a fix?
>
> =smfGetYahooPortfolioView(S5:S8,T3:W3,,1) returns:
> 1 15 33 34
> *Ticker Symbol* Symbol Last Price Dividends Per Share Dividend Yield
> MO O 55.25 2.51 4.74
> GD -- -- -- --
> PG -- -- -- --
> O -- -- -- --
>
>
>
=RCHGetElementNumbe
This is what I'm seeing with the latest version:
1 15 33 34
Symbol Last Price Dividends Per Share Dividend Yield
MO 63.89 2.44 4.07
GD 203.62 3.2 1.64
PG 86.56 2.72 3.17
O 55.12 2.51 4.74
On Fri, Nov 3, 2017 at 11:36 AM, rcstrauss@
...
wrote:
> Randy - Thanks for all you do to keep us in data. I am using your latest
> version of the smfGetPortfolioView
>
> function to get price and other data on about 40 securities. Everything
> works fine except for securities with on two letter symbols (GD, MO, PG,
> etc) that return --- for values. Are others having this problem and is
> there a fix?
>
> =smfGetYahooPortfol
> 1 15 33 34
> *Ticker Symbol* Symbol Last Price Dividends Per Share Dividend Yield
> MO O 55.25 2.51 4.74
> GD -- -- -- --
> PG -- -- -- --
> O -- -- -- --
>
>
>
Fri Nov 3, 2017 12:41 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It's the element numbers across the top in the template mentioned on the
blog, referred to by the array-entered formula.
You can also hard-code them, as in the example from the blog:
=smfGetYahooPortfolioView("MMM,IBM","010215",,1)
On Fri, Nov 3, 2017 at 12:09 PM, rho49m@
...
wrote:
> Sorry but where do I find the variables to choose which fields to
> download? Looked but didn't come up with anything. Maybe a little help and
> example file would help the less gifted?
>
blog, referred to by the array-entered formula.
You can also hard-code them, as in the example from the blog:
=smfGetYahooPortfol
On Fri, Nov 3, 2017 at 12:09 PM, rho49m@
...
wrote:
> Sorry but where do I find the variables to choose which fields to
> download? Looked but didn't come up with anything. Maybe a little help and
> example file would help the less gifted?
>
Fri Nov 3, 2017 12:51 pm (PDT) . Posted by:
smmarder
When I try that the cell returns "#Name?" Is this also Yahoo discontinuation of service or am I doing something wrong??
THX
THX
Fri Nov 3, 2017 12:54 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
When you try what? I need context. Especially with the number of messages
in the last few days.
#NAME? on an add-in function usually means you either misspelled the
function name or the add-in isn't installed properly.
On Fri, Nov 3, 2017 at 12:51 PM, smmarder@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> When I try that the cell returns "#Name?" Is this also Yahoo
> discontinuation of service or am I doing something wrong??
> THX
>
>
>
in the last few days.
#NAME? on an add-in function usually means you either misspelled the
function name or the add-in isn't installed properly.
On Fri, Nov 3, 2017 at 12:51 PM, smmarder@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> When I try that the cell returns "#Name?
> discontinuation of service or am I doing something wrong??
> THX
>
>
>
Fri Nov 3, 2017 1:14 pm (PDT) . Posted by:
nbkih44
I've gotten a lot of great use out of this add-in for 6-7 years now. Thank you for all your effort (and patience). I just downloaded the newest version (2017.11.02) today. Both: "RCHGetElementNumber" and "smfGetOptionQuotes" still work but I now get "OBSOLETE" returned for "smfgetyahooportfolioview" . Any idea what I've done wrong? Thanks
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :
When you try what? I need context. Especially with the number of messages in the last few days.
#NAME? on an add-in function usually means you either misspelled the function name or the add-in isn't installed properly.
On Fri, Nov 3, 2017 at 12:51 PM, smmarder@... mailto:smmarder@... [smf_addin] <smf_addin@yahoogroups.com mailto:smf_addin@yahoogroups.com> wrote:
When I try that the cell returns "#Name?" Is this also Yahoo discontinuation of service or am I doing something wrong??
THX
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :
When you try what? I need context. Especially with the number of messages in the last few days.
#NAME? on an add-in function usually means you either misspelled the function name or the add-in isn't installed properly.
On Fri, Nov 3, 2017 at 12:51 PM, smmarder@... mailto:smmarder@... [smf_addin] <smf_addin@yahoogroups.com mailto:smf_addin@yahoogroups.com> wrote:
When I try that the cell returns "#Name?
THX
Fri Nov 3, 2017 1:23 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Make sure the new version got installed properly:
=RCHGetElementNumber("Version")
Do you get "Obsolete" when using the example workbook?
On Fri, Nov 3, 2017 at 1:14 PM, bchornung@kc.rr.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I've gotten a lot of great use out of this add-in for 6-7 years now.
> Thank you for all your effort (and patience).
> I just downloaded the newest version (2017.11.02) today. Both:
> "RCHGetElementNumber" and "smfGetOptionQuotes" still work but I now get
> "OBSOLETE"; returned for "smfgetyahooportfolioview"; . Any idea what I've
> done wrong? Thanks
>
=RCHGetElementNumber("Version")
Do you get "Obsolete" when using the example workbook?
On Fri, Nov 3, 2017 at 1:14 PM, bchornung@kc.rr.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I've gotten a lot of great use out of this add-in for 6-7 years now.
> Thank you for all your effort (and patience).
> I just downloaded the newest version (2017.11.02) today. Both:
> "RCHGetElement
> "OBSOLETE"
> done wrong? Thanks
>
Fri Nov 3, 2017 1:29 pm (PDT) . Posted by:
"lswpubrw" lswpubrlw
Randy,
I just use SMF for simple quote retrieve and the 2014 version was working well up until today.
=RCHGetYahooQuotes($A$7,"l1")
That's what I use with $A$7 being the stock symbol. I've downloaded the 11.02 version into my SMF Add-in folder but that didn't seem to fix things. The version request is telling me it's still my 2014 version even though the one in folder says it's was downloaded today. I must be missing a step. Do I need to redo the add in step in EXCEL?
thanks,
Bob
lswpubrw@optonline.net
warasir@sunysuffolk.edu
bobwarasila@lswpub.com
I just use SMF for simple quote retrieve and the 2014 version was working well up until today.
=RCHGetYahooQuotes($A$7,"l1")
That's what I use with $A$7 being the stock symbol. I've downloaded the 11.02 version into my SMF Add-in folder but that didn't seem to fix things. The version request is telling me it's still my 2014 version even though the one in folder says it's was downloaded today. I must be missing a step. Do I need to redo the add in step in EXCEL?
thanks,
Bob
lswpubrw@optonline.net
warasir@sunysuffolk.edu
bobwarasila@lswpub.com
Fri Nov 3, 2017 1:43 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
At this point, RCHGetYahooQuotes() is dead. Yahoo has unplugged the current
quotes CSV file that it got its data from. See recent announcements on the
blog:
https://smf-add-in.blogspot.com/
On Fri, Nov 3, 2017 at 1:29 PM, 'lswpubrw' lswpubrw@
...
wrote:
>
> I just use SMF for simple quote retrieve and the 2014 version was working
> well up until today.
>
> =RCHGetYahooQuotes($A$7,"l1")
>
> That's what I use with $A$7 being the stock symbol. I've downloaded the
> 11.02 version into my SMF Add-in folder but that didn't seem to fix
> things. The version request is telling me it's still my 2014 version even
> though the one in folder says it's was downloaded today. I must be missing
> a step. Do I need to redo the add in step in EXCEL?
>
>
>
quotes CSV file that it got its data from. See recent announcements on the
blog:
https://smf-add-in.blogspot.com/
On Fri, Nov 3, 2017 at 1:29 PM, 'lswpubrw&#
...
wrote:
>
> I just use SMF for simple quote retrieve and the 2014 version was working
> well up until today.
>
> =RCHGetYahooQuotes(
>
> That's what I use with $A$7 being the stock symbol. I've downloaded the
> 11.02 version into my SMF Add-in folder but that didn't seem to fix
> things. The version request is telling me it's still my 2014 version even
> though the one in folder says it's was downloaded today. I must be missing
> a step. Do I need to redo the add in step in EXCEL?
>
>
>
Fri Nov 3, 2017 2:30 pm (PDT) . Posted by:
"lswpubrw" lswpubrlw
Randy,
What do I use instead of that function. Also why is my version request returning 2014 even though I have the latest xla in my SMF Add-in file?
Bob
lswpubrw@optonline.net
warasir@sunysuffolk.edu
bobwarasila@lswpub.com
From: Randy Harmelink rharmelink@gmail.com [smf_addin]
Sent: Friday, November 3, 2017 4:43 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] error message
At this point, RCHGetYahooQuotes() is dead. Yahoo has unplugged the current quotes CSV file that it got its data from. See recent announcements on the blog:
https://smf-add-in.blogspot.com/
On Fri, Nov 3, 2017 at 1:29 PM, 'lswpubrw' lswpubrw@
...
wrote:
I just use SMF for simple quote retrieve and the 2014 version was working well up until today.
=RCHGetYahooQuotes($A$7,"l1")
That's what I use with $A$7 being the stock symbol. I've downloaded the 11.02 version into my SMF Add-in folder but that didn't seem to fix things. The version request is telling me it's still my 2014 version even though the one in folder says it's was downloaded today. I must be missing a step. Do I need to redo the add in step in EXCEL?
What do I use instead of that function. Also why is my version request returning 2014 even though I have the latest xla in my SMF Add-in file?
Bob
lswpubrw@optonline.net
warasir@sunysuffolk.edu
bobwarasila@lswpub.com
From: Randy Harmelink rharmelink@gmail.com [smf_addin]
Sent: Friday, November 3, 2017 4:43 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] error message
At this point, RCHGetYahooQuotes() is dead. Yahoo has unplugged the current quotes CSV file that it got its data from. See recent announcements on the blog:
https://smf-add-in.blogspot.com/
On Fri, Nov 3, 2017 at 1:29 PM, 'lswpubrw&#
...
wrote:
I just use SMF for simple quote retrieve and the 2014 version was working well up until today.
=RCHGetYahooQuotes(
That's what I use with $A$7 being the stock symbol. I've downloaded the 11.02 version into my SMF Add-in folder but that didn't seem to fix things. The version request is telling me it's still my 2014 version even though the one in folder says it's was downloaded today. I must be missing a step. Do I need to redo the add in step in EXCEL?
Fri Nov 3, 2017 2:54 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
See the last few entries on the announcements blog for alternatives:
https://smf-add-in.blogspot.com/
If the version is still referring to the 2014 version, you didn't update
the add-in correctly. Usually, that means someone has the add-in in more
than one folder on their machine, and the folder specified by EXCEL's
add-in manager refers to a different folder than the one that was updated.
Or that the files were updated while EXCEL was still open (add-ins are
typically only loaded when EXCEL starts up).
On Fri, Nov 3, 2017 at 2:30 PM, 'lswpubrw' lswpubrw@
...
wrote:
>
> What do I use instead of that function. Also why is my version request
> returning 2014 even though I have the latest xla in my SMF Add-in file?
>
>
https://smf-add-in.blogspot.com/
If the version is still referring to the 2014 version, you didn't update
the add-in correctly. Usually, that means someone has the add-in in more
than one folder on their machine, and the folder specified by EXCEL's
add-in manager refers to a different folder than the one that was updated.
Or that the files were updated while EXCEL was still open (add-ins are
typically only loaded when EXCEL starts up).
On Fri, Nov 3, 2017 at 2:30 PM, 'lswpubrw&#
...
wrote:
>
> What do I use instead of that function. Also why is my version request
> returning 2014 even though I have the latest xla in my SMF Add-in file?
>
>
Fri Nov 3, 2017 1:33 pm (PDT) . Posted by:
bob_15861586
Randy,
I am confused. I put a call to the macro smfForceRecalculation in a cell of my Excel spread sheet and Excel does not know about it. I am currently using version2.1.2017.11.02 of SMF. I think that is the latest version of SMF. What am I missing?
Bob
I am confused. I put a call to the macro smfForceRecalculati
Bob
Fri Nov 3, 2017 1:45 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
smfForceRecalculation is a macro you need to run, not a function. I have it
attached to a button on my Quick Access Toolbar, because I use it often.
See the write-up on the FAQs web page for more details on the macro.
On Fri, Nov 3, 2017 at 1:33 PM, bob_15861586@
...
wrote:
>
> I am confused. I put a call to the macro smfForceRecalculation in a cell
> of my Excel spread sheet and Excel does not know about it. I am currently
> using version2.1.2017.11.02 of SMF. I think that is the latest version of
> SMF. What am I missing?
>
>
>
attached to a button on my Quick Access Toolbar, because I use it often.
See the write-up on the FAQs web page for more details on the macro.
On Fri, Nov 3, 2017 at 1:33 PM, bob_15861586@
...
wrote:
>
> I am confused. I put a call to the macro smfForceRecalculati
> of my Excel spread sheet and Excel does not know about it. I am currently
> using version2.1.2017.
> SMF. What am I missing?
>
>
>
Fri Nov 3, 2017 2:16 pm (PDT) . Posted by:
rr76012
Fri 11/3/ 2017
Re: previous or last stock price quoate
I have always used RCHGetYahooQuotes( , l1) for my current or last day stock price.
Does anyone know of a rchgetelementnumber number or another way to get the last stock price?
Thanks,
rr76012
Re: previous or last stock price quoate
I have always used RCHGetYahooQuotes( , l1) for my current or last day stock price.
Does anyone know of a rchgetelementnumber number or another way to get the last stock price?
Thanks,
rr76012
Fri Nov 3, 2017 2:50 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Please don't do the RCHGetElementNumber() method unless it's for only one
or two quotes. Doing it regularly for dozens or hundreds of stocks is just
an incentive for a web site to restrict access to such data.
Take a look at the latest entry
<https://smf-add-in.blogspot.com/2017/11/tip-possible-google-method-to-get.html>
on the announcements blog. The Google alternative might fit your needs?
On Fri, Nov 3, 2017 at 2:16 PM, rr76012@
...
wrote:
> Re: previous or last stock price quoate
>
> I have always used RCHGetYahooQuotes( , l1) for my current or last day
> stock price.
> Does anyone know of a rchgetelementnumber number or another way to get the
> last stock price?
>
>
or two quotes. Doing it regularly for dozens or hundreds of stocks is just
an incentive for a web site to restrict access to such data.
Take a look at the latest entry
<https://smf-add-in.blogspot.com/2017/11/tip-possible-google-method-to-get.html>
on the announcements blog. The Google alternative might fit your needs?
On Fri, Nov 3, 2017 at 2:16 PM, rr76012@
...
wrote:
> Re: previous or last stock price quoate
>
> I have always used RCHGetYahooQuotes( , l1) for my current or last day
> stock price.
> Does anyone know of a rchgetelementnumber number or another way to get the
> last stock price?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar