9 New Messages
Digest #2949
Messages
Thu Jan 30, 2014 3:26 pm (PST) . Posted by:
"Christopher Kline" hardpressedsalami@att.net
I downloaded the new element definitions as of 2014-01-30.
2,25, 27-32, 35, 36 all show a strike through and are obsolete.
Should I download the previous version?
I am running Office 2010 student/home.
PS: my desktop's software is running fine. I downloaded that a couple days ago.
Thanks for your help
2,25, 27-32, 35, 36 all show a strike through and are obsolete.
Should I download the previous version?
I am running Office 2010 student/home.
PS: my desktop'
Thanks for your help
Thu Jan 30, 2014 3:30 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The previous version won't help. Those elements were obsoleted because MSN
redesigned their stock print page last year and dropped those data items
from the web page. All except element #25. Ever since they redid the web
page, the "Last Price" they've been posting has actually been the previous
day's closing price.
Use RCHGetYahooQuotes() to get current quotes. It can return a number of
data items on up to 200 ticker symbols, with a single Internet access.
On Thu, Jan 30, 2014 at 3:18 PM, Christopher Kline <
hardpressedsalami@att.net> wrote:
>
> I downloaded the new element definitions as of 2014-01-30.
>
> 2,25, 27-32, 35, 36 all show a strike through and are obsolete.
>
> Should I download the previous version?
>
> I am running Office 2010 student/home.
>
> PS: my desktop's software is running fine. I downloaded that a couple days
> ago.
>
>
redesigned their stock print page last year and dropped those data items
from the web page. All except element #25. Ever since they redid the web
page, the "Last Price" they've been posting has actually been the previous
day's closing price.
Use RCHGetYahooQuotes(
data items on up to 200 ticker symbols, with a single Internet access.
On Thu, Jan 30, 2014 at 3:18 PM, Christopher Kline <
hardpressedsalami@
>
> I downloaded the new element definitions as of 2014-01-30.
>
> 2,25, 27-32, 35, 36 all show a strike through and are obsolete.
>
> Should I download the previous version?
>
> I am running Office 2010 student/home.
>
> PS: my desktop'
> ago.
>
>
Thu Jan 30, 2014 4:45 pm (PST) . Posted by:
graham_blaah
That's so cool. I shall implement that forthwith. Thanks.
The other comment was a duplicate response - internet issues and I didn't know the first one got through. Not a flippant response to your always helpful posts.
I seem to be getting the hang of it now. At least the basics.
Thanks again.
The other comment was a duplicate response - internet issues and I didn't know the first one got through. Not a flippant response to your always helpful posts.
I seem to be getting the hang of it now. At least the basics.
Thanks again.
Thu Jan 30, 2014 8:05 pm (PST) . Posted by:
tonyestep
I just updated and now my simple closing-price sheet doesn't work. I'm using the formula:
=RCHGetYahooQuotes(A2:A100,B1:M1)
In A2: A100 are tickers, and in row 1 are items: p, l1, etc. This worked until I updated. All I did was move the new .xla file into the directory where the previous one was located. Where did I screw up? Thanks.....
=RCHGetYahooQuotes(
In A2: A100 are tickers, and in row 1 are items: p, l1, etc. This worked until I updated. All I did was move the new .xla file into the directory where the previous one was located. Where did I screw up? Thanks.....
Thu Jan 30, 2014 8:09 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Try exiting EXCEL and unzipping *all* files from the ZIP archive into your
add-in folder (not just the XLA file). Then restart EXCEL and see if you
still have the problem.
If you still have a problem, verify you *are* using the new version, with:
=RCHGetElementNumber("Version")
On Thu, Jan 30, 2014 at 9:02 PM, <tonyestep@yahoo.com> wrote:
>
> I just updated and now my simple closing-price sheet doesn't work. I'm
> using the formula:
>
> =RCHGetYahooQuotes(A2:A100,B1:M1)
>
> In A2: A100 are tickers, and in row 1 are items: p, l1, etc. This worked
> until I updated. All I did was move the new .xla file into the directory
> where the previous one was located. Where did I screw up? Thanks.....
>
add-in folder (not just the XLA file). Then restart EXCEL and see if you
still have the problem.
If you still have a problem, verify you *are* using the new version, with:
=RCHGetElementNumbe
On Thu, Jan 30, 2014 at 9:02 PM, <tonyestep@yahoo.
>
> I just updated and now my simple closing-price sheet doesn't work. I'm
> using the formula:
>
> =RCHGetYahooQuotes(
>
> In A2: A100 are tickers, and in row 1 are items: p, l1, etc. This worked
> until I updated. All I did was move the new .xla file into the directory
> where the previous one was located. Where did I screw up? Thanks.....
>
Thu Jan 30, 2014 8:33 pm (PST) . Posted by:
tonyestep
Nope, same result. The RCHGetElementNumber("Version") call returns:
Stock Market Functions add-in, Version 2.1.2014.01.30 (C:\Users\Public\Documents\Work\RCH_Addin; ; 1)
Stock Market Functions add-in, Version 2.1.2014.01.
Thu Jan 30, 2014 8:36 pm (PST) . Posted by:
tonyestep
Instead of prices, the Price call returns:
src="http://chart.yahoo.com/c//e/edv.gif" alt="Chart"><br><table><tr><td width=512 align=center><font face=arial size=-1></font></td></tr></table>"
BTW, thanks very much for your reply, Randy, and thanks a lot for this terrific add-in!!
src="http://chart.
BTW, thanks very much for your reply, Randy, and thanks a lot for this terrific add-in!!
Thu Jan 30, 2014 8:56 pm (PST) . Posted by:
tonyestep
I backed down to the version of 1/1/2009 and it works okay. Presumably something changed a long time ago and my method of calling for prices became obsolete, but I didn't update and didn't notice it. It must be my way of calling for quotes: =RCHGetYahooQuotes(A2:A100,B1:M1) which apparently is no longer the way you call for quotes.
Thu Jan 30, 2014 9:01 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
That's the way I still do it...the template in the FILES area uses:
=RCHGetYahooQuotes(B4:B203,C2:V2)
Can you attach a copy of your workbook?
On Thu, Jan 30, 2014 at 9:56 PM, <tonyestep@yahoo.com> wrote:
> I backed down to the version of 1/1/2009 and it works okay. Presumably
> something changed a long time ago and my method of calling for prices
> became obsolete, but I didn't update and didn't notice it. It must be my
> way of calling for quotes: =RCHGetYahooQuotes(A2:A100,B1:M1) which
> apparently is no longer the way you call for quotes.
>
=RCHGetYahooQuotes(
Can you attach a copy of your workbook?
On Thu, Jan 30, 2014 at 9:56 PM, <tonyestep@yahoo.
> I backed down to the version of 1/1/2009 and it works okay. Presumably
> something changed a long time ago and my method of calling for prices
> became obsolete, but I didn't update and didn't notice it. It must be my
> way of calling for quotes: =RCHGetYahooQuotes(
> apparently is no longer the way you call for quotes.
>
Tidak ada komentar:
Posting Komentar