Messages In This Digest (25 Messages)
- 1a.
- Re: RCHCreateComment Query From: Philip S
- 1b.
- Re: RCHCreateComment Query From: Randy Harmelink
- 2a.
- Re: smfRecalculation From: Randy Harmelink
- 2b.
- Re: smfRecalculation From: wu_ming_sg
- 2c.
- Re: smfRecalculation From: Randy Harmelink
- 3a.
- Morning Star Key Ratios From: wu_ming_sg
- 3b.
- Re: Morning Star Key Ratios From: Randy Harmelink
- 3c.
- Re: Morning Star Key Ratios From: wu_ming_sg
- 3d.
- Re: Morning Star Key Ratios From: Randy Harmelink
- 4a.
- No update from Yahoo From: SANCHO
- 4b.
- Re: No update from Yahoo From: Randy Harmelink
- 4c.
- Re: No update from Yahoo From: SANCHO
- 4d.
- Re: No update from Yahoo From: Randy Harmelink
- 4e.
- Re: No update from Yahoo From: SANCHO
- 4f.
- Re: No update from Yahoo From: Randy Harmelink
- 4g.
- Re: No update from Yahoo From: SANCHO
- 4h.
- Re: No update from Yahoo From: Randy Harmelink
- 4i.
- Re: No update from Yahoo From: SANCHO
- 5a.
- Re: Extract text? From: wu_ming_sg
- 5b.
- Re: Extract text? From: Randy Harmelink
- 5c.
- Re: Extract text? From: wu_ming_sg
- 5d.
- Re: Extract text? From: Randy Harmelink
- 6a.
- DJIA quotes from Yahoo (^DJI and INDU both failing) From: spamfiel
- 6b.
- Re: DJIA quotes from Yahoo (^DJI and INDU both failing) From: Randy Harmelink
- 7.
- RCHGet From: Paulo
Messages
- 1a.
-
Re: RCHCreateComment Query
Posted by: "Philip S" Philip_R_Small@hotmail.com philip_r_small
Mon Nov 7, 2011 5:28 am (PST)
Randy
Thanks for the prompt respnse. I will resort to old fashioned cut and paste from this site!
Have another small query. I have spreadsheet with various SMF formula which now has error message about unable to open http://gummy-stuff.org/ and then a box about unable to update links. The only links I have is to the RCH_Stoxk_Market_windows/desktop/ stock.xls functions. xla. If I break the links or delete the formula, both messages go away.
The formula used are straight forward: e.g
=RCHGetTablecell("http://www.standard andpoors. ",1,">Foreign Long Term")com/prot/ ratings/entity- ratings/en/ us/?entityID= 273997§orCod e=CORP
and
=RCHGetYahooQuotes(Ticker1," l1")
I have looked through the documentation and can't see why this is happening.
- 1b.
-
Re: RCHCreateComment Query
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Nov 7, 2011 5:40 am (PST)
Check the "Links" area of the group for the location errors entry.
On Mon, Nov 7, 2011 at 6:28 AM, Philip S <Philip_R_Small@hotmail.com > wrote:
>
> Have another small query. I have spreadsheet with various SMF formula
> which now has error message about unable to open
> http://gummy-stuff.org/ and then a box aboutwindows/desktop/ stock.xls
> unable to update links. The only links I have is to the
> RCH_Stoxk_Market_functions. xla. If I break the links or delete the formula,
> both messages go away.
>
> The formula used are straight forward: e.g
>
> =RCHGetTablecell("
> http://www.standardandpoors. ",1,">Foreigncom/prot/ ratings/entity- ratings/en/ us/?entityID= 273997§orCod e=CORP
> Long Term")
>
> and
>
> =RCHGetYahooQuotes(Ticker1," l1")
>
> I have looked through the documentation and can't see why this is
> happening.
>
- 2a.
-
Re: smfRecalculation
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Nov 7, 2011 5:38 am (PST)
Unless you have calculation set to manual, the worksheet will update when
you enter the new data.
smfForceRecalculation is just a way to tell the add-in functions to go and
grab new data from the Internet. Otherwise, the functions are mostly
non-volatile unless you've made them volatile.
On Mon, Nov 7, 2011 at 3:25 AM, wu_ming_sg <nghongchong@hotmail.com > wrote:
>
> Is there a way to update the file calculations without getting the data
> from the website again as in SMFForceRecalculation?
>
> I have a step where I manually input some growth rates to calculate the
> fair value. This fair value will change depending on the input growth rates.
>
>
- 2b.
-
Re: smfRecalculation
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Mon Nov 7, 2011 10:54 am (PST)
hi Randy,
I managed to record a MACRO to key in F9 and assigned it to a button.
(My FIRST Macro!)
But I don't know how to "make it volatile". Could you elaborate more
pls?
Thank you.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...>
wrote:
>
> Unless you have calculation set to manual, the worksheet will update
when
> you enter the new data.
>
> smfForceRecalculation is just a way to tell the add-in functions to go
and
> grab new data from the Internet. Otherwise, the functions are mostly
> non-volatile unless you've made them volatile.
>
> On Mon, Nov 7, 2011 at 3:25 AM, wu_ming_sg nghongchong@... wrote:
>
> >
> > Is there a way to update the file calculations without getting the
data
> > from the website again as in SMFForceRecalculation?
> >
> > I have a step where I manually input some growth rates to calculate
the
> > fair value. This fair value will change depending on the input
growth rates.
> >
> >
>
- 2c.
-
Re: smfRecalculation
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Nov 7, 2011 11:15 am (PST)
Typically, functions only recalculate if one of their parameters change.
That is, non-volatile. However, some functions recalculate every time
something changes. That is, volatile. Examples of volatile EXCEL functions
would be NOW() and TODAY().
If you look at the documentation for RCHGetYahooQuotes(), you'll note that
I've added a "dummy" parameter to allow it to refresh. By using a volatile
function such as NOW() for that parameter, it makes the function itself
volatile. That is, every time something in the workbook changes (or F9 is
pressed), NOW() will update. When NOW() updates, it triggers that
RCHGetYahooQuotes() function to recalculate.
Sometimes, people do this inadvertently. Such as using NOW() as one of the
dates in the smfPricesBetween() function. If someone used a number of those
functions, it would be a real pain, because every time something changed,
every single one of those functions would recalculate. If I remember
correctly, I just had one where that technique was causing a 10-15 minute
recalculation -- EVERY TIME something changed in the workbook. That's why
most functions in EXCEL are non-volatile and only recalculate if something
triggers them to recalculate.
I just have smfForceRecalculation assigned to a button, and use that
whenever I want to update the workbooks with add-in functions in them.
On Mon, Nov 7, 2011 at 11:54 AM, wu_ming_sg <nghongchong@hotmail.com > wrote:
>
> I managed to record a MACRO to key in F9 and assigned it to a button. (My
> FIRST Macro!)
>
> But I don't know how to "make it volatile". Could you elaborate more pls?
>
- 3a.
-
Morning Star Key Ratios
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Mon Nov 7, 2011 7:18 am (PST)
Hi,
The element number to get ROE (TTM) from morning star is not working.
(=RCHGetElementNumber(Ticker, 14211))
Any workaround please?
Thank you.
- 3b.
-
Re: Morning Star Key Ratios
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Nov 7, 2011 8:14 am (PST)
Unfortunately, the page the data was coming from no longer delivers the
data within the source code of the web page so that it can be extracted.
MorningStar has changed some of their web pages to dynamically display the
data.
You can still get limited ROE information from their print page though. For
example, TTM could be either:
=RCHGetTableCell("
http://quicktake.morningstar. ",com/stocknet/ printreport. aspx?symbol= MMM
1,">ROE %")
=RCHGetTableCell("
http://quicktake.morningstar. ",com/stocknet/ printreport. aspx?symbol= MMM
12,">Return on Equity")
On Mon, Nov 7, 2011 at 8:18 AM, wu_ming_sg <nghongchong@hotmail.com > wrote:
>
> The element number to get ROE (TTM) from morning star is not working.
>
> (=RCHGetElementNumber(Ticker, 14211))
>
> Any workaround please?
>
>
- 3c.
-
Re: Morning Star Key Ratios
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Mon Nov 7, 2011 8:28 am (PST)
Hi,
Are you able to get from this page?
http://financials.morningstar. com/ratios/ r.html?t= MMM®ion= USA&culture\
=en-us
<http://financials.morningstar. >com/ratios/ r.html?t= MMM®ion= USA&cultur\
e=en-us
Kindly advise on the formula if you are able to do so as I am very bad
at it.
Thank you very much.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...>
wrote:
>
> Unfortunately, the page the data was coming from no longer delivers
the
> data within the source code of the web page so that it can be
extracted.
> MorningStar has changed some of their web pages to dynamically display
the
> data.
>
> You can still get limited ROE information from their print page
though. For
> example, TTM could be either:
>
> =RCHGetTableCell("
>
http://quicktake.morningstar. ",com/stocknet/ printreport. aspx?symbol= MMM
> 1,">ROE %")
> =RCHGetTableCell("
>
http://quicktake.morningstar. ",com/stocknet/ printreport. aspx?symbol= MMM
> 12,">Return on Equity")
>
> On Mon, Nov 7, 2011 at 8:18 AM, wu_ming_sg nghongchong@... wrote:
>
> >
> > The element number to get ROE (TTM) from morning star is not
working.
> >
> > (=RCHGetElementNumber(Ticker, 14211))
> >
> > Any workaround please?
> >
> >
>
- 3d.
-
Re: Morning Star Key Ratios
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Nov 7, 2011 8:39 am (PST)
Nope. That's the one that is dynamically generated. That replaced the page
I used to use for the elements.
On Mon, Nov 7, 2011 at 9:28 AM, wu_ming_sg <nghongchong@hotmail.com > wrote:
>
> Are you able to get from this page?
>
>
> http://financials.morningstar. com/ratios/ r.html?t= MMM®ion= USA&culture= en-us
>
> Kindly advise on the formula if you are able to do so as I am very bad at
> it.
>
>
- 4a.
-
No update from Yahoo
Posted by: "SANCHO" sancho_best@yahoo.com sancho_best
Mon Nov 7, 2011 9:41 am (PST)
Hi everybody!
I tried to update tickers from yahoo. Nothing is happening. Quotes are still old from friday 4th. on friday it worked fine. I reinstalled the add-in and it doesn't help.
Does anybody have the same issue right now?
Is it yahoo's problem?
Thanks Alex
- 4b.
-
Re: No update from Yahoo
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Nov 7, 2011 10:24 am (PST)
How are you doing your updating? What parameters are you using for the
function? Have you set your Internet Options so that new content is
retrieved every time a web page is visited (see "Links" area of group for
more info -- item 9.4.2)?
On Mon, Nov 7, 2011 at 10:41 AM, SANCHO <sancho_best@yahoo.com > wrote:
>
> I tried to update tickers from yahoo. Nothing is happening. Quotes are
> still old from friday 4th. on friday it worked fine. I reinstalled the
> add-in and it doesn't help.
>
> Does anybody have the same issue right now?
> Is it yahoo's problem?
>
- 4c.
-
Re: No update from Yahoo
Posted by: "SANCHO" sancho_best@yahoo.com sancho_best
Mon Nov 7, 2011 10:40 am (PST)
Hello Randy!
I still have the issue.
I checked the internet options and the option is on "Every time i visit the webpage".
I checked the "Links" area but i could not find any resoluton to the issue.
Alex
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> How are you doing your updating? What parameters are you using for the
> function? Have you set your Internet Options so that new content is
> retrieved every time a web page is visited (see "Links" area of group for
> more info -- item 9.4.2)?
>
> On Mon, Nov 7, 2011 at 10:41 AM, SANCHO <sancho_best@...> wrote:
>
> >
> > I tried to update tickers from yahoo. Nothing is happening. Quotes are
> > still old from friday 4th. on friday it worked fine. I reinstalled the
> > add-in and it doesn't help.
> >
> > Does anybody have the same issue right now?
> > Is it yahoo's problem?
> >
>
- 4d.
-
Re: No update from Yahoo
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Nov 7, 2011 10:45 am (PST)
Again: How are you triggering the updates? What function syntax are you
using?
You do know that F9 (i.e. "recalculate") will not trigger an update unless
you've made the function volatile using the "refresh" parameter, right?
On Mon, Nov 7, 2011 at 11:40 AM, SANCHO <sancho_best@yahoo.com > wrote:
> Hello Randy!
>
> I still have the issue.
> I checked the internet options and the option is on "Every time i visit
> the webpage".
>
> I checked the "Links" area but i could not find any resoluton to the issue.
>
- 4e.
-
Re: No update from Yahoo
Posted by: "SANCHO" sancho_best@yahoo.com sancho_best
Mon Nov 7, 2011 10:57 am (PST)
formula is RCHgetYahooQuotes.
Reshresh is done by Shift+F9
Everything worked until this Monday
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Again: How are you triggering the updates? What function syntax are you
> using?
>
> You do know that F9 (i.e. "recalculate") will not trigger an update unless
> you've made the function volatile using the "refresh" parameter, right?
>
> On Mon, Nov 7, 2011 at 11:40 AM, SANCHO <sancho_best@...> wrote:
>
> > Hello Randy!
> >
> > I still have the issue.
> > I checked the internet options and the option is on "Every time i visit
> > the webpage".
> >
> > I checked the "Links" area but i could not find any resoluton to the issue.
> >
>
- 4f.
-
Re: No update from Yahoo
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Nov 7, 2011 11:19 am (PST)
Shift-F9 will not recalculate RCHGetYahooQuotes() unless you've made the
function volatile.
On Mon, Nov 7, 2011 at 11:57 AM, SANCHO <sancho_best@yahoo.com > wrote:
> formula is RCHgetYahooQuotes.
> Reshresh is done by Shift+F9
>
> Everything worked until this Monday
>
- 4g.
-
Re: No update from Yahoo
Posted by: "SANCHO" sancho_best@yahoo.com sancho_best
Mon Nov 7, 2011 1:05 pm (PST)
How to make the fuction volatile?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Shift-F9 will not recalculate RCHGetYahooQuotes() unless you've made the
> function volatile.
>
> On Mon, Nov 7, 2011 at 11:57 AM, SANCHO <sancho_best@...> wrote:
>
> > formula is RCHgetYahooQuotes.
> > Reshresh is done by Shift+F9
> >
> > Everything worked until this Monday
> >
>
- 4h.
-
Re: No update from Yahoo
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Nov 7, 2011 1:13 pm (PST)
Read the documentation please -- look at the refresh parameter.
On Mon, Nov 7, 2011 at 2:05 PM, SANCHO <sancho_best@yahoo.com > wrote:
> How to make the fuction volatile?
>
- 4i.
-
Re: No update from Yahoo
Posted by: "SANCHO" sancho_best@yahoo.com sancho_best
Mon Nov 7, 2011 2:07 pm (PST)
I do thonk it is the technical issue from Yahoo since it is possible to pull out only company's quote but not quotes for indices (any indices US, Europe and Asia)
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Read the documentation please -- look at the refresh parameter.
>
> On Mon, Nov 7, 2011 at 2:05 PM, SANCHO <sancho_best@...> wrote:
>
> > How to make the fuction volatile?
> >
>
- 5a.
-
Re: Extract text?
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Mon Nov 7, 2011 10:26 am (PST)
Hi Randy,
Are you able to show me the formulas to remove the tags and put the
statements into different lines in excel pls?
eg. Insider trading information is unavailable or inconsistent.Shares
are neither being accumulated heavily nor sold heavily by financial
institutions.Neutral for a large company like NTES
Thank you.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...>
wrote:
>
> There isn't an add-in formula that will do it all automatically.
You'll need
> to do that manually.
>
> On Mon, Sep 5, 2011 at 3:18 AM, Hong Chong NG nghongchong@...wrote:
>
> >
> > How do I get it to extract the text nicely?
> >
> > Example:
> > OWNERSHIP
> > Grade: C
> >
> > Insider trading information is unavailable or inconsistent.
> >
> > Shares are neither being accumulated heavily nor sold heavily by
financial
> > institutions. *Neutral* for a large company like NTES
> >
> >
> > I used =smfGetTagContent("
> >
http://investing.money.msn. ",com/investments/ stock-ratings/ ?symbol=ntes
"div",2,">Quick
> > Summary",">Ownership")
> > but got the below text with tags.
> >
> > "<p>Insider trading information is unavailable or inconsistent.</p>
> > <p>Shares are neither being accumulated heavily nor sold heavily by
> > financial institutions. <B>Neutral</B> for a large company like
NTES</p>"
> >
>
- 5b.
-
Re: Extract text?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Nov 7, 2011 10:36 am (PST)
The problem with such extraction is the variability of the data. You need
consistency in presentation of the data in order to create formulas that
can extract the data for different tickers. It will pretty much be a trial
and error process as you see what fails on different ticker symbols.
However, getting the individual lines for each group is easy -- just use
the paragraph tags. For example:
=smfGetTagContent("
http://investing.money.msn. ",com/investments/ stock-ratings/ ?symbol=ntes
"p",1,">Quick Summary",">Ownership")
=smfGetTagContent("
http://investing.money.msn. ",com/investments/ stock-ratings/ ?symbol=ntes
"p",2,">Quick Summary",">Ownership")
...return:
Insider trading information is unavailable or inconsistent.
Shares are neither being accumulated heavily nor sold heavily by financial
institutions. <B>Neutral</B> for a large company like NTES
...and you can get the "Neutral" based on the bold tags:
=smfGetTagContent("
http://investing.money.msn. ",com/investments/ stock-ratings/ ?symbol=ntes
"b",1,">Quick Summary",">Ownership")
But if a given ticker is missing the paragraphs, you'll end up getting data
from the next rating category.
On Mon, Nov 7, 2011 at 11:26 AM, wu_ming_sg <nghongchong@hotmail.com > wrote:
>
>
> Are you able to show me the formulas to remove the tags and put the
> statements into different lines in excel pls?
>
> eg.
> Insider trading information is unavailable or inconsistent.
> Shares are neither being accumulated heavily nor sold heavily by financial
> institutions.
> Neutral for a large company like NTES
>
>
- 5c.
-
Re: Extract text?
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Mon Nov 7, 2011 10:51 am (PST)
Hi,
I have checked about 8 stocks and all of them are presented in 2
paragraphs. But sometimes the first para may have a bold tag.
http://investing.money.msn. com/investments/ stock-ratings? symbol=apol
<http://investing.money.msn. >com/investments/ stock-ratings? symbol=apol
eg.Two or more executives, directors or major shareholders sold a small
number of shares recently. Negative
Shares are under heavy accumulation by financial institutions. Positive
for large companies like APOL.
With this info, do you think you can have a workaround to display them
in excel without the tags? I can use 1 row for 1 para.
Thank you.
P.S. I saw in others questions that you have used substitute function
before. Do you think that can help?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...>
wrote:
>
> The problem with such extraction is the variability of the data. You
need
> consistency in presentation of the data in order to create formulas
that
> can extract the data for different tickers. It will pretty much be a
trial
> and error process as you see what fails on different ticker symbols.
>
> However, getting the individual lines for each group is easy -- just
use
> the paragraph tags. For example:
>
> =smfGetTagContent("
>
http://investing.money.msn. ",com/investments/ stock-ratings/ ?symbol=ntes
> "p",1,">Quick Summary",">Ownership")
> =smfGetTagContent("
>
http://investing.money.msn. ",com/investments/ stock-ratings/ ?symbol=ntes
> "p",2,">Quick Summary",">Ownership")
>
> ...return:
>
> Insider trading information is unavailable or inconsistent.
> Shares are neither being accumulated heavily nor sold heavily by
financial
> institutions. <B>Neutral</B> for a large company like NTES
>
> ...and you can get the "Neutral" based on the bold tags:
>
> =smfGetTagContent("
>
http://investing.money.msn. ",com/investments/ stock-ratings/ ?symbol=ntes
> "b",1,">Quick Summary",">Ownership")
>
> But if a given ticker is missing the paragraphs, you'll end up getting
data
> from the next rating category.
>
> On Mon, Nov 7, 2011 at 11:26 AM, wu_ming_sg nghongchong@... wrote:
>
> >
> >
> > Are you able to show me the formulas to remove the tags and put the
> > statements into different lines in excel pls?
> >
> > eg.
> > Insider trading information is unavailable or inconsistent.
> > Shares are neither being accumulated heavily nor sold heavily by
financial
> > institutions.
> > Neutral for a large company like NTES
> >
> >
>
- 5d.
-
Re: Extract text?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Nov 7, 2011 11:04 am (PST)
You could extract the bolded section of each paragraph:
=smfStrExtr(smfGetTagContent ("
http://investing.money.msn. ",com/investments/ stock-ratings/ ?symbol=ntes
"p",1,">Quick Summary",">Ownership"),"<B>" ,"</B>")
=smfStrExtr(smfGetTagContent ("
http://investing.money.msn. ",com/investments/ stock-ratings/ ?symbol=ntes
"p",2,">Quick Summary",">Ownership"),"<B>" ,"</B>")
...but I think you need the beta version of the add-in from the "Works in
Progress" folder to have the smfStrExtr() function available? Maybe not. I
know I did add smfJoin() and smfWord(). If there is nothing bold in the
paragraph, the above functions should return blanks.
For the paragraph verbiage, you can remove the bold tags with the
SUBSTITUTE() function:
=SUBSTITUTE(SUBSTITUTE( smfGetTagContent ("
http://investing.money.msn. ",com/investments/ stock-ratings/ ?symbol=ntes
"p",1,">Quick Summary",">Ownership"),"<B>" ,""),"</B> ","")
=SUBSTITUTE(SUBSTITUTE( smfGetTagContent ("
http://investing.money.msn. ",com/investments/ stock-ratings/ ?symbol=ntes
"p",2,">Quick Summary",">Ownership"),"<B>" ,""),"</B> ","")
On Mon, Nov 7, 2011 at 11:51 AM, wu_ming_sg <nghongchong@hotmail.com > wrote:
>
> I have checked about 8 stocks and all of them are presented in 2
> paragraphs.
> But sometimes the first para may have a bold tag.
>
> http://investing.money.msn. com/investments/ stock-ratings? symbol=apol
>
> eg.
> Two or more executives, directors or major shareholders sold a small
> number of shares recently. *Negative*
>
> Shares are under heavy accumulation by financial institutions. *Positive *for
> large companies like APOL.
>
> With this info, do you think you can have a workaround to display them in
> excel without the tags? I can use 1 row for 1 para.
>
> Thank you.
>
> P.S. I saw in others questions that you have used *substitute *function
> before. Do you think that can help?
>
- 6a.
-
DJIA quotes from Yahoo (^DJI and INDU both failing)
Posted by: "spamfiel" dave@fiel.us spamfiel
Mon Nov 7, 2011 1:54 pm (PST)
I have a sheet that pulls quotes from Yahoo using RCHGetYahooQuotes() which is working fine, except that I can't get a DJIA quote. I know that ^DJI isn't supported, so I have been using the INDU workaround. But today, INDU started failing as well. It returns 0 or N/A for all variables (c1 p2 a h g l1 b k j n). Is there another workaround? Should I switch to another quote provider?
- 6b.
-
Re: DJIA quotes from Yahoo (^DJI and INDU both failing)
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Nov 7, 2011 1:57 pm (PST)
No workaround I'm aware of. Do you NEED the index itself, or would DIA
suffice?
On Mon, Nov 7, 2011 at 2:23 PM, spamfiel <dave@fiel.us> wrote:
> I have a sheet that pulls quotes from Yahoo using RCHGetYahooQuotes()
> which is working fine, except that I can't get a DJIA quote. I know that
> ^DJI isn't supported, so I have been using the INDU workaround. But today,
> INDU started failing as well. It returns 0 or N/A for all variables (c1 p2
> a h g l1 b k j n). Is there another workaround? Should I switch to
> another quote provider?
>
- 7.
-
RCHGet
Posted by: "Paulo" palminha@yahoo.com palminha
Mon Nov 7, 2011 2:04 pm (PST)
I am using the formulas RCHGet with great utility and satisfaction. They work perfectly for companies in the U.S. market, but for the European market I can not obtain all elements on yahoo. I'd like if samone help me find alternatives using the same formulas.
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