15 Messages
Digest #4027
7
smfPricesByDates-Example-Stocks-By-Dates returns error by "Rico Teikotte" dzi6ewzrdnxj7wkxo5f6mlhps7ydjxexnjzqjzdg
Messages
Mon May 22, 2017 8:18 pm (PDT) . Posted by:
"lswpubrw" lswpubrlw
Randy,
Quotes were the problem on the Version! I had cut and pasted from one of the e-mails. My e-mail client apparently forces the right/left quote marks. So now everything in the Ver. 2.1.2014.1.30 is OK for current quotes. Tomorrow I'll play with unblocking the new version and see how that goes.
Thanks
Bob
lswpubrw@optonline.net
warasir@sunysuffolk.edu
bobwarasila@lswpub.com
From: Randy Harmelink rharmelink@gmail.com [smf_addin]
Sent: Monday, May 22, 2017 9:12 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] installation.
RCHGetYahooQuotes() wasn't changed.
The "Version" formula doesn't even do anything with the Internet. A #VALUE? error often means the wrong type of parameter is being passed. I notice your quotation below use a left double quote and a right double quote instead of the normal double quote. Is that the problem?
On Mon, May 22, 2017 at 4:57 PM, 'lswpubrw' lswpubrw@optonline.net [smf_addin] <smf_addin@yahoogroups.com> wrote:
I went backwards and reinstalled the XLA that's on the web site. Had to redo the add-in manager and it works fine with the RCHGetYahooQuotes function. However the RCHGetElementNumber("Version") returns #VALUE?. At least I'm back to extracting quotes. For some reason the 5/21/2017 version doesn't work with this spreadsheet:^ ( Do I have to change the =RCHGetYahooQuotes(#,#) somehow?
Quotes were the problem on the Version! I had cut and pasted from one of the e-mails. My e-mail client apparently forces the right/left quote marks. So now everything in the Ver. 2.1.2014.1.30 is OK for current quotes. Tomorrow I'll play with unblocking the new version and see how that goes.
Thanks
Bob
lswpubrw@optonline.net
warasir@sunysuffolk.edu
bobwarasila@lswpub.com
From: Randy Harmelink rharmelink@gmail.com [smf_addin]
Sent: Monday, May 22, 2017 9:12 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] installation.
RCHGetYahooQuotes() wasn't changed.
The "Version" formula doesn't even do anything with the Internet. A #VALUE? error often means the wrong type of parameter is being passed. I notice your quotation below use a left double quote and a right double quote instead of the normal double quote. Is that the problem?
On Mon, May 22, 2017 at 4:57 PM, 'lswpubrw' lswpubrw@optonline.net [smf_addin] <smf_addin@yahoogroups.com> wrote:
I went backwards and reinstalled the XLA that's on the web site. Had to redo the add-in manager and it works fine with the RCHGetYahooQuotes function. However the RCHGetElementNumber
Tue May 23, 2017 4:19 am (PDT) . Posted by:
lexstar
Is there a reason why I am only getting an OPEN price when I array this
TRANSPOSE(smfGetYahooHistory($B5,C$4,D$4,"m","ohlc";,0,1,0,D$4-C$4))
The old RCHGetYahooHIstory() gives the OHLC for the specific dates in C$4 to D$4
Any ideas helpful.
THx
TRANSPOSE(smfGetYah
The old RCHGetYahooHIstory(
Any ideas helpful.
THx
Tue May 23, 2017 12:30 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It wouldn't have worked with the 2017-05-18 version of the add-in (because
pRows is set to zero), but it's working fine for me using 2017-05-21
version:
2017-01-01 2017-05-23
MMM $176.65 $173.04 $186.97 $190.73 $194.34 $198.86
$177.81 $186.11 $192.35 $195.95 $198.72 $198.97
$171.69 $171.43 $186.90 $187.50 $192.39 $197.99
$172.69 $184.08 $190.20 $194.67 $197.34 $198.09
With the 2017-05-21 version, all you need is:
=TRANSPOSE(smfGetYahooHistory($B5,C$4,D$4,"m","ohlc";,0,1))
On Tue, May 23, 2017 at 4:19 AM, lexstar@
...wrote:
>
> Is there a reason why I am only getting an OPEN price when I array this
>
> TRANSPOSE(smfGetYahooHistory($B5,C$4,D$4,"m","ohlc";,0,1,0,D$4-C$4))
>
> The old RCHGetYahooHIstory() gives the OHLC for the specific dates in C$4
> to D$4
>
>
>
pRows is set to zero), but it's working fine for me using 2017-05-21
version:
2017-01-01 2017-05-23
MMM $176.65 $173.04 $186.97 $190.73 $194.34 $198.86
$177.81 $186.11 $192.35 $195.95 $198.72 $198.97
$171.69 $171.43 $186.90 $187.50 $192.39 $197.99
$172.69 $184.08 $190.20 $194.67 $197.34 $198.09
With the 2017-05-21 version, all you need is:
=TRANSPOSE(smfGetYa
On Tue, May 23, 2017 at 4:19 AM, lexstar@
...wrote:
>
> Is there a reason why I am only getting an OPEN price when I array this
>
> TRANSPOSE(smfGetYah
>
> The old RCHGetYahooHIstory(
> to D$4
>
>
>
Tue May 23, 2017 1:38 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
P.S. Monthly data will not have correct dividend adjustments, because they
need to be applied on the day that they go ex-dividend.
On Tue, May 23, 2017 at 4:19 AM, lexstar@
...wrote:
>
> Is there a reason why I am only getting an OPEN price when I array this
>
> TRANSPOSE(smfGetYahooHistory($B5,C$4,D$4,"m","ohlc";,0,1,0,D$4-C$4))
>
> The old RCHGetYahooHIstory() gives the OHLC for the specific dates in C$4
> to D$4
>
>
>
need to be applied on the day that they go ex-dividend.
On Tue, May 23, 2017 at 4:19 AM, lexstar@
...wrote:
>
> Is there a reason why I am only getting an OPEN price when I array this
>
> TRANSPOSE(smfGetYah
>
> The old RCHGetYahooHIstory(
> to D$4
>
>
>
Tue May 23, 2017 5:45 am (PDT) . Posted by:
pjwdoyle
Hi Randy; the basic stock history function as described would be great.
I don't think the Yahoo History function itself has to be customizable for all the different definitions of periods, as users can build that themselves.
I don't think the Yahoo History function itself has to be customizable for all the different definitions of periods, as users can build that themselves.
Tue May 23, 2017 7:23 am (PDT) . Posted by:
"Gerard Trofub" trofub
Hello Randy,
Thank you for all your answers and work.Please see after the result, I have for this exemple ?
The xla file is the last that you have given us (dated May 21st)In case I use date D3 in function, I get always "Date" as an answer.Is it correct format ?Many thanks,
Gérard
Le Mardi 23 mai 2017 14h45, "pjwdoyle@yahoo.com [smf_addin]" <smf_addin@yahoogroups.com> a écrit :
Hi Randy; the basic stock history function as described would be great.
I don't think the Yahoo History function itself has to be customizable for all the different definitions of periods, as users can build that themselves. #yiv7534272138 -- #yiv7534272138ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7534272138 #yiv7534272138ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7534272138 #yiv7534272138ygrp-mkp #yiv7534272138hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7534272138 #yiv7534272138ygrp-mkp #yiv7534272138ads {margin-bottom:10px;}#yiv7534272138 #yiv7534272138ygrp-mkp .yiv7534272138ad {padding:0 0;}#yiv7534272138 #yiv7534272138ygrp-mkp .yiv7534272138ad p {margin:0;}#yiv7534272138 #yiv7534272138ygrp-mkp .yiv7534272138ad a {color:#0000ff;text-decoration:none;}#yiv7534272138 #yiv7534272138ygrp-sponsor #yiv7534272138ygrp-lc {font-family:Arial;}#yiv7534272138 #yiv7534272138ygrp-sponsor #yiv7534272138ygrp-lc #yiv7534272138hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7534272138 #yiv7534272138ygrp-sponsor #yiv7534272138ygrp-lc .yiv7534272138ad {margin-bottom:10px;padding:0 0;}#yiv7534272138 #yiv7534272138actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7534272138 #yiv7534272138activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7534272138 #yiv7534272138activity span {font-weight:700;}#yiv7534272138 #yiv7534272138activity span:first-child {text-transform:uppercase;}#yiv7534272138 #yiv7534272138activity span a {color:#5085b6;text-decoration:none;}#yiv7534272138 #yiv7534272138activity span span {color:#ff7900;}#yiv7534272138 #yiv7534272138activity span .yiv7534272138underline {text-decoration:underline;}#yiv7534272138 .yiv7534272138attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7534272138 .yiv7534272138attach div a {text-decoration:none;}#yiv7534272138 .yiv7534272138attach img {border:none;padding-right:5px;}#yiv7534272138 .yiv7534272138attach label {display:block;margin-bottom:5px;}#yiv7534272138 .yiv7534272138attach label a {text-decoration:none;}#yiv7534272138 blockquote {margin:0 0 0 4px;}#yiv7534272138 .yiv7534272138bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7534272138 .yiv7534272138bold a {text-decoration:none;}#yiv7534272138 dd.yiv7534272138last p a {font-family:Verdana;font-weight:700;}#yiv7534272138 dd.yiv7534272138last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7534272138 dd.yiv7534272138last p span.yiv7534272138yshortcuts {margin-right:0;}#yiv7534272138 div.yiv7534272138attach-table div div a {text-decoration:none;}#yiv7534272138 div.yiv7534272138attach-table {width:400px;}#yiv7534272138 div.yiv7534272138file-title a, #yiv7534272138 div.yiv7534272138file-title a:active, #yiv7534272138 div.yiv7534272138file-title a:hover, #yiv7534272138 div.yiv7534272138file-title a:visited {text-decoration:none;}#yiv7534272138 div.yiv7534272138photo-title a, #yiv7534272138 div.yiv7534272138photo-title a:active, #yiv7534272138 div.yiv7534272138photo-title a:hover, #yiv7534272138 div.yiv7534272138photo-title a:visited {text-decoration:none;}#yiv7534272138 div#yiv7534272138ygrp-mlmsg #yiv7534272138ygrp-msg p a span.yiv7534272138yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7534272138 .yiv7534272138green {color:#628c2a;}#yiv7534272138 .yiv7534272138MsoNormal {margin:0 0 0 0;}#yiv7534272138 o {font-size:0;}#yiv7534272138 #yiv7534272138photos div {float:left;width:72px;}#yiv7534272138 #yiv7534272138photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7534272138 #yiv7534272138photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7534272138 #yiv7534272138reco-category {font-size:77%;}#yiv7534272138 #yiv7534272138reco-desc {font-size:77%;}#yiv7534272138 .yiv7534272138replbq {margin:4px;}#yiv7534272138 #yiv7534272138ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7534272138 #yiv7534272138ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7534272138 #yiv7534272138ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7534272138 #yiv7534272138ygrp-mlmsg select, #yiv7534272138 input, #yiv7534272138 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7534272138 #yiv7534272138ygrp-mlmsg pre, #yiv7534272138 code {font:115% monospace;}#yiv7534272138 #yiv7534272138ygrp-mlmsg * {line-height:1.22em;}#yiv7534272138 #yiv7534272138ygrp-mlmsg #yiv7534272138logo {padding-bottom:10px;}#yiv7534272138 #yiv7534272138ygrp-msg p a {font-family:Verdana;}#yiv7534272138 #yiv7534272138ygrp-msg p#yiv7534272138attach-count span {color:#1E66AE;font-weight:700;}#yiv7534272138 #yiv7534272138ygrp-reco #yiv7534272138reco-head {color:#ff7900;font-weight:700;}#yiv7534272138 #yiv7534272138ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7534272138 #yiv7534272138ygrp-sponsor #yiv7534272138ov li a {font-size:130%;text-decoration:none;}#yiv7534272138 #yiv7534272138ygrp-sponsor #yiv7534272138ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7534272138 #yiv7534272138ygrp-sponsor #yiv7534272138ov ul {margin:0;padding:0 0 0 8px;}#yiv7534272138 #yiv7534272138ygrp-text {font-family:Georgia;}#yiv7534272138 #yiv7534272138ygrp-text p {margin:0 0 1em 0;}#yiv7534272138 #yiv7534272138ygrp-text tt {font-size:120%;}#yiv7534272138 #yiv7534272138ygrp-vital ul li:last-child {border-right:none !important;}#yiv7534272138
Thank you for all your answers and work.Please see after the result, I have for this exemple ?
The xla file is the last that you have given us (dated May 21st)In case I use date D3 in function, I get always "Date" as an answer.Is it correct format ?Many thanks,
Gérard
Le Mardi 23 mai 2017 14h45, "pjwdoyle@yahoo.com [smf_addin]" <smf_addin@yahoogroups.com> a écrit :
Hi Randy; the basic stock history function as described would be great.
I don't think the Yahoo History function itself has to be customizable for all the different definitions of periods, as users can build that themselves. #yiv7534272138 -- #yiv7534272138ygrp-
Attachment(s) from Gerard Trofub
1 of 1 Photo(s)
Tue May 23, 2017 9:37 am (PDT) . Posted by:
"Craig Passow" passow
Refer back to Randy's previous answer to your question. The formula
needs to be array-entered across a range of cells large enough to
display all of the returned results. If you're not familiar with the
term "array-entered", a quick internet search will provide lots of
explanation and examples.
As an aside, it's a lot easier to follow an email discussion if you
reply to the previous message in the chain instead of an unrelated
message as was done in this case.
On 5/23/2017 9:23 AM, Gerard Trofub trofub@yahoo.fr [smf_addin] wrote:
>
> [Attachment(s) <#TopText> from Gerard Trofub included below]
> Hello Randy,
>
> Thank you for all your answers and work.
> Please see after the result, I have for this exemple ?
>
> Image en ligne
>
> The xla file is the last that you have given us (dated May 21st)
> In case I use date D3 in function, I get always "Date" as an answer.
> Is it correct format ?
> Many thanks,
>
> Gérard
>
> Le Mardi 23 mai 2017 14h45, "pjwdoyle@yahoo.com [smf_addin]"
> <smf_addin@yahoogroups.com> a écrit :
>
>
>
>
>
> Hi Randy; the basic stock history function as described would be great.
>
> I don't think the Yahoo History function itself has to be customizable
> for all the different definitions of periods, as users can build that
> themselves.
>
>
>
needs to be array-entered across a range of cells large enough to
display all of the returned results. If you're not familiar with the
term "array-entered", a quick internet search will provide lots of
explanation and examples.
As an aside, it's a lot easier to follow an email discussion if you
reply to the previous message in the chain instead of an unrelated
message as was done in this case.
On 5/23/2017 9:23 AM, Gerard Trofub trofub@yahoo.fr [smf_addin] wrote:
>
> [Attachment(s) <#TopText> from Gerard Trofub included below]
> Hello Randy,
>
> Thank you for all your answers and work.
> Please see after the result, I have for this exemple ?
>
> Image en ligne
>
> The xla file is the last that you have given us (dated May 21st)
> In case I use date D3 in function, I get always "Date" as an answer.
> Is it correct format ?
> Many thanks,
>
> Gérard
>
> Le Mardi 23 mai 2017 14h45, "pjwdoyle@yahoo.com [smf_addin]"
> <smf_addin@yahoogroups.com> a écrit :
>
>
>
>
>
> Hi Randy; the basic stock history function as described would be great.
>
> I don't think the Yahoo History function itself has to be customizable
> for all the different definitions of periods, as users can build that
> themselves.
>
>
>
Tue May 23, 2017 12:52 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
If you want more than "Date" returned, you need to array-enter the formula
over a range. When you enter the formula into a single cell, it can only
display the first row and first column of the data returned by the function.
On Tue, May 23, 2017 at 7:23 AM, Gerard Trofub trofub@
...wrote:
>
> Thank you for all your answers and work.
> Please see after the result, I have for this exemple ?
>
> [image: Image en ligne]
>
> The xla file is the last that you have given us (dated May 21st)
> In case I use date D3 in function, I get always "Date" as an answer.
> Is it correct format ?
> Many thanks,
>
over a range. When you enter the formula into a single cell, it can only
display the first row and first column of the data returned by the function.
On Tue, May 23, 2017 at 7:23 AM, Gerard Trofub trofub@
...wrote:
>
> Thank you for all your answers and work.
> Please see after the result, I have for this exemple ?
>
> [image: Image en ligne]
>
> The xla file is the last that you have given us (dated May 21st)
> In case I use date D3 in function, I get always "Date" as an answer.
> Is it correct format ?
> Many thanks,
>
Tue May 23, 2017 10:41 am (PDT) . Posted by:
lewglenn
I was previously using the call:
Range("A1:B20000") = RCHGetYahooHistory("IEF", , , , , , , , "DA", 1, 1, 1, 20000, 2) to get Dates (in chronological order in Column A and Adjusted Close in column B (with headers in A1 and B1).
With the switch to smfGetYahooHistory I used:
Range("A1:B20000") = smfGetYahooHistory("IEF", , , "d", "dc", 0)
This gave me un-formatted dates in Column A (which only gets me the dates I want if I formally format the column as Date) and adjusted close in column B. In addition, both columns are now in reverse chronological order and there are no headers, with data beginning in row 1 instead of row 2.
What parameter settings should be used in the smfGetYahooHistory call to get results identical to those with the old RCHGetYahooHistory call?
Many thanks for your help.
Range("
With the switch to smfGetYahooHistory I used:
Range("
This gave me un-formatted dates in Column A (which only gets me the dates I want if I formally format the column as Date) and adjusted close in column B. In addition, both columns are now in reverse chronological order and there are no headers, with data beginning in row 1 instead of row 2.
What parameter settings should be used in the smfGetYahooHistory call to get results identical to those with the old RCHGetYahooHistory call?
Many thanks for your help.
Tue May 23, 2017 11:57 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Well, the parameter you pass say to drop the headers and use reverse
chronological order...try:
=smfGetYahooHistory("IEF", , , "d", "dc", ,1)
The date difference is that you used to get string values returned and now
it is returning EXCEL serial dates. So, yes, they will need to be
formatted. Before, you could never reformat them, because date formats
would not apply to a string.
On Tue, May 23, 2017 at 10:12 AM, lewglenn@
...wrote:
>
> I was previously using the call:
>
> Range("A1:B20000") = RCHGetYahooHistory("IEF", , , , , , , , "DA", 1, 1,
> 1, 20000, 2) to get Dates (in chronological order in Column A and Adjusted
> Close in column B (with headers in A1 and B1).
>
> With the switch to smfGetYahooHistory I used:
>
> Range("A1:B20000") = smfGetYahooHistory("IEF", , , "d", "dc", 0)
>
> This gave me un-formatted dates in Column A (which only gets me the dates
> I want if I formally format the column as Date) and adjusted close in
> column B. In addition, both columns are now in reverse chronological order
> and there are no headers, with data beginning in row 1 instead of row 2.
>
> What parameter settings should be used in the smfGetYahooHistory call to
> get results identical to those with the old RCHGetYahooHistory call?
>
> Many thanks for your help.
>
>
chronological order...try:
=smfGetYahooHistory
The date difference is that you used to get string values returned and now
it is returning EXCEL serial dates. So, yes, they will need to be
formatted. Before, you could never reformat them, because date formats
would not apply to a string.
On Tue, May 23, 2017 at 10:12 AM, lewglenn@
...wrote:
>
> I was previously using the call:
>
> Range("
> 1, 20000, 2) to get Dates (in chronological order in Column A and Adjusted
> Close in column B (with headers in A1 and B1).
>
> With the switch to smfGetYahooHistory I used:
>
> Range("
>
> This gave me un-formatted dates in Column A (which only gets me the dates
> I want if I formally format the column as Date) and adjusted close in
> column B. In addition, both columns are now in reverse chronological order
> and there are no headers, with data beginning in row 1 instead of row 2.
>
> What parameter settings should be used in the smfGetYahooHistory call to
> get results identical to those with the old RCHGetYahooHistory call?
>
> Many thanks for your help.
>
>
Tue May 23, 2017 1:38 pm (PDT) . Posted by:
"Craig Passow" passow
I found the example spreadsheet provided in message 32112 to be very
instructive.
On 5/23/2017 12:12 PM, lewglenn@yahoo.com [smf_addin] wrote:
>
>
> I was previously using the call:
>
> Range("A1:B20000") = RCHGetYahooHistory("IEF", , , , , , , , "DA", 1,
> 1, 1, 20000, 2) to get Dates (in chronological order in Column A and
> Adjusted Close in column B (with headers in A1 and B1).
>
> With the switch to smfGetYahooHistory I used:
>
> Range("A1:B20000") = smfGetYahooHistory("IEF", , , "d", "dc", 0)
>
> This gave me un-formatted dates in Column A (which only gets me the
> dates I want if I formally format the column as Date) and adjusted
> close in column B. In addition, both columns are now in reverse
> chronological order and there are no headers, with data beginning in
> row 1 instead of row 2.
>
> What parameter settings should be used in the smfGetYahooHistory call
> to get results identical to those with the old RCHGetYahooHistory call?
>
> Many thanks for your help.
>
>
>
instructive.
On 5/23/2017 12:12 PM, lewglenn@yahoo.com [smf_addin] wrote:
>
>
> I was previously using the call:
>
> Range("
> 1, 1, 20000, 2) to get Dates (in chronological order in Column A and
> Adjusted Close in column B (with headers in A1 and B1).
>
> With the switch to smfGetYahooHistory I used:
>
> Range("
>
> This gave me un-formatted dates in Column A (which only gets me the
> dates I want if I formally format the column as Date) and adjusted
> close in column B. In addition, both columns are now in reverse
> chronological order and there are no headers, with data beginning in
> row 1 instead of row 2.
>
> What parameter settings should be used in the smfGetYahooHistory call
> to get results identical to those with the old RCHGetYahooHistory call?
>
> Many thanks for your help.
>
>
>
Tue May 23, 2017 11:27 am (PDT) . Posted by:
lewglenn
I was previously using the call:
Range("A1:B20000") = RCHGetYahooHistory("IEF", , , , , , , , "DA", 1, 1, 1, 20000, 2)
This gave me dates (in chronological order in column "A") and adjusted closing prices in column "B" with headers in row 1 and data beginning in row2.
I replaced this with the call:
Range("A1:B20000") = smfGetYahooHistory("IEF", "1/1/1970";, , "d", "dc", 0)
This gives dates (in reverse chrnological order in column "A" AND the dates are unformatted, i.e., I need to format the column as Date to get what I had before) AND there are no headers, i.e., the data begin in row 1 instead of row 2.
Can you tell me what parameters I need to use in the smfGetYahooHistoy call to get the results I had previously with RCHGetYahooHistory?
Thanks.
Range("
This gave me dates (in chronological order in column "A"
I replaced this with the call:
Range("
This gives dates (in reverse chrnological order in column "A" AND the dates are unformatted, i.e., I need to format the column as Date to get what I had before) AND there are no headers, i.e., the data begin in row 1 instead of row 2.
Can you tell me what parameters I need to use in the smfGetYahooHistoy call to get the results I had previously with RCHGetYahooHistory?
Thanks.
Tue May 23, 2017 11:58 am (PDT) . Posted by:
nanofanboyyeahbaby
Group has grown so large that I was unsuccessful at searching for this topic. New computer/new install. Can't remember the steps involved to import force calculate into macro any help would be much appreciated. I'm running excel 2010. thanks for the continued sort, Randy. Wish I knew how to do what you do. Always impressed.
Tue May 23, 2017 12:14 pm (PDT) . Posted by:
"Rico Teikotte" dzi6ewzrdnxj7wkxo5f6mlhps7ydjxexnjzqjzdg
Hello Randy,
I tried to start a new topic but I can't find it on the dashboard.So I don't know whether you'll receive my question.Therefore I try to contact you this way.
My question is:
-------------------------------------------------Hello Randy, all,
I've a problem with the smfPricesByDates-Example-Stocks-By-Dates SMF file.The file returns for all fields and tickers an #N/A error.
I'm using Excel 2007. Other details: Stock Market Functions add-in, Version 2.1.2017.05.03 (C:\SMF Add-IN; Windows (32-bit) NT 6.02; 12.0; ; ; 31)
I've attached a screenshot of the errors.
Could you please advise on what to do?Many thanks in advance!
Regards,Rico------------------------------------------------
Many thanks in advance!
Regards,Rico
Sent from Yahoo Mail. Get the app
I tried to start a new topic but I can't find it on the dashboard.So I don't know whether you'll receive my question.Therefore I try to contact you this way.
My question is:
------------
I've a problem with the smfPricesByDates
I'm using Excel 2007. Other details: Stock Market Functions add-in, Version 2.1.2017.05.
I've attached a screenshot of the errors.
Could you please advise on what to do?Many thanks in advance!
Regards,Rico-
Many thanks in advance!
Regards,Rico
Sent from Yahoo Mail. Get the app
Attachment(s) from Rico Teikotte
1 of 1 Photo(s)
Tue May 23, 2017 1:09 pm (PDT) . Posted by:
dzi6ewzrdnxj7wkxo5f6mlhps7ydjxexnjzqjzdg
Hello Randy, all,
The template; smfPricesByDates-Example-Stocks-By-Dates.xls http://ogres-crypt.com/SMF/Templates/smfPricesByDates-Example-Stocks-By-Dates.xls returns an #NA error for all values and all stock tickers.
I'm using Microsoft Excel 2007
Other details: Stock Market Functions add-in, Version 2.1.2017.05.03 (C:\SMF Add-IN; Windows (32-bit) NT 6.02; 12.0; ; ; 31)
Please find attached the output I receive.
Could you please help me resolve this problem?
Many thanks!
Regards,
Rico
The template; smfPricesByDates-Example-Stocks-By-Dates.xls http://ogres-crypt.com/SMF/Templates/smfPricesByDates-Example-Stocks-By-Dates.xls returns an #NA error for all values and all stock tickers.
I'm using Microsoft Excel 2007
Other details: Stock Market Functions add-in, Version 2.1.2017.05.
Please find attached the output I receive.
Could you please help me resolve this problem?
Many thanks!
Regards,
Rico
Attachment(s) from
1 of 1 Photo(s)
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar