15 New Messages
Digest #2394
Messages
Tue Nov 6, 2012 10:21 am (PST) . Posted by:
"ctouchberry@ymail.com" ctouchberry@ymail.com
Is there a way to get the annual high and low for a stock using this add-in? I am currently unable to find a Element Definition that will do this for me. I am looking for historical data that goes back 10 yrs.
Thanks in advance for your help.
Thanks in advance for your help.
Tue Nov 6, 2012 10:27 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I think you'd have to use the smfPricesBetween() function for each
year..which would be slow going.
I'm not aware of a site that show high and low prices for 10 years.
Dividend adjustments might make it problematic.
On Tue, Nov 6, 2012 at 8:48 AM, ctouchberry@ymail.com <ctouchberry@ymail.com
> wrote:
> Is there a way to get the annual high and low for a stock using this
> add-in? I am currently unable to find a Element Definition that will do
> this for me. I am looking for historical data that goes back 10 yrs.
>
> Thanks in advance for your help.
>
year..which would be slow going.
I'm not aware of a site that show high and low prices for 10 years.
Dividend adjustments might make it problematic.
On Tue, Nov 6, 2012 at 8:48 AM, ctouchberry@
> wrote:
> Is there a way to get the annual high and low for a stock using this
> add-in? I am currently unable to find a Element Definition that will do
> this for me. I am looking for historical data that goes back 10 yrs.
>
> Thanks in advance for your help.
>
Tue Nov 6, 2012 10:22 am (PST) . Posted by:
"Thomas Hjort Christensen" thomas.hjort
I've noticed that RCHGetYahooQuotes no longer returns the correct 52-week low stock price.
For instance, RCHGetYahooQuotes("HPQ","j",,,) returns 16.77 even though the correct value is 13.68.
If I get the 52-week range using RCHGetYahooQuotes("HPQ","w",,,) it returns 16.77-30.00, i.e. the 52-week high is fine.
This used to work. Installing the latest add-in did not fix it. Am I doing something wrong?
For instance, RCHGetYahooQuotes(
If I get the 52-week range using RCHGetYahooQuotes(
This used to work. Installing the latest add-in did not fix it. Am I doing something wrong?
Tue Nov 6, 2012 10:30 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, that's the value that Yahoo is returning on the CSV file...
On Tue, Nov 6, 2012 at 10:49 AM, Thomas Hjort Christensen <
thomas.hjort@yahoo.com > wrote:
> I've noticed that RCHGetYahooQuotes no longer returns the correct 52-week
> low stock price.
>
> For instance, RCHGetYahooQuotes("HPQ","j",,,) returns 16.77 even though
> the correct value is 13.68.
>
> If I get the 52-week range using RCHGetYahooQuotes("HPQ","w",,,) it
> returns 16.77-30.00, i.e. the 52-week high is fine.
>
> This used to work. Installing the latest add-in did not fix it. Am I doing
> something wrong?
>
On Tue, Nov 6, 2012 at 10:49 AM, Thomas Hjort Christensen <
thomas.hjort@
> I've noticed that RCHGetYahooQuotes no longer returns the correct 52-week
> low stock price.
>
> For instance, RCHGetYahooQuotes(
> the correct value is 13.68.
>
> If I get the 52-week range using RCHGetYahooQuotes(
> returns 16.77-30.00, i.e. the 52-week high is fine.
>
> This used to work. Installing the latest add-in did not fix it. Am I doing
> something wrong?
>
Tue Nov 6, 2012 10:22 am (PST) . Posted by:
"stumpy_chris" stumpy_chris
I may have missed this but cannot find an answer in search...
Can you use Globe Investor as your input source to get quotes... If so how do you do it.
Thanks.
Can you use Globe Investor as your input source to get quotes... If so how do you do it.
Thanks.
Tue Nov 6, 2012 10:33 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The data they present isn't in tables, so you'll need to use the
smfGetTagContent() function. For example, to get the latest price:
=0+smfGetTagContent("
http://www.theglobeandmail.com/globe-investor/markets/stocks/summary/?q=MMM-N
","span",1,">Latest")
On Tue, Nov 6, 2012 at 11:21 AM, stumpy_chris <cschwartz@nf.sympatico.ca >wrote:
> I may have missed this but cannot find an answer in search...
>
> Can you use Globe Investor as your input source to get quotes... If so how
> do you do it.
>
smfGetTagContent(
=0+smfGetTagContent
http://www.theglobe
","span",1,"
On Tue, Nov 6, 2012 at 11:21 AM, stumpy_chris <cschwartz@nf.
> I may have missed this but cannot find an answer in search...
>
> Can you use Globe Investor as your input source to get quotes... If so how
> do you do it.
>
Tue Nov 6, 2012 11:31 pm (PST) . Posted by:
"Peter James" pmjzz
If you create a portfolio at GlobeInvestor with your stocks in it, and
select the "print" format, the data will be created in a table, which
you can interrogate with a web query. You can check the prices for any
date. I use this to download the prices of all the stocks and mutual
funds that I hold.
Peter
On 2012-11-06 13:33, Randy Harmelink wrote:
> The data they present isn't in tables, so you'll need to use the
> smfGetTagContent() function. For example, to get the latest price:
>
> =0+smfGetTagContent("http://www.theglobeandmail.com/globe-investor/markets/stocks/summary/?q=MMM-N ","span",1,">Latest")
>
> On Tue, Nov 6, 2012 at 11:21 AM, stumpy_chris <cschwartz@nf.sympatico.ca
> <mailto:cschwartz@nf.sympatico.ca >> wrote:
>
> I may have missed this but cannot find an answer in search...
>
> Can you use Globe Investor as your input source to get quotes... If
> so how do you do it.
select the "print" format, the data will be created in a table, which
you can interrogate with a web query. You can check the prices for any
date. I use this to download the prices of all the stocks and mutual
funds that I hold.
Peter
On 2012-11-06 13:33, Randy Harmelink wrote:
> The data they present isn't in tables, so you'll need to use the
> smfGetTagContent(
>
> =0+smfGetTagContent
>
> On Tue, Nov 6, 2012 at 11:21 AM, stumpy_chris <cschwartz@nf.
> <mailto:cschwartz@nf.
>
> I may have missed this but cannot find an answer in search...
>
> Can you use Globe Investor as your input source to get quotes... If
> so how do you do it.
Tue Nov 6, 2012 2:42 pm (PST) . Posted by:
"bradk8605" bradk8605
I have a spreadsheet that has the Morningstar Key ratio's and it has worked for years but now all of a sudden it doesn't work. Any help would be great.
Thanks,
Brad
Thanks,
Brad
Tue Nov 6, 2012 3:11 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
It looks like Morningstar has made another web page dynamic, so there's no
data to extract from the source code of the web page.
What I've been suggesting is to load the CSV version of the into a
worksheet with:
=smfGetCSVFile("
http://financials.morningstar.com/ajax/exportKR2CSV.html?t=MMM ")
...and then get the data you want from there.
On Tue, Nov 6, 2012 at 3:42 PM, bradk8605 <bradk8605@yahoo.com > wrote:
> I have a spreadsheet that has the Morningstar Key ratio's and it has
> worked for years but now all of a sudden it doesn't work. Any help would be
> great.
>
data to extract from the source code of the web page.
What I've been suggesting is to load the CSV version of the into a
worksheet with:
=smfGetCSVFile(
http://financials.
...and then get the data you want from there.
On Tue, Nov 6, 2012 at 3:42 PM, bradk8605 <bradk8605@yahoo.
> I have a spreadsheet that has the Morningstar Key ratio's and it has
> worked for years but now all of a sudden it doesn't work. Any help would be
> great.
>
Tue Nov 6, 2012 11:31 pm (PST) . Posted by:
"sticksandstones46936" sticksandstones46936
I really like this add-in and I would like to use the smfGetPricesByDates function. But the function returns adjusted closing price. I would like to get the closing price - no adjustments. I tried the RCHGetYahooHistory, but that will only return price if the date given is a trading day. I would like the existing price for a given day whether it's a trading day or not. So, I've looked at the add-in code and I can see the "modPricesByDates" module and in that module I see this line
vHQ = RCHGetYahooHistory(pTicker, , , , , , , "d", "DA", 0, 0, 0, iDays, 2)
If I change that "DA" to "DC", would that be enough to get me what I want. If so, would I be able to edit the add-in to change that line. I have a little experience with VBA, but none with add-in.
Any help is appreciated.
Thanks
Dave
vHQ = RCHGetYahooHistory(
If I change that "DA" to "DC", would that be enough to get me what I want. If so, would I be able to edit the add-in to change that line. I have a little experience with VBA, but none with add-in.
Any help is appreciated.
Thanks
Dave
Tue Nov 6, 2012 11:39 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Your change would be the correct one.
On Tue, Nov 6, 2012 at 6:31 PM, sticksandstones46936 <headstring@hotmail.com
> wrote:
> I really like this add-in and I would like to use the smfGetPricesByDates
> function. But the function returns adjusted closing price. I would like
> to get the closing price - no adjustments. I tried the RCHGetYahooHistory,
> but that will only return price if the date given is a trading day. I
> would like the existing price for a given day whether it's a trading day or
> not. So, I've looked at the add-in code and I can see the
> "modPricesByDates" module and in that module I see this line
>
> vHQ = RCHGetYahooHistory(pTicker, , , , , , , "d", "DA", 0, 0, 0, iDays, 2)
>
> If I change that "DA" to "DC", would that be enough to get me what I want.
> If so, would I be able to edit the add-in to change that line. I have a
> little experience with VBA, but none with add-in.
>
On Tue, Nov 6, 2012 at 6:31 PM, sticksandstones4693
> wrote:
> I really like this add-in and I would like to use the smfGetPricesByDates
> function. But the function returns adjusted closing price. I would like
> to get the closing price - no adjustments. I tried the RCHGetYahooHistory,
> but that will only return price if the date given is a trading day. I
> would like the existing price for a given day whether it's a trading day or
> not. So, I've looked at the add-in code and I can see the
> "modPricesByDates" module and in that module I see this line
>
> vHQ = RCHGetYahooHistory(
>
> If I change that "DA" to "DC", would that be enough to get me what I want.
> If so, would I be able to edit the add-in to change that line. I have a
> little experience with VBA, but none with add-in.
>
Wed Nov 7, 2012 12:55 am (PST) . Posted by:
"xslim12" xslim12
http://ycharts.com/companies/AAPL/pe_ratio
I keep getting an error using this code =RCHGetTableCell("http://ycharts.com/companies/ "&ticker&"/pe_ratio",0,"Data for this date range<",,,,3)
I keep getting an error using this code =RCHGetTableCell(
Wed Nov 7, 2012 12:59 am (PST) . Posted by:
"Randy Harmelink" rharmelink
This works fine for me:
=RCHGetTableCell("http://ycharts.com/companies/AAPL/pe_ratio ",0,"Data for
this date range<",,,,3)
...so I'd have to assume there is a problem with the range name of "ticker".
On Wed, Nov 7, 2012 at 1:44 AM, xslim12 <xslim12@yahoo.com > wrote:
> http://ycharts.com/companies/AAPL/pe_ratio
>
> I keep getting an error using this code =RCHGetTableCell("
> http://ycharts.com/companies/ "&ticker&"/pe_ratio",0,"Data for this date
> range<",,,,3)
>
=RCHGetTableCell(
this date range<",,,,3)
...so I'd have to assume there is a problem with the range name of "ticker".
On Wed, Nov 7, 2012 at 1:44 AM, xslim12 <xslim12@yahoo.
> http://ycharts.
>
> I keep getting an error using this code =RCHGetTableCell(
> http://ycharts.
> range<",,,,3)
>
Wed Nov 7, 2012 1:03 am (PST) . Posted by:
"xslim12" xslim12
You are right, it does work when you have the full text in there. I linked it to another cell with the ticker symbol and still doesn't work.
I wonder if ycharts has something in place to prevent this?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> This works fine for me:
>
> =RCHGetTableCell("http://ycharts.com/companies/AAPL/pe_ratio ",0,"Data for
> this date range<",,,,3)
>
> ...so I'd have to assume there is a problem with the range name of "ticker".
>
> On Wed, Nov 7, 2012 at 1:44 AM, xslim12 <xslim12@...> wrote:
>
> > http://ycharts.com/companies/AAPL/pe_ratio
> >
> > I keep getting an error using this code =RCHGetTableCell("
> > http://ycharts.com/companies/ "&ticker&"/pe_ratio",0,"Data for this date
> > range<",,,,3)
> >
>
I wonder if ycharts has something in place to prevent this?
--- In smf_addin@yahoogrou
>
> This works fine for me:
>
> =RCHGetTableCell(
> this date range<",,,,3)
>
> ...so I'd have to assume there is a problem with the range name of "ticker".
>
> On Wed, Nov 7, 2012 at 1:44 AM, xslim12 <xslim12@...
>
> > http://ycharts.
> >
> > I keep getting an error using this code =RCHGetTableCell(
> > http://ycharts.
> > range<",,,,3)
> >
>
Wed Nov 7, 2012 1:04 am (PST) . Posted by:
"xslim12" xslim12
Problem solved! Case Sensitive lol
--- In smf_addin@yahoogroups.com , "xslim12" <xslim12@...> wrote:
>
> You are right, it does work when you have the full text in there. I linked it to another cell with the ticker symbol and still doesn't work.
>
> I wonder if ycharts has something in place to prevent this?
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > This works fine for me:
> >
> > =RCHGetTableCell("http://ycharts.com/companies/AAPL/pe_ratio ",0,"Data for
> > this date range<",,,,3)
> >
> > ...so I'd have to assume there is a problem with the range name of "ticker".
> >
> > On Wed, Nov 7, 2012 at 1:44 AM, xslim12 <xslim12@> wrote:
> >
> > > http://ycharts.com/companies/AAPL/pe_ratio
> > >
> > > I keep getting an error using this code =RCHGetTableCell("
> > > http://ycharts.com/companies/ "&ticker&"/pe_ratio",0,"Data for this date
> > > range<",,,,3)
> > >
> >
>
--- In smf_addin@yahoogrou
>
> You are right, it does work when you have the full text in there. I linked it to another cell with the ticker symbol and still doesn't work.
>
> I wonder if ycharts has something in place to prevent this?
>
> --- In smf_addin@yahoogrou
> >
> > This works fine for me:
> >
> > =RCHGetTableCell(
> > this date range<",,,,3)
> >
> > ...so I'd have to assume there is a problem with the range name of "ticker".
> >
> > On Wed, Nov 7, 2012 at 1:44 AM, xslim12 <xslim12@> wrote:
> >
> > > http://ycharts.
> > >
> > > I keep getting an error using this code =RCHGetTableCell(
> > > http://ycharts.
> > > range<",,,,3)
> > >
> >
>
Tidak ada komentar:
Posting Komentar