3 New Messages
Digest #2676
Messages
Fri Jun 28, 2013 1:21 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
If you're redirected to ch.advfn.com, you would want to put "ch" in the
file (just the two bytes, without the quotes)...
That's why the file is there -- to allow you to tell the add-in that your
computer won't work with the normal "www", but needs to use a different
prefix to avoid the redirection.
Also, you do need to exit and restart EXCEL in order for the add-in to pick
up any changes in that file. The prefix is only loaded once.
On Fri, Jun 28, 2013 at 1:13 PM, schlange.meister <
schlange.meister@yahoo.com > wrote:
>
> I tried it with a blank file, non-existant file, www in the file and US
> in the file. Unfortunately, I still get Error in all Advfn elements
>
> For example =RCHGetElementNumber("MMM";;5386)
>
> Should give me the Annual statement Operating income for FY1, but all I
> get is Error. ADVfn has never really worked for me and I guess it is
> because I am living in Europe. The webpage only shows the German and swiss
> sites.
>
> What do you think?
>
file (just the two bytes, without the quotes)...
That's why the file is there -- to allow you to tell the add-in that your
computer won't work with the normal "www"
prefix to avoid the redirection.
Also, you do need to exit and restart EXCEL in order for the add-in to pick
up any changes in that file. The prefix is only loaded once.
On Fri, Jun 28, 2013 at 1:13 PM, schlange.meister <
schlange.meister@
>
> I tried it with a blank file, non-existant file, www in the file and US
> in the file. Unfortunately, I still get Error in all Advfn elements
>
> For example =RCHGetElementNumbe
>
> Should give me the Annual statement Operating income for FY1, but all I
> get is Error. ADVfn has never really worked for me and I guess it is
> because I am living in Europe. The webpage only shows the German and swiss
> sites.
>
> What do you think?
>
Fri Jun 28, 2013 1:33 pm (PDT) . Posted by:
"Patrick Van Beesen" patrickvb
Hi,
I'have had the same problem
replace the Vb code with: sURL =
"http://www.advfn.com/*ch*/p.php?pid=financials " & "&symbol=" & sTicker
& sLabel1
On 6/28/2013 9:09 PM, schlange.meister wrote:
>
> I am originally from USA and still invest in US markets, but I am
> living in switzerland now. Whenever I visit ADVfn, I am ALWAYS
> redirected to ch.advfn.com. It does not matter if I click on the US
> flag at the bottom of the page or use a different computer - I always
> end up at the swiss site. As a result, none of the smf add-in elements
> will work for me.
>
> Is there a solution that you know of without going via proxy server?
>
> Alternatively, is there another source of all the same figures for 10
> years worth of data?
>
>
I'have had the same problem
replace the Vb code with: sURL =
"http://www.advfn.
& sLabel1
On 6/28/2013 9:09 PM, schlange.meister wrote:
>
> I am originally from USA and still invest in US markets, but I am
> living in switzerland now. Whenever I visit ADVfn, I am ALWAYS
> redirected to ch.advfn.com. It does not matter if I click on the US
> flag at the bottom of the page or use a different computer - I always
> end up at the swiss site. As a result, none of the smf add-in elements
> will work for me.
>
> Is there a solution that you know of without going via proxy server?
>
> Alternatively, is there another source of all the same figures for 10
> years worth of data?
>
>
Fri Jun 28, 2013 5:24 pm (PDT) . Posted by:
"Randy H" rharmelink
Hmmm. Did you only enter the formula in cell I12?
You would need to select the entire range (e.g. I12:J41) before typing
in the formula and hitting Ctrl+Shift+Enter. EXCEL functions can only
return values to cells they've been entered into.
If that is the problem, try this -- click on cell I12, hold down the
shift key and select the range, then hit F2 to edit the formula, and
hit Ctrl+Shift+Enter to array-enter it over the new range. This
technique works for increasing the size of the range, but doesn't work
for reducing it. If you need to reduce the size of the range, you're
best off copying the text of the formula, deleting the range, and then
picking out the new range size and re-entering the formula.
"p" should return the previous day's closing price.
On Thu, Jun 27, 2013 at 8:05 AM, Thomas <thos.bruin@gmail.com
<mailto:thos.bruin@gmail.com > > wrote:
I am trying to return last price and previous close for a list of
tickers...placed vertically in range H12 thru H41. I am using
=RCHGetYahooQuotes(H12:H41, I11:J11) in cell I12, and then
CTRL/SHFT/ENTER. This only produses a price in cell I12, it doesn't
complete the rest of the ticker range. ??
And assuming I can get this to work correctly, what happens at EOD
close....does the code "p" return yesterdays close price or the EOD
close of current day?
You would need to select the entire range (e.g. I12:J41) before typing
in the formula and hitting Ctrl+Shift+Enter. EXCEL functions can only
return values to cells they've been entered into.
If that is the problem, try this -- click on cell I12, hold down the
shift key and select the range, then hit F2 to edit the formula, and
hit Ctrl+Shift+Enter to array-enter it over the new range. This
technique works for increasing the size of the range, but doesn't work
for reducing it. If you need to reduce the size of the range, you're
best off copying the text of the formula, deleting the range, and then
picking out the new range size and re-entering the formula.
"p" should return the previous day's closing price.
On Thu, Jun 27, 2013 at 8:05 AM, Thomas <thos.bruin@gmail.
<mailto:thos.bruin@gmail.
I am trying to return last price and previous close for a list of
tickers...placed vertically in range H12 thru H41. I am using
=RCHGetYahooQuotes(
CTRL/SHFT/ENTER. This only produses a price in cell I12, it doesn't
complete the rest of the ticker range. ??
And assuming I can get this to work correctly, what happens at EOD
close....does the code "p" return yesterdays close price or the EOD
close of current day?
Tidak ada komentar:
Posting Komentar