2 New Messages
Digest #2665
Messages
Thu Jun 20, 2013 11:21 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
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@gmail.com > 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?
>
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@gmail.
>
> 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?
>
Thu Jun 20, 2013 11:32 pm (PDT) . Posted by:
"Randy H" rharmelink
When you say "go in the browser", which browser? The add-in uses the
MicroSoft DLL libraries, so it would use the same process as IE. Going
to the web page in FireFox would tell you little.
The other thing you can do is look at the actual source code returned to
the add-in:
=RCHGetWebData("http://www.google.com/finance?fstype=ii&q=MCD ",1)
From time to time, when someone has an issue, that content has some
type of website-based error message. Or, if "Error", it means the
add-in couldn't even retrieve the web page for some reason...
PS: You need to send add-in questions to the Yahoo group. I have email
filters that direct them to a folder. I found this message in my SPAM
folder, which means it could easily have deleted without me ever seeing
it.
On Thu, Jun 20, 2013 at 7:35 PM, nap1805 <nap1805@....com
<mailto:nap1805@yahoo.com > > wrote:
First of all, thanks for the add-in and support. It greatly improves the
capabilities of Excel.
I am having a problem retrieving Google info. To give you some
background:
- =RCHGETELEMENTNUMBER("Version" )returns Stock Market Functions add-in,
Version 2.1.2013.06.03 (C:\Program Files\SMF ADD-IN; 1)
- =smfGetAParms(3380) returns Google;Annual Income Statement --
Operating Income -- FY1;http://www.google.com/
finance?fstype=ii&q=~~~~~;1; INCANNUALDIV;Operating
<http://www.google.com/finance?fstype=ii&q=%7E%7E%7E%7E%7E;1;INCANNUALDI\
V;Operating > Income; ; ;0;</TABLE;0;0
- I am able to retrieve info from MSN, YAHOO, Morningstar etc, but not
Google.
- I am also able to go in the browser and access
http://www.google.com/finance? fstype=ii&q=MCD
<http://www.google.com/finance?fstype=ii&q=MCD >
What do you think can be generating the problem?
MicroSoft DLL libraries, so it would use the same process as IE. Going
to the web page in FireFox would tell you little.
The other thing you can do is look at the actual source code returned to
the add-in:
=RCHGetWebData(
From time to time, when someone has an issue, that content has some
type of website-based error message. Or, if "Error"
add-in couldn't even retrieve the web page for some reason...
PS: You need to send add-in questions to the Yahoo group. I have email
filters that direct them to a folder. I found this message in my SPAM
folder, which means it could easily have deleted without me ever seeing
it.
On Thu, Jun 20, 2013 at 7:35 PM, nap1805 <nap1805@
<mailto:nap1805@yahoo.
First of all, thanks for the add-in and support. It greatly improves the
capabilities of Excel.
I am having a problem retrieving Google info. To give you some
background:
- =RCHGETELEMENTNUMBE
Version 2.1.2013.06.
- =smfGetAParms(
Operating Income -- FY1;http://www.google.
finance?fstype=
<http://www.google.
V;Operating
- I am able to retrieve info from MSN, YAHOO, Morningstar etc, but not
Google.
- I am also able to go in the browser and access
http://www.google.
<http://www.google.
What do you think can be generating the problem?
Tidak ada komentar:
Posting Komentar