1 New Message
Digest #2667
Message
Sat Jun 22, 2013 12:05 am (PDT) . Posted by:
"kkm2706" kkm2706
Got it. Thanks.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The problem is that "BRK B" is interpreted as two separate ticker symbols.
> So from that point on, everything is down a row, to account for the extra
> ticker symbol.
>
> On Thu, Jun 20, 2013 at 9:05 PM, kkm2706 <kkm5848@...> wrote:
>
> >
> > I am using the RCHGetYahooQuotes and smfGetOptionQuotes functions in an
> > excel designed to track my portfolio. I have noticed that if I use the
> > array version of these and the stocks have an error, the stock values
> > returned are incorrect across a series of values. For example (first
> > column of prices is calculated using an array formula and the second is
> > calculated individually),
> >
> > AAPL 416.838 416.838
> > AIG 44.27 44.27
> > AMZN 273.44 273.44
> > AT 4.02 4.02
> > AYR 15.39 15.39
> > BBEP 17.95 17.95
> > BIDU 93.23 93.23
> > BRK B 0 0
> > BRK.B 28.99 0
> > BRK-B 0 111.41 ************ see error here
> > DDD 111.41 43.95 ************ see error here
> > EXC 43.95 29.9 ************ see error here
> > FB 29.9 23.9 ************ see error here
> >
> > Does anyone know a workaround or a fix?
> >
>
--- In smf_addin@yahoogrou
>
> The problem is that "BRK B" is interpreted as two separate ticker symbols.
> So from that point on, everything is down a row, to account for the extra
> ticker symbol.
>
> On Thu, Jun 20, 2013 at 9:05 PM, kkm2706 <kkm5848@
>
> >
> > I am using the RCHGetYahooQuotes and smfGetOptionQuotes functions in an
> > excel designed to track my portfolio. I have noticed that if I use the
> > array version of these and the stocks have an error, the stock values
> > returned are incorrect across a series of values. For example (first
> > column of prices is calculated using an array formula and the second is
> > calculated individually)
> >
> > AAPL 416.838 416.838
> > AIG 44.27 44.27
> > AMZN 273.44 273.44
> > AT 4.02 4.02
> > AYR 15.39 15.39
> > BBEP 17.95 17.95
> > BIDU 93.23 93.23
> > BRK B 0 0
> > BRK.B 28.99 0
> > BRK-B 0 111.41 ************ see error here
> > DDD 111.41 43.95 ************ see error here
> > EXC 43.95 29.9 ************ see error here
> > FB 29.9 23.9 ************ see error here
> >
> > Does anyone know a workaround or a fix?
> >
>
Tidak ada komentar:
Posting Komentar