12 New Messages
Digest #2277
1a
Re: Can't retrieve the MSN Company Name using =RCHGetElementNumber(T by "antonvanas1989" antonvanas1989
1c
Re: Can't retrieve the MSN Company Name using =RCHGetElementNumber(T by "Randy Harmelink" rharmelink
Messages
Fri Jul 13, 2012 10:37 am (PDT) . Posted by:
"antonvanas1989" antonvanas1989
hmm think i didnt copy all the lines now its working after trying again.
Thanxs for your hard work! (And your fast responses!)
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> They shouldn't be undefined. They are on that file. They're all working
> fine here.
>
> Undefined should mean that no element definition was loaded from the
> external files for that element number.
>
> On Fri, Jul 13, 2012 at 10:10 AM, antonvanas1989
> <antonvanas1989@...>wrote:
>
> > alright. I installed not the latest version but the stable verion the
> > problem was i forget the txt file was not the newest one.
> >
> > But it's a good way to update the text files so you don't need to install
> > the whole add-in.
> >
> > After installing the new text file (close excel and smfforce) i see the
> > #442 #447 #388/#389 gives undefined..
> > But the
> > #1, #7-#10 are working now.. Any idea how this comes?
> >
>
Thanxs for your hard work! (And your fast responses!)
--- In smf_addin@yahoogrou
>
> They shouldn't be undefined. They are on that file. They're all working
> fine here.
>
> Undefined should mean that no element definition was loaded from the
> external files for that element number.
>
> On Fri, Jul 13, 2012 at 10:10 AM, antonvanas1989
> <antonvanas1989@
>
> > alright. I installed not the latest version but the stable verion the
> > problem was i forget the txt file was not the newest one.
> >
> > But it's a good way to update the text files so you don't need to install
> > the whole add-in.
> >
> > After installing the new text file (close excel and smfforce) i see the
> > #442 #447 #388/#389 gives undefined..
> > But the
> > #1, #7-#10 are working now.. Any idea how this comes?
> >
>
Fri Jul 13, 2012 6:40 pm (PDT) . Posted by:
"ts63033" ts63033
Randy,
I replaced all of the files in my C:\Program Files\SMF Add-in folder with files from the "Add-In Files" folder zip file that you have posted on line. I did this on July 6 and that is the date that shows up in the "Date modified" area when I look at the file details. So, I am assuming that I have the most recent version of all files. Is that not the case?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Are you using an older version of the add-in? That element definition
> requires the 2.1.2012.02.02 version or later.
>
> On Wed, Jul 11, 2012 at 11:06 AM, ts63033 <mdlarson5@...> wrote:
>
> >
> > I saw a prior post about how to correct an MSN data retrieval problem by
> > using the updated elements definitions files. I replaced all of the old
> > files with the new files but still am not able to retrieve the MSN Company
> > Name using =RCHGetElementNumber(Ticker,13862). Any idea why this is not
> > working?
> >
>
I replaced all of the files in my C:\Program Files\SMF Add-in folder with files from the "Add-In Files" folder zip file that you have posted on line. I did this on July 6 and that is the date that shows up in the "Date modified" area when I look at the file details. So, I am assuming that I have the most recent version of all files. Is that not the case?
--- In smf_addin@yahoogrou
>
> Are you using an older version of the add-in? That element definition
> requires the 2.1.2012.02.
>
> On Wed, Jul 11, 2012 at 11:06 AM, ts63033 <mdlarson5@.
>
> >
> > I saw a prior post about how to correct an MSN data retrieval problem by
> > using the updated elements definitions files. I replaced all of the old
> > files with the new files but still am not able to retrieve the MSN Company
> > Name using =RCHGetElementNumbe
> > working?
> >
>
Fri Jul 13, 2012 7:59 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
That release of the add-in doesn't contain the most recent changes to MSN
element definitions. You would need the newer version of the
smf-elements-1.txt file from the "Works in Progress" folder for those new
element definitions.
On Fri, Jul 13, 2012 at 6:40 PM, ts63033 <mdlarson5@comcast.net > wrote:
>
> I replaced all of the files in my C:\Program Files\SMF Add-in folder with
> files from the "Add-In Files" folder zip file that you have posted on line.
> I did this on July 6 and that is the date that shows up in the "Date
> modified" area when I look at the file details. So, I am assuming that I
> have the most recent version of all files. Is that not the case?
>
element definitions. You would need the newer version of the
smf-elements-
element definitions.
On Fri, Jul 13, 2012 at 6:40 PM, ts63033 <mdlarson5@comcast.
>
> I replaced all of the files in my C:\Program Files\SMF Add-in folder with
> files from the "Add-In Files" folder zip file that you have posted on line.
> I did this on July 6 and that is the date that shows up in the "Date
> modified" area when I look at the file details. So, I am assuming that I
> have the most recent version of all files. Is that not the case?
>
Fri Jul 13, 2012 11:21 am (PDT) . Posted by:
"Jose" pepecan47
Randy, I downloaded MStar_Ratings.xls from the files section of this user's group last year and it was working fine until recently. Somebody removed the spreadsheet, I cannot see it anymore in the files section.
The spread sheet has 2 workbooks. One uses =RCHGetElementNumber(MTicker,13862) and works fine. You have to provide the ticker.
In the other workbook, you provide a list, and the formula is
RCHGetElementNumber("~~~~~", 13862), and gives Error in the cells.
I don't have any problem with the MSN definition in my other spreadsheets.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I'm not really interested in digging through other people's workbooks. If
> someone else developed that workbook for you, and you don't know how it
> works, then you should be contacting them to get a fix.
>
> My suspicion is that you need to update the MSN element definitions, since
> the company name did break there when MSN updated their web page layout.
> That's why I asked you how it gets company name.
>
> http://finance.groups.yahoo.com/group/smf_addin/message/19282
>
> On Thu, Jul 12, 2012 at 9:31 AM, davidphillips2976 <david45@...>wrote:
>
> >
> > Randy, all I can tell you is that I have a version of this spreadsheet
> > that did retrieve the company name. I will be glad to forward a copy to
> > you if that would be helpful.
> >
>
The spread sheet has 2 workbooks. One uses =RCHGetElementNumbe
In the other workbook, you provide a list, and the formula is
RCHGetElementNumber
I don't have any problem with the MSN definition in my other spreadsheets.
--- In smf_addin@yahoogrou
>
> I'm not really interested in digging through other people's workbooks. If
> someone else developed that workbook for you, and you don't know how it
> works, then you should be contacting them to get a fix.
>
> My suspicion is that you need to update the MSN element definitions, since
> the company name did break there when MSN updated their web page layout.
> That's why I asked you how it gets company name.
>
> http://finance.
>
> On Thu, Jul 12, 2012 at 9:31 AM, davidphillips2976 <david45@...
>
> >
> > Randy, all I can tell you is that I have a version of this spreadsheet
> > that did retrieve the company name. I will be glad to forward a copy to
> > you if that would be helpful.
> >
>
Fri Jul 13, 2012 11:27 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
This workaround should fix the problem:
http://finance.groups.yahoo.com/group/smf_addin/message/18470
I checked the group logs and the uploaded file was deleted by the author
last year.
On Fri, Jul 13, 2012 at 11:20 AM, Jose <pepecan47@yahoo.ca > wrote:
> Randy, I downloaded MStar_Ratings.xls from the files section of this
> user's group last year and it was working fine until recently. Somebody
> removed the spreadsheet, I cannot see it anymore in the files section.
>
> The spread sheet has 2 workbooks. One uses
> =RCHGetElementNumber(MTicker,13862) and works fine. You have to provide the
> ticker.
>
> In the other workbook, you provide a list, and the formula is
> RCHGetElementNumber("~~~~~", 13862), and gives Error in the cells.
>
> I don't have any problem with the MSN definition in my other spreadsheets.
>
http://finance.
I checked the group logs and the uploaded file was deleted by the author
last year.
On Fri, Jul 13, 2012 at 11:20 AM, Jose <pepecan47@yahoo.
> Randy, I downloaded MStar_Ratings.
> user's group last year and it was working fine until recently. Somebody
> removed the spreadsheet, I cannot see it anymore in the files section.
>
> The spread sheet has 2 workbooks. One uses
> =RCHGetElementNumbe
> ticker.
>
> In the other workbook, you provide a list, and the formula is
> RCHGetElementNumber
>
> I don't have any problem with the MSN definition in my other spreadsheets.
>
Fri Jul 13, 2012 8:21 pm (PDT) . Posted by:
"Jacob Jose" pepecan47
No idea as to why the author deleted the file. It is so useful, I am glad I have a copy. It works perfect, except now that suddenly stopped displaying the company names when passing the tickers as a list. It was working until very recently, probably until I updated to the new version of the SMF a couple of months ago.
I might be too simplistic, but I think it is failing when passing the ticker to RCHGetElementNumber("~~~~~", 13862).
You lost me with message 18470.
Can I send you the spreadsheet? I am sure you will find the problem in 2 minutes.
Regards,
Jose L. Jacob
________________________________
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Friday, July 13, 2012 2:27:00 PM
Subject: Re: [smf_addin] Re: Morningstar Ratings Retrieval Worksheet
This workaround should fix the problem:
http://finance.groups.yahoo.com/group/smf_addin/message/18470
I checked the group logs and the uploaded file was deleted by the author last year.
On Fri, Jul 13, 2012 at 11:20 AM, Jose <pepecan47@yahoo.ca > wrote:
Randy, I downloaded MStar_Ratings.xls from the files section of this user's group last year and it was working fine until recently. Somebody removed the spreadsheet, I cannot see it anymore in the files section.
>
>The spread sheet has 2 workbooks. One uses =RCHGetElementNumber(MTicker,13862) and works fine. You have to provide the ticker.
>
>In the other workbook, you provide a list, and the formula is
>RCHGetElementNumber("~~~~~", 13862), and gives Error in the cells.
>
>I don't have any problem with the MSN definition in my other spreadsheets.
>
I might be too simplistic, but I think it is failing when passing the ticker to RCHGetElementNumber
You lost me with message 18470.
Can I send you the spreadsheet? I am sure you will find the problem in 2 minutes.
Regards,
Jose L. Jacob
____________
From: Randy Harmelink <rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Friday, July 13, 2012 2:27:00 PM
Subject: Re: [smf_addin] Re: Morningstar Ratings Retrieval Worksheet
This workaround should fix the problem:
http://finance.
I checked the group logs and the uploaded file was deleted by the author last year.
On Fri, Jul 13, 2012 at 11:20 AM, Jose <pepecan47@yahoo.
Randy, I downloaded MStar_Ratings.
>
>The spread sheet has 2 workbooks. One uses =RCHGetElementNumbe
>
>In the other workbook, you provide a list, and the formula is
>RCHGetElementNumbe
>
>I don't have any problem with the MSN definition in my other spreadsheets.
>
Fri Jul 13, 2012 8:42 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
That formula is the problem. You need to change it to one of the two in
message 18470.
Or replace it with a formula that gets company name from somewhere else.
On Fri, Jul 13, 2012 at 8:21 PM, Jacob Jose <pepecan47@yahoo.ca > wrote:
>
> No idea as to why the author deleted the file. It is so useful, I am glad
> I have a copy. It works perfect, except now that suddenly stopped
> displaying the company names when passing the tickers as a list. It was
> working until very recently, probably until I updated to the new version of
> the SMF a couple of months ago.
>
> I might be too simplistic, but I think it is failing when passing the
> ticker to RCHGetElementNumber("~~~~~", 13862).
>
> You lost me with message 18470.
>
> Can I send you the spreadsheet? I am sure you will find the problem in 2
> minutes.
>
>
message 18470.
Or replace it with a formula that gets company name from somewhere else.
On Fri, Jul 13, 2012 at 8:21 PM, Jacob Jose <pepecan47@yahoo.
>
> No idea as to why the author deleted the file. It is so useful, I am glad
> I have a copy. It works perfect, except now that suddenly stopped
> displaying the company names when passing the tickers as a list. It was
> working until very recently, probably until I updated to the new version of
> the SMF a couple of months ago.
>
> I might be too simplistic, but I think it is failing when passing the
> ticker to RCHGetElementNumber
>
> You lost me with message 18470.
>
> Can I send you the spreadsheet? I am sure you will find the problem in 2
> minutes.
>
>
Fri Jul 13, 2012 12:03 pm (PDT) . Posted by:
"khajado" khajado
Hello, and thank you for looking at this.
First Column - tickers (as below)
Formulas:
2nd to 5th column
=RCHGetYahooQuotes( $A3, _ ) where _ is "d1", "t1", "l1", "c1", and "p2"
6th-16th columns
=RCHGetElementNumber($A3,_ ) using 13863, 941, 964, 966, 942, 956, 970, 946, 947, 983, 5
The =RCHGetElementNumber($A3,_) function columns all return "Error" for the following tickers.
cgx.to
fp.to
gct-c.to
pnc-a.to
pnc-b.to
sjr-pa.to
tcl-pd.to
vvx.to
ylo.to
=RCHGetElementNumber($A3,5) returns "Error" for all tickers.
The rest of the all of the formulas work for the following tickers (except ElementNumber 5):
gct.to
rnk.to
idc.to
nln.to
ncc-b.to
dhx.to
scr.to
mhr.to
tva-b.to
tcl-b.to
acm-b.to
ncc-a.to
mdz-a.to
ts-b.to
tcl-a.to
cgo.to
qbr-a.to
imx.to
qbr-b.to
cjr-b.to
acm-a.to
Rci-a.to
sjr-b.to
rci-b.to
bce.to
Hope that helps and thanks.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I'd be more interested in the exact formulas -- including parameters and
> ticker symbols -- that are returning "Error". You didn't even indicate what
> functions you are using.
>
> On Fri, Jul 13, 2012 at 10:12 AM, khajado <khajado@...> wrote:
>
> >
> > I have created my own template to pull data from Yahoo (using the latest
> > 2012 files) but I am only getting some of the data for certain tickers,
> > others are showing up as "Error" though I know the data exists from looking
> > at the Yahoo pages. I can send you the template to look at if need be.
> >
>
First Column - tickers (as below)
Formulas:
2nd to 5th column
=RCHGetYahooQuotes( $A3, _ ) where _ is "d1", "t1", "l1", "c1", and "p2"
6th-16th columns
=RCHGetElementNumbe
The =RCHGetElementNumbe
cgx.to
fp.to
gct-c.to
pnc-a.to
pnc-b.to
sjr-pa.to
tcl-pd.to
vvx.to
ylo.to
=RCHGetElementNumbe
The rest of the all of the formulas work for the following tickers (except ElementNumber 5):
gct.to
rnk.to
idc.to
nln.to
ncc-b.to
dhx.to
scr.to
mhr.to
tva-b.to
tcl-b.to
acm-b.to
ncc-a.to
mdz-a.to
ts-b.to
tcl-a.to
cgo.to
qbr-a.to
imx.to
qbr-b.to
cjr-b.to
acm-a.to
Rci-a.to
sjr-b.to
rci-b.to
bce.to
Hope that helps and thanks.
--- In smf_addin@yahoogrou
>
> I'd be more interested in the exact formulas -- including parameters and
> ticker symbols -- that are returning "Error". You didn't even indicate what
> functions you are using.
>
> On Fri, Jul 13, 2012 at 10:12 AM, khajado <khajado@...
>
> >
> > I have created my own template to pull data from Yahoo (using the latest
> > 2012 files) but I am only getting some of the data for certain tickers,
> > others are showing up as "Error" though I know the data exists from looking
> > at the Yahoo pages. I can send you the template to look at if need be.
> >
>
Fri Jul 13, 2012 1:17 pm (PDT) . Posted by:
"Randy H" rharmelink
RCHGetYahooQuotes() works fine for me for the first list of tickers:
Ticker
d1 t1 l1 c1 p2 cgx.to 7/13/2012 3:30pm 30.09 -0.06 -0.002
fp.to 7/13/2012 3:04pm 3.9 0 0 gct-c.to 7/13/2012 3:04pm
0.471 0 0 pnc-a.to 7/13/2012 3:05pm 1 0 0 pnc-b.to
7/13/2012 3:05pm 0.8 0 0 sjr-pa.to 7/13/2012 3:08pm 25.4
0.1 0.004 tcl-pd.to 7/13/2012 3:30pm 25.8 -0.15 -0.0058
vvx.to 7/13/2012 3:06pm 0.015 0 0 ylo.to 7/13/2012 3:06pm
0.035 0.005 0.1667
Note that your retrieval of those would be a lot quicker if you do an
array-entered function. As an array-entered function, it can retrieve
multiple data items on up to 200 ticker symbols in a single Internet
access.
The 9xx element numbers don't work for those because they don't have a
Key Statistics page on Yahoo, which is where the add-in is picking up
the data elements.
Element #13863 worked for me all all of them. Do you have an older
version of EXCEL? What do you get for:
=smfGetAParms(13863)
=smfGetAParms(5)
Element #5 worked on all of those that didn't have hyphens. That element
comes from MSN, so the hyphenated ticker symbols aren't being
translated correctly from Yahoo ticker symbols. The hyphenation is not
something I have coded for translation at this time. I did add it, now
that I know about it. For example:
Yahoo Ticker symbol
MSN Ticker Symbol
CGX.TO CA:CGX FP.TO CA:FP GCT-C.TO CA:GCT.C PNC-A.TO
CA:PNC.A PNC-B.TO CA:PNC.B SJR-PA.TO CA:SJR.A TCL-PD.TO
CA:TCL.D VVX.TO CA:VVX YLO.TO CA:YLO
=RCHGetElementNumber("CA:GCT.C",5)
...does return "NA" instead of "Error", because "NA" is what MSN has
posted for the data item.
Also, do you have the updated element definitions for MSN from the
"Works in Progress" folder? They changed their web page layouts about a
month or so ago, so all the elements had to be redefined.
On Fri, Jul 13, 2012 at 12:03 PM, khajado <khajado@yahoo.com
<mailto:khajado@yahoo.com > > wrote:
First Column - tickers (as below)
Formulas:
2nd to 5th column
=RCHGetYahooQuotes( $A3, _ ) where _ is "d1", "t1", "l1", "c1", and "p2"
6th-16th columns
=RCHGetElementNumber($A3,_ ) using 13863, 941, 964, 966, 942, 956, 970,
946, 947, 983, 5
The =RCHGetElementNumber($A3,_) function columns all return "Error" for
the following tickers.
cgx.to <http://cgx.to>
fp.to <http://fp.to>
gct-c.to <http://gct-c.to >
pnc-a.to <http://pnc-a.to >
pnc-b.to <http://pnc-b.to >
sjr-pa.to <http://sjr-pa.to >
tcl-pd.to <http://tcl-pd.to >
vvx.to <http://vvx.to>
ylo.to <http://ylo.to>
Ticker
d1 t1 l1 c1 p2 cgx.to 7/13/2012 3:30pm 30.09 -0.06 -0.002
fp.to 7/13/2012 3:04pm 3.9 0 0 gct-c.to 7/13/2012 3:04pm
0.471 0 0 pnc-a.to 7/13/2012 3:05pm 1 0 0 pnc-b.to
7/13/2012 3:05pm 0.8 0 0 sjr-pa.to 7/13/2012 3:08pm 25.4
0.1 0.004 tcl-pd.to 7/13/2012 3:30pm 25.8 -0.15 -0.0058
vvx.to 7/13/2012 3:06pm 0.015 0 0 ylo.to 7/13/2012 3:06pm
0.035 0.005 0.1667
Note that your retrieval of those would be a lot quicker if you do an
array-entered function. As an array-entered function, it can retrieve
multiple data items on up to 200 ticker symbols in a single Internet
access.
The 9xx element numbers don't work for those because they don't have a
Key Statistics page on Yahoo, which is where the add-in is picking up
the data elements.
Element #13863 worked for me all all of them. Do you have an older
version of EXCEL? What do you get for:
=smfGetAParms(
=smfGetAParms(
Element #5 worked on all of those that didn't have hyphens. That element
comes from MSN, so the hyphenated ticker symbols aren't being
translated correctly from Yahoo ticker symbols. The hyphenation is not
something I have coded for translation at this time. I did add it, now
that I know about it. For example:
Yahoo Ticker symbol
MSN Ticker Symbol
CGX.TO CA:CGX FP.TO CA:FP GCT-C.TO CA:GCT.C PNC-A.TO
CA:PNC.A PNC-B.TO CA:PNC.B SJR-PA.TO CA:SJR.A TCL-PD.TO
CA:TCL.D VVX.TO CA:VVX YLO.TO CA:YLO
=RCHGetElementNumbe
...does return "NA" instead of "Error", because "NA" is what MSN has
posted for the data item.
Also, do you have the updated element definitions for MSN from the
"Works in Progress" folder? They changed their web page layouts about a
month or so ago, so all the elements had to be redefined.
On Fri, Jul 13, 2012 at 12:03 PM, khajado <khajado@yahoo.
<mailto:khajado@yahoo.
First Column - tickers (as below)
Formulas:
2nd to 5th column
=RCHGetYahooQuotes( $A3, _ ) where _ is "d1", "t1", "l1", "c1", and "p2"
6th-16th columns
=RCHGetElementNumbe
946, 947, 983, 5
The =RCHGetElementNumbe
the following tickers.
cgx.to <http://cgx.to>
fp.to <http://fp.to>
gct-c.to <http://gct-c.
pnc-a.to <http://pnc-a.
pnc-b.to <http://pnc-b.
sjr-pa.to <http://sjr-pa.
tcl-pd.to <http://tcl-pd.
vvx.to <http://vvx.to>
ylo.to <http://ylo.to>
Fri Jul 13, 2012 5:31 pm (PDT) . Posted by:
"Jason" g3m1n1980
Does anyone have a good DCF template they wouldnt mind sharing?
Fri Jul 13, 2012 7:27 pm (PDT) . Posted by:
"colinmmoors" colinmmoors
Randy,
I tried your new version and it is pulling the data from the first row (which is incorrect); it needs to pull data from the second row if there are repeating dates.
thanks, colin
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Give version 2.1.2012.07.06 of the add-in from the "Works in Progress"
> folder a try. I think I've got it working for the repeating dates. I have
> it overlaying the previous row if the next row has the same date.
>
> On Fri, Jul 6, 2012 at 6:27 AM, colinmmoors <colinmmoors@...> wrote:
>
> > Randy, is it possible to force RCHGetYahooHistory to retrieve the second
> > row of data if the first and second row are the same date (which seems to
> > be happening outside market hours)? The first row seems to be inaccurate
> > while the second row is good, but right now it is pulling from the first
> > row. thanks
> >
>
I tried your new version and it is pulling the data from the first row (which is incorrect); it needs to pull data from the second row if there are repeating dates.
thanks, colin
--- In smf_addin@yahoogrou
>
> Give version 2.1.2012.07.
> folder a try. I think I've got it working for the repeating dates. I have
> it overlaying the previous row if the next row has the same date.
>
> On Fri, Jul 6, 2012 at 6:27 AM, colinmmoors <colinmmoors@
>
> > Randy, is it possible to force RCHGetYahooHistory to retrieve the second
> > row of data if the first and second row are the same date (which seems to
> > be happening outside market hours)? The first row seems to be inaccurate
> > while the second row is good, but right now it is pulling from the first
> > row. thanks
> >
>
Fri Jul 13, 2012 8:04 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
This is what I get in my workbook for SPY:
Date Open High Low Close Volume Adj Close 2012-07-13 $133.86 $135.89
$133.84 $135.75 129618200 $135.75 2012-07-12 $133.38 $134.23 $132.60
$133.51 143510900 $133.51 2012-07-11 $134.21 $134.60 $133.38 $134.16
141733400 $134.16
This is what I see posted for SPY:
PricesDateOpenHighLowCloseVolumeAdj Close* Jul 13, 2012133.86135.89133.84
135.69107,659,600135.75Jul 13, 2012133.86135.89133.84135.75129,618,200135.75Jul
12, 2012133.38134.23132.60133.51143,510,900133.51
Looks to me like the function is grabbing the second row of what's posted...
On Fri, Jul 13, 2012 at 7:26 PM, colinmmoors <colinmmoors@yahoo.com > wrote:
>
> I tried your new version and it is pulling the data from the first row
> (which is incorrect); it needs to pull data from the second row if there
> are repeating dates.
>
Date Open High Low Close Volume Adj Close 2012-07-13 $133.86 $135.89
$133.84 $135.75 129618200 $135.75 2012-07-12 $133.38 $134.23 $132.60
$133.51 143510900 $133.51 2012-07-11 $134.21 $134.60 $133.38 $134.16
141733400 $134.16
This is what I see posted for SPY:
PricesDateOpenHighL
135.69107,659,
12, 2012133.38134.
Looks to me like the function is grabbing the second row of what's posted...
On Fri, Jul 13, 2012 at 7:26 PM, colinmmoors <colinmmoors@
>
> I tried your new version and it is pulling the data from the first row
> (which is incorrect); it needs to pull data from the second row if there
> are repeating dates.
>
Tidak ada komentar:
Posting Komentar