Messages In This Digest (13 Messages)
- 1a.
- moving averages From: Joel
- 1b.
- Re: moving averages From: Randy Harmelink
- 2a.
- "&Ticker&" question From: peteblack43
- 2b.
- Re: "&Ticker&" question From: Randy Harmelink
- 2c.
- Re: "&Ticker&" question From: peteblack43
- 3a.
- Re: Incomplete Update and Missing Values From: Bob
- 3b.
- Re: Incomplete Update and Missing Values From: Randy Harmelink
- 4a.
- Closing Price From: peteblack43
- 4b.
- Re: Closing Price From: Randy Harmelink
- 4c.
- Re: Closing Price From: peteblack43
- 5a.
- Problem to get last price of ^DJI From: Ameri Sky
- 5b.
- Re: Problem to get last price of ^DJI From: Randy Harmelink
- 5c.
- Re: Problem to get last price of ^DJI From: Ameri Sky
Messages
- 1a.
-
moving averages
Posted by: "Joel" joel.andrews@lpl.com joelfp2000
Sat Jun 11, 2011 3:53 am (PDT)
Randy,
I am unable to find an element to use for the 50/100/200 day moving averages of the S&P 500. Any ideas?
Thanks in advance for all of your work with the stock market resource. I use it almost every day.
Joel
- 1b.
-
Re: moving averages
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Jun 11, 2011 3:57 am (PDT)
How about barchart:
http://www.barchart.com/technicals/ futures/SPY00
On Sat, Jun 11, 2011 at 3:12 AM, Joel <joel.andrews@lpl.com > wrote:
>
> I am unable to find an element to use for the 50/100/200 day moving
> averages of the S&P 500. Any ideas?
>
> Thanks in advance for all of your work with the stock market resource. I
> use it almost every day.
>
- 2a.
-
"&Ticker&" question
Posted by: "peteblack43" peteblack43@yahoo.com peteblack43
Sat Jun 11, 2011 6:32 am (PDT)
Hi Randy,
I need a little help fixing this statement:
=RCHGetTableCell("http://investing. money.msn. ",1,">Details"com/investments/ mutual-fund- rates?symbol= ABT ,"Previous Close")
It works like it is but I would like to change the ticker symbol ABT so it will work with "&Ticker&". Can it be changed?
Thank you for your help.
Pete
- 2b.
-
Re: "&Ticker&" question
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Jun 11, 2011 6:36 am (PDT)
Just do normal EXCEL string concatenation. So the URL would be:
"http://investing.money.msn. com/investments/ mutual-fund- rates?symbol=
"&Ticker
On Sat, Jun 11, 2011 at 6:32 AM, peteblack43 <peteblack43@yahoo.com > wrote:
>
> I need a little help fixing this statement:
>
> =RCHGetTableCell("
> http://investing.money.msn. ",1,">Details"com/investments/ mutual-fund- rates?symbol= ABT ,"Previous
> Close")
>
> It works like it is but I would like to change the ticker symbol ABT so it
> will work with "&Ticker&". Can it be changed?
>
- 2c.
-
Re: "&Ticker&" question
Posted by: "peteblack43" peteblack43@yahoo.com peteblack43
Sat Jun 11, 2011 6:47 am (PDT)
Thanks Randy, It is working.
Pete
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Just do normal EXCEL string concatenation. So the URL would be:
>
> "http://investing.money.msn. com/investments/ mutual-fund- rates?symbol=
> "&Ticker
>
> On Sat, Jun 11, 2011 at 6:32 AM, peteblack43 <peteblack43@...> wrote:
>
> >
> > I need a little help fixing this statement:
> >
> > =RCHGetTableCell("
> > http://investing.money.msn. ",1,">Details"com/investments/ mutual-fund- rates?symbol= ABT ,"Previous
> > Close")
> >
> > It works like it is but I would like to change the ticker symbol ABT so it
> > will work with "&Ticker&". Can it be changed?
> >
>
- 3a.
-
Re: Incomplete Update and Missing Values
Posted by: "Bob" bbockjr@yahoo.com bbockjr
Sat Jun 11, 2011 7:26 am (PDT)
I don't have any path in the cells in my workbook. Each cell contains this formula with varying range addresses:
=RCHGetYahooQuotes(A33:A232, "l1")
The only way I can see a hard-coded path is if I deactivate the add-in. Then the formula appears as:
='C:\Program Files\SMF Add-In\RCH_Stock_Market_Functions .xla'!RCHGetYaho oQuotes(A33: A232,"l1" )
If I remove this path, save the file with a cell formula that only contains the function, I get the error again.
If I reactivate the add-in, the path disappears in the cell, indicating to me that it has found the add-in. But if I close the file, then reopen it, I get the error.
I have tried selectively removing the cells that contain the add-in, saving the file with a new name, closing it, then opening it again, and I still get the error.
I removed everything but one cell with the formula:
=RCHGetYahooQuotes("KO","d1" )
saved the file and I still get the error when I open it.
I have redownloaded the zip file and reinstalled the add-in. No difference.
I deleted the SMF Add-In folder in C:\Program Files and reinstalled it in my user folder thinking maybe it was a rights issue (although I have administrator rights as the only user of this computer), then reactivated the add-in in its new location. No difference.
I'm out of ideas.
Bob
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> You need to replace the path that YOU have in the cells, not the one in the
> previously mentioned link. And once you've removed the links and saved the
> workbook, you shouldn't have the same problem again -- unless you move the
> add-in. Or unless you don't have the add-in properly installed and activated
> via the add-in manager?
>
> I would avoid the "Edit Links" option altogether. If you need to go there,
> you have other problems that need to be resolved.
>
> On Sat, Jun 4, 2011 at 9:35 AM, Bob <bbockjr@...> wrote:
>
> > Thanks for the array suggestion - it speeds up the opening of the workbook
> > tremendously. I still get the link error message, though. I tried to do the
> > "replace the hard-coded path...", but it doesn't seem to be present. I've
> > searched for parts of the path, such as "c:\Program Files\" or "SMF Add-In"
> > or even ".xla" and I get a "Text Not Found" error. I am not sharing this
> > workbook with anyone else and all of the formulas are using the same .xla
> > file, so I don't understand why it can find some, but not all. I don't even
> > seem to be getting the blank cells anymore, but I still get the message
> > every time. When I go to "Edit Links" and click Update Values, it always
> > seem to work. It's a pain every time when I open the spreadsheet, but it's
> > also not much of a problem to just click "Continue". A small price to pay
> > for all the effort it saves me.
> >
>
- 3b.
-
Re: Incomplete Update and Missing Values
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Jun 11, 2011 8:10 am (PDT)
It sounds to me like you have a link error unrelated to the add-in. If all
of your formulas are resolving the links and removing the hard-coded path,
then the message is not for those cells.
Do you get the error if you create a new worksheet from scratch, save it,
and re-open it?
And, just out of curiosity, if you remove that last formula, save it, and
reopen it, do you STILL get the error (that would confirm the error is not
from add-in formula usage)?
If nothing else works, can you send me the workbook you have with just a
single formula? Maybe it'll be something obvious if I'm looking at it.
On Sat, Jun 11, 2011 at 7:26 AM, Bob <bbockjr@yahoo.com > wrote:
> I don't have any path in the cells in my workbook. Each cell contains this
> formula with varying range addresses:
> =RCHGetYahooQuotes(A33:A232, "l1")
>
> The only way I can see a hard-coded path is if I deactivate the add-in.
> Then the formula appears as:
> ='C:\Program Files\SMF
> Add-In\RCH_Stock_Market_Functions .xla'!RCHGetYaho oQuotes(A33: A232,"l1" )
> If I remove this path, save the file with a cell formula that only contains
> the function, I get the error again.
>
> If I reactivate the add-in, the path disappears in the cell, indicating to
> me that it has found the add-in. But if I close the file, then reopen it, I
> get the error.
>
> I have tried selectively removing the cells that contain the add-in, saving
> the file with a new name, closing it, then opening it again, and I still get
> the error.
>
> I removed everything but one cell with the formula:
> =RCHGetYahooQuotes("KO","d1" )
> saved the file and I still get the error when I open it.
>
> I have redownloaded the zip file and reinstalled the add-in. No difference.
>
> I deleted the SMF Add-In folder in C:\Program Files and reinstalled it in
> my user folder thinking maybe it was a rights issue (although I have
> administrator rights as the only user of this computer), then reactivated
> the add-in in its new location. No difference.
>
> I'm out of ideas.
>
- 4a.
-
Closing Price
Posted by: "peteblack43" peteblack43@yahoo.com peteblack43
Sat Jun 11, 2011 7:41 am (PDT)
Hi Randy,
Two more questions:
I want to change this ----
=RCHGetTableCell("http://investing. money.msn. "&Ticker,1,"com/investments/ mutual-fund\
-rates?symbol=>Details" ,"Previous Close")
To ---
=RCHGetTableCell("http://finance. yahoo.com/ "&Ticker&"+Historicq/hp?s= al+\
Prices?=,1," Close")
I am getting the #VALUE error.
This is the Yahoo page....
And how do I know where the yellowed cells are located on the web pages?
Thank you once more for all your help.
Pete
- 4b.
-
Re: Closing Price
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Jun 11, 2011 8:22 am (PDT)
The "+Historical+Prices" portion of the URL is unnecessary. But your problem
with that formula is that you don't have your string delimited properly with
quotes. You should try creating the URL by itself in a cell to be sure
you're creating it correctly. Then just copy that formula into the function.
The two yellow-shaded cells would be:
=RCHGetTableCell("http://finance. yahoo.com/ "&Ticker,0,"q/hp?s= >Close")
=RCHGetTableCell("http://finance. yahoo.com/ "&Ticker,5,"q/hp?s= >Close",, ,,1)
To determine that usage, you'd need to examine the source code of the web
page to find the unique string to use for the search.
On Sat, Jun 11, 2011 at 7:40 AM, peteblack43 <peteblack43@yahoo.com > wrote:
>
> Two more questions:
>
> I want to change this ----
>
> =RCHGetTableCell("
> http://investing.money.msn. "&Ticker,1,"com/investments/ mutual-fund- rates?symbol= >Details" ,"Previous
> Close")
>
> To ---
>
> =RCHGetTableCell("http://finance. yahoo.com/ "&Ticker&"+Historicq/hp?s= al+Prices? =,1,"
> Close")
>
> I am getting the #VALUE error.
>
> This is the Yahoo page....
>
>
>
>
> And how do I know where the yellowed cells are located on the web pages?
>
> Thank you once more for all your help.
>
>
- 4c.
-
Re: Closing Price
Posted by: "peteblack43" peteblack43@yahoo.com peteblack43
Sat Jun 11, 2011 10:04 am (PDT)
Thank you Randy. This works and I have more studying to do.
Pete
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The "+Historical+Prices" portion of the URL is unnecessary. But your problem
> with that formula is that you don't have your string delimited properly with
> quotes. You should try creating the URL by itself in a cell to be sure
> you're creating it correctly. Then just copy that formula into the function.
>
> The two yellow-shaded cells would be:
>
> =RCHGetTableCell("http://finance. yahoo.com/ "&Ticker,0,"q/hp?s= >Close")
> =RCHGetTableCell("http://finance. yahoo.com/ "&Ticker,5,"q/hp?s= >Close",, ,,1)
>
> To determine that usage, you'd need to examine the source code of the web
> page to find the unique string to use for the search.
>
> On Sat, Jun 11, 2011 at 7:40 AM, peteblack43 <peteblack43@...> wrote:
>
> >
> > Two more questions:
> >
> > I want to change this ----
> >
> > =RCHGetTableCell("
> > http://investing.money.msn. "&Ticker,1,"com/investments/ mutual-fund- rates?symbol= >Details" ,"Previous
> > Close")
> >
> > To ---
> >
> > =RCHGetTableCell("http://finance. yahoo.com/ "&Ticker&"+Historicq/hp?s= al+Prices? =,1,"
> > Close")
> >
> > I am getting the #VALUE error.
> >
> > This is the Yahoo page....
> >
> >
> >
> >
> > And how do I know where the yellowed cells are located on the web pages?
> >
> > Thank you once more for all your help.
> >
> >
>
- 5a.
-
Problem to get last price of ^DJI
Posted by: "Ameri Sky" amerisky@yahoo.com amerisky
Sat Jun 11, 2011 9:23 am (PDT)
Randy,
I want to get the last price of DJI. I used function:
=RCHGetYahooQuotes("^DJI","l1" ). However the return is "Missing Symbols List.".
I have no problem with other indice like ^IXIC or ^GSPC. I have no problem with
stocks.
Regards
Jef - 5b.
-
Re: Problem to get last price of ^DJI
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Jun 11, 2011 9:45 am (PDT)
See:
http://help.yahoo.com/ l/us/yahoo/ finance/known_ issues/fitaki- 13.html
The work-around I use is to use ticker symbol INDU instead.
On Sat, Jun 11, 2011 at 9:22 AM, Ameri Sky <amerisky@yahoo.com > wrote:
>
> I want to get the last price of DJI. I used function:
> =RCHGetYahooQuotes("^DJI","l1" ). However the return is "Missing Symbols
> List.".
>
> I have no problem with other indice like ^IXIC or ^GSPC. I have no problem
> with stocks.
>
>
- 5c.
-
Re: Problem to get last price of ^DJI
Posted by: "Ameri Sky" amerisky@yahoo.com amerisky
Sat Jun 11, 2011 9:56 am (PDT)
Randy
It works. Thanks
Jiping
_____________________ _________ __
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Sat, June 11, 2011 9:45:10 AM
Subject: Re: [smf_addin] Problem to get last price of ^DJI
See:
http://help.yahoo.com/ l/us/yahoo/ finance/known_ issues/fitaki- 13.html
The work-around I use is to use ticker symbol INDU instead.
On Sat, Jun 11, 2011 at 9:22 AM, Ameri Sky <amerisky@yahoo.com > wrote:
>
>I want to get the last price of DJI. I used function:
>=RCHGetYahooQuotes("^DJI"," l1"). However the return is "Missing Symbols List.".
>
>
>I have no problem with other indice like ^IXIC or ^GSPC. I have no problem with
>stocks.
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar