15 Messages
Digest #4021
1a
Re: #Name? Error on all cells - how to fix this Windows 10 Excel 201 by "Randy Harmelink" rharmelink
Messages
Sun May 21, 2017 10:24 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
If all worksheets are getting #NAME? errors, it's probably that Microsoft
security update reemerging with the new XLA file. See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
If just the template for smfGetYahooHistory(), it's probably a location
error. Just run the smfFixLinks macro on the worksheet causing the problem.
On Sun, May 21, 2017 at 8:29 AM, rr76012@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> A few days ago I loaded in your latest smfaddin.
>
> I get on all cells the error message: "#Name?".
>
> I installed your latest version smfaddin in the same directory: C:\Program
> Files\ SMF Add-in
>
> Can you advise me how to fix the "#Name?" errors in the cells.
>
> I have windows 10 and Excel 2010.
>
>
>
security update reemerging with the new XLA file. See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
If just the template for smfGetYahooHistory(), it's probably a location
error. Just run the smfFixLinks macro on the worksheet causing the problem.
On Sun, May 21, 2017 at 8:29 AM, rr76012@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> A few days ago I loaded in your latest smfaddin.
>
> I get on all cells the error message: "#Name?
>
> I installed your latest version smfaddin in the same directory: C:\Program
> Files\ SMF Add-in
>
> Can you advise me how to fix the "#Name?
>
> I have windows 10 and Excel 2010.
>
>
>
Sun May 21, 2017 10:38 am (PDT) . Posted by:
cgrablew
Randy,
Do you know why the SMFPricesbyDates is not working. I used it 2 weeks ago and it was ok. I've installed the latest addin 2 weeks ago. I use SMFPricesbyDates("~~~~~",Now()-90) in the table load process. I need to get the stock price for 3 months ago, 6 months ago, and 12 months ago and use this SMFPricesbyDates to get it. If there is an alternative please let me know.
Thanks,
Chuck Grablewski
Do you know why the SMFPricesbyDates is not working. I used it 2 weeks ago and it was ok. I've installed the latest addin 2 weeks ago. I use SMFPricesbyDates(
Thanks,
Chuck Grablewski
Sun May 21, 2017 12:29 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32178
P.S. You should not use NOW() in a function like that. It makes the cell
volatile, which means it will recalculate any time ANYTHING in the workbook
is changed. Also, if you're getting multiple prices for a ticker, you
should get them all at once so you don't have to get data from the Internet
multiple times. For example:
E4: =DATEVALUE(RCHGetYahooQuotes("SPY","d1"))
F4: =EOMONTH($E4,-4)+DAY($E4)
G4: =EOMONTH($E4,-7)+DAY($E4)
H4: =EOMONTH($E4,-13)+DAY($E4)
D5: MMM
E5:H5: =smfPricesByDates(D5,E$4:H$4)
Note that E5:H5 can be copied downward for other rows because of the "$4"
row address referring to the dates. So:
*Ticker* *2017-05-19* *2017-02-19* *2016-11-19* *2016-05-19*
MMM $195.80 $181.86 $170.82 $161.03
SPY $238.31 $234.07 $216.28 $200.07
SPHD $39.65 $39.95 $36.98 $34.46
On Sun, May 21, 2017 at 10:38 AM, cgrablew@
...wrote:
> Do you know why the SMFPricesbyDates is not working. I used it 2 weeks
> ago and it was ok. I've installed the latest addin 2 weeks ago. I use
> SMFPricesbyDates("~~~~~",Now()-90) in the table load process. I need to
> get the stock price for 3 months ago, 6 months ago, and 12 months ago and
> use this SMFPricesbyDates to get it. If there is an alternative please let
> me know.
>
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32178
P.S. You should not use NOW() in a function like that. It makes the cell
volatile, which means it will recalculate any time ANYTHING in the workbook
is changed. Also, if you're getting multiple prices for a ticker, you
should get them all at once so you don't have to get data from the Internet
multiple times. For example:
E4: =DATEVALUE(RCHGetYa
F4: =EOMONTH($E4,
G4: =EOMONTH($E4,
H4: =EOMONTH($E4,
D5: MMM
E5:H5: =smfPricesByDates(
Note that E5:H5 can be copied downward for other rows because of the "$4"
row address referring to the dates. So:
*Ticker* *2017-05-19* *2017-02-19* *2016-11-19* *2016-05-19*
MMM $195.80 $181.86 $170.82 $161.03
SPY $238.31 $234.07 $216.28 $200.07
SPHD $39.65 $39.95 $36.98 $34.46
On Sun, May 21, 2017 at 10:38 AM, cgrablew@
...wrote:
> Do you know why the SMFPricesbyDates is not working. I used it 2 weeks
> ago and it was ok. I've installed the latest addin 2 weeks ago. I use
> SMFPricesbyDates(
> get the stock price for 3 months ago, 6 months ago, and 12 months ago and
> use this SMFPricesbyDates to get it. If there is an alternative please let
> me know.
>
Sun May 21, 2017 2:27 pm (PDT) . Posted by:
"Yahoo!" lewglenn
When I run the code piece:Cells(r, "I") = Application.WorksheetFunction.Average(smfGetYahooHistory(Res, , , , "c", 0, , 50, 1))
I get a compile error with the message sub or function smfGetYahooHistory is not defined. I have downloaded the latest SMF Add-In (5/21/17) and I know that vba/EXCEL is seeing it because I have a call to RCHGetYahooQuotes previously in my code and the compiler doesn't object.
So what am I doing wrong? Is there something that I need beside the current SMF Add-In?
Thanks.
Lew
On Saturday, May 20, 2017, 5:20:11 PM PDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
See the 50-day average example I gave here:
https://groups.yahoo.com/neo/g roups/smf_addin/conversations/ messages/32114
It might be quicker to get the 50-day moving average from some sort of screener. For example, Barchart has a free screener and you can download 10 results per day (limited to the first 1000 stocks). They have a number of performance fields, including the 50-day average. For example:
| Symbol | Name | Last | 50D MA | 50D MA | 50D MA Str | 50D MA Dir | 50D Chg | 50D %Chg | 1M %Chg | 3M %Chg | 6M %Chg | 9M %Chg | 52W %Chg |
| AGFS | Agrofresh Solutions | 6.99 | 4.99 | Buy | Maximum | Weakening | 4.17 | 147.87% | 20.73% | 156.04% | 185.31% | 16.89% | 55.33% |
| ANGI | Angie's List Inc | 11.24 | 7.23 | Buy | Strong | Weakest | 5.78 | 105.86% | 92.47% | 95.14% | 27.29% | 15.88% | 32.08% |
| COOL | Majesco Entertainmnt | 13.44 | 11.45 | Buy | Weak | Strongest | 6.75 | 100.90% | 2.52% | 140.86% | 304.82% | 267.21% | 146.15% |
| CONN | Conn's Inc | 15.8 | 12.8 | Buy | Average | Weakest | 7.8 | 97.50% | 19.25% | 54.15% | 46.98% | 127.01% | 45.89% |
| CORI | Corium Intl Cmn | 6.85 | 4.5 | Buy | Maximum | Strengthening | 3.16 | 85.64% | 48.59% | 78.39% | 34.31% | 21.67% | 84.14% |
| CYAD | Celyad Sa Ads | 40.58 | 29.54 | Buy | Average | Strengthening | 18.37 | 82.71% | 41.15% | 97.18% | 120.54% | 59.70% | -18.84% |
It might be quicker to download a few screen results and then refer to them using VLOOKUP() functions...
Just checked. If I'm logged into my free BarChart account, the screening result can be read in with the smfGetCSVFile() function.
On Sat, May 20, 2017 at 3:18 PM, lewglenn@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
I know you've been dealing with this problem for several weeks now thanks to Yahoo's latest actions. I've downloaded the latest SMFAdd-In. Can you please tell me what I need to do to replace the RCHGetYahooHistory call in the following coding (to get 50-day MA):
For r = 2 To rowmax
If IsEmpty(Cells(r, "P")) Then
Res = Cells(r, "A")
Cells(r, "I") = Application.WorksheetFunction. Average(RCHGetYahooHistory(Res , , , , , , , , "a", 0, , , 50, 1))
End If
Next r
#yiv1699267107 #yiv1699267107 -- #yiv1699267107ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1699267107 #yiv1699267107ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1699267107 #yiv1699267107ygrp-mkp #yiv1699267107hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1699267107 #yiv1699267107ygrp-mkp #yiv1699267107ads {margin-bottom:10px;}#yiv1699267107 #yiv1699267107ygrp-mkp .yiv1699267107ad {padding:0 0;}#yiv1699267107 #yiv1699267107ygrp-mkp .yiv1699267107ad p {margin:0;}#yiv1699267107 #yiv1699267107ygrp-mkp .yiv1699267107ad a {color:#0000ff;text-decoration:none;}#yiv1699267107 #yiv1699267107ygrp-sponsor #yiv1699267107ygrp-lc {font-family:Arial;}#yiv1699267107 #yiv1699267107ygrp-sponsor #yiv1699267107ygrp-lc #yiv1699267107hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1699267107 #yiv1699267107ygrp-sponsor #yiv1699267107ygrp-lc .yiv1699267107ad {margin-bottom:10px;padding:0 0;}#yiv1699267107 #yiv1699267107actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1699267107 #yiv1699267107activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1699267107 #yiv1699267107activity span {font-weight:700;}#yiv1699267107 #yiv1699267107activity span:first-child {text-transform:uppercase;}#yiv1699267107 #yiv1699267107activity span a {color:#5085b6;text-decoration:none;}#yiv1699267107 #yiv1699267107activity span span {color:#ff7900;}#yiv1699267107 #yiv1699267107activity span .yiv1699267107underline {text-decoration:underline;}#yiv1699267107 .yiv1699267107attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1699267107 .yiv1699267107attach div a {text-decoration:none;}#yiv1699267107 .yiv1699267107attach img {border:none;padding-right:5px;}#yiv1699267107 .yiv1699267107attach label {display:block;margin-bottom:5px;}#yiv1699267107 .yiv1699267107attach label a {text-decoration:none;}#yiv1699267107 blockquote {margin:0 0 0 4px;}#yiv1699267107 .yiv1699267107bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1699267107 .yiv1699267107bold a {text-decoration:none;}#yiv1699267107 dd.yiv1699267107last p a {font-family:Verdana;font-weight:700;}#yiv1699267107 dd.yiv1699267107last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1699267107 dd.yiv1699267107last p span.yiv1699267107yshortcuts {margin-right:0;}#yiv1699267107 div.yiv1699267107attach-table div div a {text-decoration:none;}#yiv1699267107 div.yiv1699267107attach-table {width:400px;}#yiv1699267107 div.yiv1699267107file-title a, #yiv1699267107 div.yiv1699267107file-title a:active, #yiv1699267107 div.yiv1699267107file-title a:hover, #yiv1699267107 div.yiv1699267107file-title a:visited {text-decoration:none;}#yiv1699267107 div.yiv1699267107photo-title a, #yiv1699267107 div.yiv1699267107photo-title a:active, #yiv1699267107 div.yiv1699267107photo-title a:hover, #yiv1699267107 div.yiv1699267107photo-title a:visited {text-decoration:none;}#yiv1699267107 div#yiv1699267107ygrp-mlmsg #yiv1699267107ygrp-msg p a span.yiv1699267107yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1699267107 .yiv1699267107green {color:#628c2a;}#yiv1699267107 .yiv1699267107MsoNormal {margin:0 0 0 0;}#yiv1699267107 o {font-size:0;}#yiv1699267107 #yiv1699267107photos div {float:left;width:72px;}#yiv1699267107 #yiv1699267107photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv1699267107 #yiv1699267107photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1699267107 #yiv1699267107reco-category {font-size:77%;}#yiv1699267107 #yiv1699267107reco-desc {font-size:77%;}#yiv1699267107 .yiv1699267107replbq {margin:4px;}#yiv1699267107 #yiv1699267107ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1699267107 #yiv1699267107ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1699267107 #yiv1699267107ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1699267107 #yiv1699267107ygrp-mlmsg select, #yiv1699267107 input, #yiv1699267107 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1699267107 #yiv1699267107ygrp-mlmsg pre, #yiv1699267107 code {font:115% monospace;}#yiv1699267107 #yiv1699267107ygrp-mlmsg * {line-height:1.22em;}#yiv1699267107 #yiv1699267107ygrp-mlmsg #yiv1699267107logo {padding-bottom:10px;}#yiv1699267107 #yiv1699267107ygrp-msg p a {font-family:Verdana;}#yiv1699267107 #yiv1699267107ygrp-msg p#yiv1699267107attach-count span {color:#1E66AE;font-weight:700;}#yiv1699267107 #yiv1699267107ygrp-reco #yiv1699267107reco-head {color:#ff7900;font-weight:700;}#yiv1699267107 #yiv1699267107ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1699267107 #yiv1699267107ygrp-sponsor #yiv1699267107ov li a {font-size:130%;text-decoration:none;}#yiv1699267107 #yiv1699267107ygrp-sponsor #yiv1699267107ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1699267107 #yiv1699267107ygrp-sponsor #yiv1699267107ov ul {margin:0;padding:0 0 0 8px;}#yiv1699267107 #yiv1699267107ygrp-text {font-family:Georgia;}#yiv1699267107 #yiv1699267107ygrp-text p {margin:0 0 1em 0;}#yiv1699267107 #yiv1699267107ygrp-text tt {font-size:120%;}#yiv1699267107 #yiv1699267107ygrp-vital ul li:last-child {border-right:none !important;}#yiv1699267107
I get a compile error with the message sub or function smfGetYahooHistory is not defined. I have downloaded the latest SMF Add-In (5/21/17) and I know that vba/EXCEL is seeing it because I have a call to RCHGetYahooQuotes previously in my code and the compiler doesn't object.
So what am I doing wrong? Is there something that I need beside the current SMF Add-In?
Thanks.
Lew
On Saturday, May 20, 2017, 5:20:11 PM PDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
See the 50-day average example I gave here:
https://groups.yahoo.com/neo/g roups/smf_addin/conversations/ messages/32114
It might be quicker to get the 50-day moving average from some sort of screener. For example, Barchart has a free screener and you can download 10 results per day (limited to the first 1000 stocks). They have a number of performance fields, including the 50-day average. For example:
| Symbol | Name | Last | 50D MA | 50D MA | 50D MA Str | 50D MA Dir | 50D Chg | 50D %Chg | 1M %Chg | 3M %Chg | 6M %Chg | 9M %Chg | 52W %Chg |
| AGFS | Agrofresh Solutions | 6.99 | 4.99 | Buy | Maximum | Weakening | 4.17 | 147.87% | 20.73% | 156.04% | 185.31% | 16.89% | 55.33% |
| ANGI | Angie's List Inc | 11.24 | 7.23 | Buy | Strong | Weakest | 5.78 | 105.86% | 92.47% | 95.14% | 27.29% | 15.88% | 32.08% |
| COOL | Majesco Entertainmnt | 13.44 | 11.45 | Buy | Weak | Strongest | 6.75 | 100.90% | 2.52% | 140.86% | 304.82% | 267.21% | 146.15% |
| CONN | Conn's Inc | 15.8 | 12.8 | Buy | Average | Weakest | 7.8 | 97.50% | 19.25% | 54.15% | 46.98% | 127.01% | 45.89% |
| CORI | Corium Intl Cmn | 6.85 | 4.5 | Buy | Maximum | Strengthening | 3.16 | 85.64% | 48.59% | 78.39% | 34.31% | 21.67% | 84.14% |
| CYAD | Celyad Sa Ads | 40.58 | 29.54 | Buy | Average | Strengthening | 18.37 | 82.71% | 41.15% | 97.18% | 120.54% | 59.70% | -18.84% |
It might be quicker to download a few screen results and then refer to them using VLOOKUP() functions...
Just checked. If I'm logged into my free BarChart account, the screening result can be read in with the smfGetCSVFile() function.
On Sat, May 20, 2017 at 3:18 PM, lewglenn@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
I know you've been dealing with this problem for several weeks now thanks to Yahoo's latest actions. I've downloaded the latest SMFAdd-In. Can you please tell me what I need to do to replace the RCHGetYahooHistory call in the following coding (to get 50-day MA):
For r = 2 To rowmax
If IsEmpty(Cells(
Res = Cells(r, "A"
Cells(r, "I"
End If
Next r
#yiv1699267107 #yiv1699267107 -- #yiv1699267107ygrp-
Sun May 21, 2017 2:45 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't know where you got a 5/21/17 version of the add-in. The version I
use isn't even that up-to-date (5/20). :)
smfGetYahooHistory() is only available in a beta version that isn't
documented on the website, because it's not ready for official release. See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32112
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32114
On Sun, May 21, 2017 at 2:27 PM, Yahoo! lewglenn@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> When I run the code piece:
> Cells(r, "I") = Application.WorksheetFunction.Average(smfGetYahooHistory(Res,
> , , , "c", 0, , 50, 1))
>
> I get a compile error with the message sub or function *smfGetYahooHistory
> *is not defined. I have downloaded the latest SMF Add-In (5/21/17) and I
> know that vba/EXCEL is seeing it because I have a call to RCHGetYahooQuotes
> previously in my code and the compiler doesn't object.
>
> So what am I doing wrong? Is there something that I need beside the
> current SMF Add-In?
>
>
>
use isn't even that up-to-date (5/20). :)
smfGetYahooHistory() is only available in a beta version that isn't
documented on the website, because it's not ready for official release. See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32112
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32114
On Sun, May 21, 2017 at 2:27 PM, Yahoo! lewglenn@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> When I run the code piece:
> Cells(r, "I"
> , , , "c"
>
> I get a compile error with the message sub or function *smfGetYahooHistory
> *is not defined. I have downloaded the latest SMF Add-In (5/21/17) and I
> know that vba/EXCEL is seeing it because I have a call to RCHGetYahooQuotes
> previously in my code and the compiler doesn't object.
>
> So what am I doing wrong? Is there something that I need beside the
> current SMF Add-In?
>
>
>
Sun May 21, 2017 3:07 pm (PDT) . Posted by:
"Yahoo!" lewglenn
My mistake; the version I was using was dated 5/3/2017. I switched to the beta version in message 32112 and it worked just fine.
Thanks again for your help.
Lew
On Sunday, May 21, 2017, 2:45:50 PM PDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
I don't know where you got a 5/21/17 version of the add-in. The version I use isn't even that up-to-date (5/20). :)
smfGetYahooHistory() is only available in a beta version that isn't documented on the website, because it's not ready for official release. See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32112
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32114
On Sun, May 21, 2017 at 2:27 PM, Yahoo! lewglenn@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
When I run the code piece:Cells(r, "I") = Application.WorksheetFunction. Average(smfGetYahooHistory( Res, , , , "c", 0, , 50, 1))
I get a compile error with the message sub or function smfGetYahooHistory is not defined. I have downloaded the latest SMF Add-In (5/21/17) and I know that vba/EXCEL is seeing it because I have a call to RCHGetYahooQuotes previously in my code and the compiler doesn't object.
So what am I doing wrong? Is there something that I need beside the current SMF Add-In?
#yiv3822020232 #yiv3822020232 -- #yiv3822020232ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3822020232 #yiv3822020232ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3822020232 #yiv3822020232ygrp-mkp #yiv3822020232hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3822020232 #yiv3822020232ygrp-mkp #yiv3822020232ads {margin-bottom:10px;}#yiv3822020232 #yiv3822020232ygrp-mkp .yiv3822020232ad {padding:0 0;}#yiv3822020232 #yiv3822020232ygrp-mkp .yiv3822020232ad p {margin:0;}#yiv3822020232 #yiv3822020232ygrp-mkp .yiv3822020232ad a {color:#0000ff;text-decoration:none;}#yiv3822020232 #yiv3822020232ygrp-sponsor #yiv3822020232ygrp-lc {font-family:Arial;}#yiv3822020232 #yiv3822020232ygrp-sponsor #yiv3822020232ygrp-lc #yiv3822020232hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3822020232 #yiv3822020232ygrp-sponsor #yiv3822020232ygrp-lc .yiv3822020232ad {margin-bottom:10px;padding:0 0;}#yiv3822020232 #yiv3822020232actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3822020232 #yiv3822020232activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3822020232 #yiv3822020232activity span {font-weight:700;}#yiv3822020232 #yiv3822020232activity span:first-child {text-transform:uppercase;}#yiv3822020232 #yiv3822020232activity span a {color:#5085b6;text-decoration:none;}#yiv3822020232 #yiv3822020232activity span span {color:#ff7900;}#yiv3822020232 #yiv3822020232activity span .yiv3822020232underline {text-decoration:underline;}#yiv3822020232 .yiv3822020232attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3822020232 .yiv3822020232attach div a {text-decoration:none;}#yiv3822020232 .yiv3822020232attach img {border:none;padding-right:5px;}#yiv3822020232 .yiv3822020232attach label {display:block;margin-bottom:5px;}#yiv3822020232 .yiv3822020232attach label a {text-decoration:none;}#yiv3822020232 blockquote {margin:0 0 0 4px;}#yiv3822020232 .yiv3822020232bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3822020232 .yiv3822020232bold a {text-decoration:none;}#yiv3822020232 dd.yiv3822020232last p a {font-family:Verdana;font-weight:700;}#yiv3822020232 dd.yiv3822020232last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3822020232 dd.yiv3822020232last p span.yiv3822020232yshortcuts {margin-right:0;}#yiv3822020232 div.yiv3822020232attach-table div div a {text-decoration:none;}#yiv3822020232 div.yiv3822020232attach-table {width:400px;}#yiv3822020232 div.yiv3822020232file-title a, #yiv3822020232 div.yiv3822020232file-title a:active, #yiv3822020232 div.yiv3822020232file-title a:hover, #yiv3822020232 div.yiv3822020232file-title a:visited {text-decoration:none;}#yiv3822020232 div.yiv3822020232photo-title a, #yiv3822020232 div.yiv3822020232photo-title a:active, #yiv3822020232 div.yiv3822020232photo-title a:hover, #yiv3822020232 div.yiv3822020232photo-title a:visited {text-decoration:none;}#yiv3822020232 div#yiv3822020232ygrp-mlmsg #yiv3822020232ygrp-msg p a span.yiv3822020232yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3822020232 .yiv3822020232green {color:#628c2a;}#yiv3822020232 .yiv3822020232MsoNormal {margin:0 0 0 0;}#yiv3822020232 o {font-size:0;}#yiv3822020232 #yiv3822020232photos div {float:left;width:72px;}#yiv3822020232 #yiv3822020232photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3822020232 #yiv3822020232photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3822020232 #yiv3822020232reco-category {font-size:77%;}#yiv3822020232 #yiv3822020232reco-desc {font-size:77%;}#yiv3822020232 .yiv3822020232replbq {margin:4px;}#yiv3822020232 #yiv3822020232ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3822020232 #yiv3822020232ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3822020232 #yiv3822020232ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3822020232 #yiv3822020232ygrp-mlmsg select, #yiv3822020232 input, #yiv3822020232 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3822020232 #yiv3822020232ygrp-mlmsg pre, #yiv3822020232 code {font:115% monospace;}#yiv3822020232 #yiv3822020232ygrp-mlmsg * {line-height:1.22em;}#yiv3822020232 #yiv3822020232ygrp-mlmsg #yiv3822020232logo {padding-bottom:10px;}#yiv3822020232 #yiv3822020232ygrp-msg p a {font-family:Verdana;}#yiv3822020232 #yiv3822020232ygrp-msg p#yiv3822020232attach-count span {color:#1E66AE;font-weight:700;}#yiv3822020232 #yiv3822020232ygrp-reco #yiv3822020232reco-head {color:#ff7900;font-weight:700;}#yiv3822020232 #yiv3822020232ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3822020232 #yiv3822020232ygrp-sponsor #yiv3822020232ov li a {font-size:130%;text-decoration:none;}#yiv3822020232 #yiv3822020232ygrp-sponsor #yiv3822020232ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3822020232 #yiv3822020232ygrp-sponsor #yiv3822020232ov ul {margin:0;padding:0 0 0 8px;}#yiv3822020232 #yiv3822020232ygrp-text {font-family:Georgia;}#yiv3822020232 #yiv3822020232ygrp-text p {margin:0 0 1em 0;}#yiv3822020232 #yiv3822020232ygrp-text tt {font-size:120%;}#yiv3822020232 #yiv3822020232ygrp-vital ul li:last-child {border-right:none !important;}#yiv3822020232
Thanks again for your help.
Lew
On Sunday, May 21, 2017, 2:45:50 PM PDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
I don't know where you got a 5/21/17 version of the add-in. The version I use isn't even that up-to-date (5/20). :)
smfGetYahooHistory() is only available in a beta version that isn't documented on the website, because it's not ready for official release. See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32112
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32114
On Sun, May 21, 2017 at 2:27 PM, Yahoo! lewglenn@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
When I run the code piece:Cells(
I get a compile error with the message sub or function smfGetYahooHistory is not defined. I have downloaded the latest SMF Add-In (5/21/17) and I know that vba/EXCEL is seeing it because I have a call to RCHGetYahooQuotes previously in my code and the compiler doesn't object.
So what am I doing wrong? Is there something that I need beside the current SMF Add-In?
#yiv3822020232 #yiv3822020232 -- #yiv3822020232ygrp-
Sun May 21, 2017 3:58 pm (PDT) . Posted by:
"lswpubrw" lswpubrlw
Randy,
I downloaded the new XLA file from your link but I'm having a problem getting it to stick in my SS.
I'm trying two functions:
='C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes($A$7,"l1")
=RCHGetElementNumber("Version")
These both worked in my previous version XLA.
Both of them now return NAME? error.
If I redo the add-in through the manager I can save the XLA file from the directory and it will print out the quotes but the version function still returns NAME? If I save the file and reopen it I'm back to NAME? for all the functions. Looks like I need some basic help here.
Thanks,
Bob
lswpubrw@optonline.net
warasir@sunysuffolk.edu
bobwarasila@lswpub.com
From: Yahoo! lewglenn@yahoo.com [smf_addin]
Sent: Sunday, May 21, 2017 6:07 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Replace RCHGetYahooHistory call
My mistake; the version I was using was dated 5/3/2017. I switched to the beta version in message 32112 and it worked just fine.
Thanks again for your help.
Lew
On Sunday, May 21, 2017, 2:45:50 PM PDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
I don't know where you got a 5/21/17 version of the add-in. The version I use isn't even that up-to-date (5/20). :)
smfGetYahooHistory() is only available in a beta version that isn't documented on the website, because it's not ready for official release. See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32112
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32114
On Sun, May 21, 2017 at 2:27 PM, Yahoo! lewglenn@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
When I run the code piece:
Cells(r, "I") = Application.WorksheetFunction. Average(smfGetYahooHistory( Res, , , , "c", 0, , 50, 1))
I get a compile error with the message sub or function smfGetYahooHistory is not defined. I have downloaded the latest SMF Add-In (5/21/17) and I know that vba/EXCEL is seeing it because I have a call to RCHGetYahooQuotes previously in my code and the compiler doesn't object.
So what am I doing wrong? Is there something that I need beside the current SMF Add-In?
I downloaded the new XLA file from your link but I'm having a problem getting it to stick in my SS.
I'm trying two functions:
='C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes($A$7,"l1")
=RCHGetElementNumber("Version")
These both worked in my previous version XLA.
Both of them now return NAME? error.
If I redo the add-in through the manager I can save the XLA file from the directory and it will print out the quotes but the version function still returns NAME? If I save the file and reopen it I'm back to NAME? for all the functions. Looks like I need some basic help here.
Thanks,
Bob
lswpubrw@optonline.net
warasir@sunysuffolk.edu
bobwarasila@lswpub.com
From: Yahoo! lewglenn@yahoo.com [smf_addin]
Sent: Sunday, May 21, 2017 6:07 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Replace RCHGetYahooHistory call
My mistake; the version I was using was dated 5/3/2017. I switched to the beta version in message 32112 and it worked just fine.
Thanks again for your help.
Lew
On Sunday, May 21, 2017, 2:45:50 PM PDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
I don't know where you got a 5/21/17 version of the add-in. The version I use isn't even that up-to-date (5/20). :)
smfGetYahooHistory() is only available in a beta version that isn't documented on the website, because it's not ready for official release. See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32112
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32114
On Sun, May 21, 2017 at 2:27 PM, Yahoo! lewglenn@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
When I run the code piece:
Cells(r, "I"
I get a compile error with the message sub or function smfGetYahooHistory is not defined. I have downloaded the latest SMF Add-In (5/21/17) and I know that vba/EXCEL is seeing it because I have a call to RCHGetYahooQuotes previously in my code and the compiler doesn't object.
So what am I doing wrong? Is there something that I need beside the current SMF Add-In?
Sun May 21, 2017 3:58 pm (PDT) . Posted by:
lewglenn
I'm running the following vba code:
'Following code extracts the date & adjusted closing price of the specified equity from inception
Range("A1:B20000") = smfGetYahooHistory("TLT, , , "d", "c", 0)
and am getting a type mismatch run-time error. The previous code read:
Range("A1:B20000") = RCHGetYahooHistory("TLT", , , , , , , , "DA", 1, 1, 1, 20000, 2)
and ran without problem. I obviously am misunderstanding how smfGetYahooHistory functions. Can you please point out my error.
Thanks.
'Following code extracts the date & adjusted closing price of the specified equity from inception
Range("
and am getting a type mismatch run-time error. The previous code read:
Range("
and ran without problem. I obviously am misunderstanding how smfGetYahooHistory functions. Can you please point out my error.
Thanks.
Sun May 21, 2017 4:21 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
First of all, you should NEVER have a path in front of the function name.
If you have that in your cell, you have location errors and need to fix the
links. Running the smfFixLinks macro will usually do that.
If the "Version" function returns #NAME?, it means the add-in manager
doesn't have the add-in active. Check it and reactivate the add-in.
You may need to "unblock" the new XLA file if your Windows updates haven't
fixed the security update Microsoft did in August? See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
I haven't had this issue with either of my Win10 computers, nor did I have
it when I was running Vista.
On Sun, May 21, 2017 at 3:38 PM, 'lswpubrw' lswpubrw@
...wrote:
>
>
> Randy,
>
> I downloaded the new XLA file from your link but I'm having a problem
> getting it to stick in my SS.
>
> I'm trying two functions:
>
> ='C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!
> RCHGetYahooQuotes($A$7,"l1")
>
> =RCHGetElementNumber("Version")
>
> These both worked in my previous version XLA.
>
> Both of them now return NAME? error.
>
> If I redo the add-in through the manager I can save the XLA file from the
> directory and it will print out the quotes but the version function still
> returns NAME? If I save the file and reopen it I'm back to NAME? for all
> the functions. Looks like I need some basic help here.
>
>
>
If you have that in your cell, you have location errors and need to fix the
links. Running the smfFixLinks macro will usually do that.
If the "Version" function returns #NAME?, it means the add-in manager
doesn't have the add-in active. Check it and reactivate the add-in.
You may need to "unblock" the new XLA file if your Windows updates haven't
fixed the security update Microsoft did in August? See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
I haven't had this issue with either of my Win10 computers, nor did I have
it when I was running Vista.
On Sun, May 21, 2017 at 3:38 PM, 'lswpubrw&#
...wrote:
>
>
> Randy,
>
> I downloaded the new XLA file from your link but I'm having a problem
> getting it to stick in my SS.
>
> I'm trying two functions:
>
> ='C:\
> RCHGetYahooQuotes(
>
> =RCHGetElementNumbe
>
> These both worked in my previous version XLA.
>
> Both of them now return NAME? error.
>
> If I redo the add-in through the manager I can save the XLA file from the
> directory and it will print out the quotes but the version function still
> returns NAME? If I save the file and reopen it I'm back to NAME? for all
> the functions. Looks like I need some basic help here.
>
>
>
Sun May 21, 2017 4:41 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The "pRows" and "pCols" parameters of smfGetYahooHistory() are the
equivalent of the "pDim1" and "pDim2" parameters you were using with
RCHGetYahooHistory(). In your version of smfGetYahooHistory(), you need to
tell the function how many rows and columns of data to return, because they
are otherwise set to the size of the range you are array-entering the
formula over. And you aren't array-entering the formula over a range if you
are calling it from VBA.
Your new code will not contain the date field. I think you want "dc"
instead of "c". Also, you will default to a year's worth of data without
specifying the date parameters. Just shove a "1/1/1970"; in as your starting
date, and you should get all available data. I just hope TLT isn't one of
those with "null" values, which will cause it to error out when it hits one.
I am changing smfGetYahooHistory() so that it will default to the
"1/1/1970"; beginning date, as well as set the default # of rows and columns
for a VBA call based on the starting date and ending date it ends up asking
for from Yaho..
In my version of the function, this returns dates and adjusted closing
prices back to 7/30/02, without a header line:
Range("A1:B20000") = smfGetYahooHistory("TLT", , , "d", "dc", 0)
On Sun, May 21, 2017 at 3:58 PM, lewglenn@
...wrote:
>
> I'm running the following vba code:
>
> 'Following code extracts the date & adjusted closing price of the
> specified equity from inception
>
> Range("A1:B20000") = smfGetYahooHistory("TLT, , , "d", "c", 0)
>
> and am getting a type mismatch run-time error. The previous code read:
>
>
> Range("A1:B20000") = RCHGetYahooHistory("TLT", , , , , , , , "DA", 1, 1,
> 1, 20000, 2)
>
> and ran without problem. I obviously am misunderstanding how
> smfGetYahooHistory functions. Can you please point out my error.
>
>
equivalent of the "pDim1" and "pDim2" parameters you were using with
RCHGetYahooHistory(
tell the function how many rows and columns of data to return, because they
are otherwise set to the size of the range you are array-entering the
formula over. And you aren't array-entering the formula over a range if you
are calling it from VBA.
Your new code will not contain the date field. I think you want "dc"
instead of "c"
specifying the date parameters. Just shove a "1/1/1970"
date, and you should get all available data. I just hope TLT isn't one of
those with "null" values, which will cause it to error out when it hits one.
I am changing smfGetYahooHistory(
"1/1/1970"
for a VBA call based on the starting date and ending date it ends up asking
for from Yaho..
In my version of the function, this returns dates and adjusted closing
prices back to 7/30/02, without a header line:
Range("
On Sun, May 21, 2017 at 3:58 PM, lewglenn@
...wrote:
>
> I'm running the following vba code:
>
> 'Following code extracts the date & adjusted closing price of the
> specified equity from inception
>
> Range("
>
> and am getting a type mismatch run-time error. The previous code read:
>
>
> Range("
> 1, 20000, 2)
>
> and ran without problem. I obviously am misunderstanding how
> smfGetYahooHistory functions. Can you please point out my error.
>
>
Sun May 21, 2017 5:14 pm (PDT) . Posted by:
"Yahoo!" lewglenn
I'm still getting the type mismatch error with:
Range("A1:B20000") = smfGetYahooHistory("TLT", "1/1/1970", , "d", "dc", 0)
Where could that be coming from?
On Sunday, May 21, 2017, 4:41:33 PM PDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
The "pRows" and "pCols" parameters of smfGetYahooHistory() are the equivalent of the "pDim1" and "pDim2" parameters you were using with RCHGetYahooHistory(). In your version of smfGetYahooHistory(), you need to tell the function how many rows and columns of data to return, because they are otherwise set to the size of the range you are array-entering the formula over. And you aren't array-entering the formula over a range if you are calling it from VBA.
Your new code will not contain the date field. I think you want "dc" instead of "c". Also, you will default to a year's worth of data without specifying the date parameters. Just shove a "1/1/1970"; in as your starting date, and you should get all available data. I just hope TLT isn't one of those with "null" values, which will cause it to error out when it hits one.
I am changing smfGetYahooHistory() so that it will default to the "1/1/1970"; beginning date, as well as set the default # of rows and columns for a VBA call based on the starting date and ending date it ends up asking for from Yaho..
In my version of the function, this returns dates and adjusted closing prices back to 7/30/02, without a header line:
Range("A1:B20000") = smfGetYahooHistory("TLT", , , "d", "dc", 0)
On Sun, May 21, 2017 at 3:58 PM, lewglenn@...wrote:
I'm running the following vba code:
'Following code extracts the date & adjusted closing price of the specified equity from inception
Range("A1:B20000") = smfGetYahooHistory("TLT, , , "d", "c", 0)
and am getting a type mismatch run-time error. The previous code read:
Range("A1:B20000") = RCHGetYahooHistory("TLT", , , , , , , , "DA", 1, 1, 1, 20000, 2)
and ran without problem. I obviously am misunderstanding how smfGetYahooHistory functions. Can you please point out my error.
#yiv7919376456 #yiv7919376456 -- #yiv7919376456ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7919376456 #yiv7919376456ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7919376456 #yiv7919376456ygrp-mkp #yiv7919376456hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7919376456 #yiv7919376456ygrp-mkp #yiv7919376456ads {margin-bottom:10px;}#yiv7919376456 #yiv7919376456ygrp-mkp .yiv7919376456ad {padding:0 0;}#yiv7919376456 #yiv7919376456ygrp-mkp .yiv7919376456ad p {margin:0;}#yiv7919376456 #yiv7919376456ygrp-mkp .yiv7919376456ad a {color:#0000ff;text-decoration:none;}#yiv7919376456 #yiv7919376456ygrp-sponsor #yiv7919376456ygrp-lc {font-family:Arial;}#yiv7919376456 #yiv7919376456ygrp-sponsor #yiv7919376456ygrp-lc #yiv7919376456hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7919376456 #yiv7919376456ygrp-sponsor #yiv7919376456ygrp-lc .yiv7919376456ad {margin-bottom:10px;padding:0 0;}#yiv7919376456 #yiv7919376456actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7919376456 #yiv7919376456activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7919376456 #yiv7919376456activity span {font-weight:700;}#yiv7919376456 #yiv7919376456activity span:first-child {text-transform:uppercase;}#yiv7919376456 #yiv7919376456activity span a {color:#5085b6;text-decoration:none;}#yiv7919376456 #yiv7919376456activity span span {color:#ff7900;}#yiv7919376456 #yiv7919376456activity span .yiv7919376456underline {text-decoration:underline;}#yiv7919376456 .yiv7919376456attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7919376456 .yiv7919376456attach div a {text-decoration:none;}#yiv7919376456 .yiv7919376456attach img {border:none;padding-right:5px;}#yiv7919376456 .yiv7919376456attach label {display:block;margin-bottom:5px;}#yiv7919376456 .yiv7919376456attach label a {text-decoration:none;}#yiv7919376456 blockquote {margin:0 0 0 4px;}#yiv7919376456 .yiv7919376456bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7919376456 .yiv7919376456bold a {text-decoration:none;}#yiv7919376456 dd.yiv7919376456last p a {font-family:Verdana;font-weight:700;}#yiv7919376456 dd.yiv7919376456last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7919376456 dd.yiv7919376456last p span.yiv7919376456yshortcuts {margin-right:0;}#yiv7919376456 div.yiv7919376456attach-table div div a {text-decoration:none;}#yiv7919376456 div.yiv7919376456attach-table {width:400px;}#yiv7919376456 div.yiv7919376456file-title a, #yiv7919376456 div.yiv7919376456file-title a:active, #yiv7919376456 div.yiv7919376456file-title a:hover, #yiv7919376456 div.yiv7919376456file-title a:visited {text-decoration:none;}#yiv7919376456 div.yiv7919376456photo-title a, #yiv7919376456 div.yiv7919376456photo-title a:active, #yiv7919376456 div.yiv7919376456photo-title a:hover, #yiv7919376456 div.yiv7919376456photo-title a:visited {text-decoration:none;}#yiv7919376456 div#yiv7919376456ygrp-mlmsg #yiv7919376456ygrp-msg p a span.yiv7919376456yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7919376456 .yiv7919376456green {color:#628c2a;}#yiv7919376456 .yiv7919376456MsoNormal {margin:0 0 0 0;}#yiv7919376456 o {font-size:0;}#yiv7919376456 #yiv7919376456photos div {float:left;width:72px;}#yiv7919376456 #yiv7919376456photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7919376456 #yiv7919376456photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7919376456 #yiv7919376456reco-category {font-size:77%;}#yiv7919376456 #yiv7919376456reco-desc {font-size:77%;}#yiv7919376456 .yiv7919376456replbq {margin:4px;}#yiv7919376456 #yiv7919376456ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7919376456 #yiv7919376456ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7919376456 #yiv7919376456ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7919376456 #yiv7919376456ygrp-mlmsg select, #yiv7919376456 input, #yiv7919376456 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7919376456 #yiv7919376456ygrp-mlmsg pre, #yiv7919376456 code {font:115% monospace;}#yiv7919376456 #yiv7919376456ygrp-mlmsg * {line-height:1.22em;}#yiv7919376456 #yiv7919376456ygrp-mlmsg #yiv7919376456logo {padding-bottom:10px;}#yiv7919376456 #yiv7919376456ygrp-msg p a {font-family:Verdana;}#yiv7919376456 #yiv7919376456ygrp-msg p#yiv7919376456attach-count span {color:#1E66AE;font-weight:700;}#yiv7919376456 #yiv7919376456ygrp-reco #yiv7919376456reco-head {color:#ff7900;font-weight:700;}#yiv7919376456 #yiv7919376456ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7919376456 #yiv7919376456ygrp-sponsor #yiv7919376456ov li a {font-size:130%;text-decoration:none;}#yiv7919376456 #yiv7919376456ygrp-sponsor #yiv7919376456ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7919376456 #yiv7919376456ygrp-sponsor #yiv7919376456ov ul {margin:0;padding:0 0 0 8px;}#yiv7919376456 #yiv7919376456ygrp-text {font-family:Georgia;}#yiv7919376456 #yiv7919376456ygrp-text p {margin:0 0 1em 0;}#yiv7919376456 #yiv7919376456ygrp-text tt {font-size:120%;}#yiv7919376456 #yiv7919376456ygrp-vital ul li:last-child {border-right:none !important;}#yiv7919376456
Range("A1:B20000") = smfGetYahooHistory("TLT", "1/1/1970", , "d", "dc", 0)
Where could that be coming from?
On Sunday, May 21, 2017, 4:41:33 PM PDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
The "pRows" and "pCols" parameters of smfGetYahooHistory(
Your new code will not contain the date field. I think you want "dc" instead of "c"
I am changing smfGetYahooHistory(
In my version of the function, this returns dates and adjusted closing prices back to 7/30/02, without a header line:
Range("
On Sun, May 21, 2017 at 3:58 PM, lewglenn@...wrote:
I'm running the following vba code:
'Following code extracts the date & adjusted closing price of the specified equity from inception
Range("
and am getting a type mismatch run-time error. The previous code read:
Range("
and ran without problem. I obviously am misunderstanding how smfGetYahooHistory functions. Can you please point out my error.
#yiv7919376456 #yiv7919376456 -- #yiv7919376456ygrp-
Sun May 21, 2017 2:39 pm (PDT) . Posted by:
marco.deen
Randy,
I would like to pull swap rates into excel from this page
http://www.myfxbook.com/forex-broker-swaps/ic-markets/312 http://www.myfxbook.com/forex-broker-swaps/ic-markets/312
I did manage to pull the data into your "Quickwebpage Examination" file and can refer to that file, but I'm wondering how to construct the Gettablecell formula.
I tried
=RCHGetTableCell("http://www.myfxbook.com/forex-broker-swaps/ic-markets/312",3,>Symbol,,,1,</table,,"--") to pull the short swap for AUDCAD but get a message that the formula is incorrect. Can you start me up?
I would like to pull swap rates into excel from this page
http://www.myfxbook.com/forex-broker-swaps/ic-markets/312 http://www.myfxbook.com/forex-broker-swaps/ic-markets/312
I did manage to pull the data into your "Quickwebpage Examination" file and can refer to that file, but I'm wondering how to construct the Gettablecell formula.
I tried
=RCHGetTableCell("http://www.myfxbook.com/forex-broker-swaps/ic-markets/312",3,>
Sun May 21, 2017 3:00 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I would just use:
=RCHGetTableCell("http://www.myfxbook.com/forex-broker-swaps/ic-markets/312
",1,">AUDCAD")
Your version works if you pass correct values for the parameters. That is:
=RCHGetTableCell("http://www.myfxbook.com/forex-broker-swaps/ic-markets/312
",3,">Symbol",,,,1,"</table",,"--")
You were missing a comma and needed double quotes around the strings.
On Sun, May 21, 2017 at 2:39 PM, marco.deen@
...wrote:
>
> I would like to pull swap rates into excel from this page
>
> http://www.myfxbook.com/forex-broker-swaps/ic-markets/312
>
> I did manage to pull the data into your "Quickwebpage Examination" file
> and can refer to that file, but I'm wondering how to construct the
> Gettablecell formula.
>
> I tried
>
> =
>
> RCHGetTableCell("http://www.myfxbook.com/forex-broker-swaps/ic-markets/312
> ",3,>Symbol,,,1,</table,,"--") to pull the short swap for AUDCAD but get
> a message that the formula is incorrect. Can you start me up?
>
>
>
=RCHGetTableCell("http://www.myfxbook.com/forex-broker-swaps/ic-markets/312
",1,">AUDCAD")
Your version works if you pass correct values for the parameters. That is:
=RCHGetTableCell("http://www.myfxbook.com/forex-broker-swaps/ic-markets/312
",3,">Symbol",,,,1,"</table",,"--")
You were missing a comma and needed double quotes around the strings.
On Sun, May 21, 2017 at 2:39 PM, marco.deen@
...wrote:
>
> I would like to pull swap rates into excel from this page
>
> http://www.myfxbook.com/forex-broker-swaps/ic-markets/312
>
> I did manage to pull the data into your "Quickwebpage Examination" file
> and can refer to that file, but I'm wondering how to construct the
> Gettablecell formula.
>
> I tried
>
> =
>
> RCHGetTableCell("http://www.myfxbook.com/forex-broker-swaps/ic-markets/312
> ",3,>
> a message that the formula is incorrect. Can you start me up?
>
>
>
Sun May 21, 2017 3:28 pm (PDT) . Posted by:
dcharlotte99
The 'Works in Progress' folder seems to be all Excel .xls files, I was expecting a new .xla file (ie. RCH_Stock_Market_Functions.xla) ? -I'm having these issues with the historical Yahoo quotes.
Thank you Randy for addressing this issue, apologize for my misunderstanding.
Thank you Randy for addressing this issue, apologize for my misunderstanding.
Sun May 21, 2017 3:43 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The beta version of the XLA file is *not* documented on the web site. It is
only accessible via a direct link. See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32112
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32114
It was intended for people to test. Not necessarily for people to just get
things up and running again. Because I may need to change parameters and
processing. So updating a number of workbooks to use the new formula could
mean all of those workbooks will need to be changed again if I make changes
to the function.
On Sun, May 21, 2017 at 3:28 PM, dcharlotte99@
...wrote:
>
> The 'Works in Progress' folder seems to be all Excel .xls files, I was
> expecting a new .xla file (ie. RCH_Stock_Market_Functions.xla) ? -I'm
> having these issues with the historical Yahoo quotes.
>
> Thank you Randy for addressing this issue, apologize for my
> misunderstanding.
>
>
only accessible via a direct link. See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32112
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32114
It was intended for people to test. Not necessarily for people to just get
things up and running again. Because I may need to change parameters and
processing. So updating a number of workbooks to use the new formula could
mean all of those workbooks will need to be changed again if I make changes
to the function.
On Sun, May 21, 2017 at 3:28 PM, dcharlotte99@
...wrote:
>
> The 'Works in Progress' folder seems to be all Excel .xls files, I was
> expecting a new .xla file (ie. RCH_Stock_Market_
> having these issues with the historical Yahoo quotes.
>
> Thank you Randy for addressing this issue, apologize for my
> misunderstanding.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar