11 New Messages
Digest #2720
1a
Multi-Year Low/High (e.g. 5-Year Low/High) with Yahoo Data by "williamappleyard1" williamappleyard1
Messages
Fri Aug 2, 2013 2:30 pm (PDT) . Posted by:
"williamappleyard1" williamappleyard1
Hello,
Does anyone know if it is possible to get a 5-year low/high for stock prices using Yahoo data please?
Thank you,
Does anyone know if it is possible to get a 5-year low/high for stock prices using Yahoo data please?
Thank you,
Fri Aug 2, 2013 2:36 pm (PDT) . Posted by:
"Randy H" rharmelink
Just use the smfPricesBetween() function.
--- In smf_addin@yahoogroups.com , "williamappleyard1" <william.appleyard@...> wrote:
>
> Does anyone know if it is possible to get a 5-year low/high for stock
> prices using Yahoo data please?
--- In smf_addin@yahoogrou
>
> Does anyone know if it is possible to get a 5-year low/high for stock
> prices using Yahoo data please?
Fri Aug 2, 2013 7:40 pm (PDT) . Posted by:
"lawrence.leesh" lawrence.leesh
Hi Randy
I managed to get a return for =smfGetADVFNElement("nyse:awi","A",5,"year end date")
but not for
=smfGetADVFNElement("nasdaq:aapl","A",5,"year end date")
Am I doing something incorrectly?
thanks
LL
I managed to get a return for =smfGetADVFNElement
but not for
=smfGetADVFNElement
Am I doing something incorrectly?
thanks
LL
Fri Aug 2, 2013 7:51 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm not sure what to tell you, since:
smfGetADVFNElement("nasdaq:aapl","A",5,"year end date")
...works fine here, returning "2008/09". Are you using a special prefix?
On Fri, Aug 2, 2013 at 7:40 PM, lawrence.leesh <lawrence.leesh@yahoo.com >wrote:
>
> I managed to get a return for =smfGetADVFNElement("nyse:awi","A",5,"year
> end date")
>
> but not for
> =smfGetADVFNElement("nasdaq:aapl","A",5,"year end date")
>
> Am I doing something incorrectly?
>
smfGetADVFNElement(
...works fine here, returning "2008/09"
On Fri, Aug 2, 2013 at 7:40 PM, lawrence.leesh <lawrence.leesh@
>
> I managed to get a return for =smfGetADVFNElement
> end date")
>
> but not for
> =smfGetADVFNElement
>
> Am I doing something incorrectly?
>
Fri Aug 2, 2013 8:02 pm (PDT) . Posted by:
"lawrence.leesh" lawrence.leesh
Yes. My prefix is asia and I have put those words in the file. That is why I managed to get a return for the first formula. I tried smfforcerecalculation too but still returned an error.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I'm not sure what to tell you, since:
>
> smfGetADVFNElement("nasdaq:aapl","A",5,"year end date")
>
> ...works fine here, returning "2008/09". Are you using a special prefix?
>
> On Fri, Aug 2, 2013 at 7:40 PM, lawrence.leesh <lawrence.leesh@...>wrote:
>
> >
> > I managed to get a return for =smfGetADVFNElement("nyse:awi","A",5,"year
> > end date")
> >
> > but not for
> > =smfGetADVFNElement("nasdaq:aapl","A",5,"year end date")
> >
> > Am I doing something incorrectly?
> >
>
--- In smf_addin@yahoogrou
>
> I'm not sure what to tell you, since:
>
> smfGetADVFNElement(
>
> ...works fine here, returning "2008/09"
>
> On Fri, Aug 2, 2013 at 7:40 PM, lawrence.leesh <lawrence.
>
> >
> > I managed to get a return for =smfGetADVFNElement
> > end date")
> >
> > but not for
> > =smfGetADVFNElement
> >
> > Am I doing something incorrectly?
> >
>
Fri Aug 2, 2013 8:11 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It looks like "asia" uses a completely different URL structure. It does
redirect to the new URL in a browser, but MicroSoft's XMLHTTP protocol that
the add-in uses doesn't stand up well to being redirected.
At this point, your only option would be to write your own
RCHGetTableCell() functions using that "asia" URL structure.
As an example, the typical URL is:
http://www.advfn.com/p.php?pid=financials&btn=annual_reports&mode=&symbol=NASDAQ:AAPL
...which, for "asia", redirects to:
http://asia.advfn.com/exchanges/NASDAQ/AAPL/financials?btn=annual_reports
On Fri, Aug 2, 2013 at 8:02 PM, lawrence.leesh <lawrence.leesh@yahoo.com >wrote:
> Yes. My prefix is asia and I have put those words in the file. That is why
> I managed to get a return for the first formula. I tried
> smfforcerecalculation too but still returned an error.
>
redirect to the new URL in a browser, but MicroSoft'
the add-in uses doesn't stand up well to being redirected.
At this point, your only option would be to write your own
RCHGetTableCell(
As an example, the typical URL is:
http://www.advfn.
...which, for "asia"
http://asia.
On Fri, Aug 2, 2013 at 8:02 PM, lawrence.leesh <lawrence.leesh@
> Yes. My prefix is asia and I have put those words in the file. That is why
> I managed to get a return for the first formula. I tried
> smfforcerecalculati
>
Fri Aug 2, 2013 8:33 pm (PDT) . Posted by:
"lawrence.leesh" lawrence.leesh
Thanks Randy.
I managed to get a return for
=RCHGetTableCell("http://asia.advfn.com/exchanges/NASDAQ/AAPL/financials?btn=annual_reports ",5,"year end date")
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> It looks like "asia" uses a completely different URL structure. It does
> redirect to the new URL in a browser, but MicroSoft's XMLHTTP protocol that
> the add-in uses doesn't stand up well to being redirected.
>
> At this point, your only option would be to write your own
> RCHGetTableCell() functions using that "asia" URL structure.
>
> As an example, the typical URL is:
>
> http://www.advfn.com/p.php?pid=financials&btn=annual_reports&mode=&symbol=NASDAQ:AAPL
>
> ...which, for "asia", redirects to:
>
> http://asia.advfn.com/exchanges/NASDAQ/AAPL/financials?btn=annual_reports
>
> On Fri, Aug 2, 2013 at 8:02 PM, lawrence.leesh <lawrence.leesh@...>wrote:
>
> > Yes. My prefix is asia and I have put those words in the file. That is why
> > I managed to get a return for the first formula. I tried
> > smfforcerecalculation too but still returned an error.
> >
>
I managed to get a return for
=RCHGetTableCell(
--- In smf_addin@yahoogrou
>
> It looks like "asia" uses a completely different URL structure. It does
> redirect to the new URL in a browser, but MicroSoft'
> the add-in uses doesn't stand up well to being redirected.
>
> At this point, your only option would be to write your own
> RCHGetTableCell(
>
> As an example, the typical URL is:
>
> http://www.advfn.
>
> ...which, for "asia"
>
> http://asia.
>
> On Fri, Aug 2, 2013 at 8:02 PM, lawrence.leesh <lawrence.
>
> > Yes. My prefix is asia and I have put those words in the file. That is why
> > I managed to get a return for the first formula. I tried
> > smfforcerecalculati
> >
>
Fri Aug 2, 2013 11:27 pm (PDT) . Posted by:
"lawrence.leesh" lawrence.leesh
When I enter =RCHGetTableCell("http://asia.advfn.com/exchanges/nasdaq/aapl/financials?btn=annual_reports ",5,"depreciation")
Instead of returning 3277, it gives me 87,846 which is "cost of sales with depreciation". How can I get it to return the right value?
thanks
--- In smf_addin@yahoogroups.com , "lawrence.leesh" <lawrence.leesh@...> wrote:
>
> Thanks Randy.
>
> I managed to get a return for
> =RCHGetTableCell("http://asia.advfn.com/exchanges/NASDAQ/AAPL/financials?btn=annual_reports ",5,"year end date")
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > It looks like "asia" uses a completely different URL structure. It does
> > redirect to the new URL in a browser, but MicroSoft's XMLHTTP protocol that
> > the add-in uses doesn't stand up well to being redirected.
> >
> > At this point, your only option would be to write your own
> > RCHGetTableCell() functions using that "asia" URL structure.
> >
> > As an example, the typical URL is:
> >
> > http://www.advfn.com/p.php?pid=financials&btn=annual_reports&mode=&symbol=NASDAQ:AAPL
> >
> > ...which, for "asia", redirects to:
> >
> > http://asia.advfn.com/exchanges/NASDAQ/AAPL/financials?btn=annual_reports
> >
> > On Fri, Aug 2, 2013 at 8:02 PM, lawrence.leesh <lawrence.leesh@>wrote:
> >
> > > Yes. My prefix is asia and I have put those words in the file. That is why
> > > I managed to get a return for the first formula. I tried
> > > smfforcerecalculation too but still returned an error.
> > >
> >
>
Instead of returning 3277, it gives me 87,846 which is "cost of sales with depreciation"
thanks
--- In smf_addin@yahoogrou
>
> Thanks Randy.
>
> I managed to get a return for
> =RCHGetTableCell(
>
> --- In smf_addin@yahoogrou
> >
> > It looks like "asia" uses a completely different URL structure. It does
> > redirect to the new URL in a browser, but MicroSoft'
> > the add-in uses doesn't stand up well to being redirected.
> >
> > At this point, your only option would be to write your own
> > RCHGetTableCell(
> >
> > As an example, the typical URL is:
> >
> > http://www.advfn.
> >
> > ...which, for "asia"
> >
> > http://asia.
> >
> > On Fri, Aug 2, 2013 at 8:02 PM, lawrence.leesh <lawrence.
> >
> > > Yes. My prefix is asia and I have put those words in the file. That is why
> > > I managed to get a return for the first formula. I tried
> > > smfforcerecalculati
> > >
> >
>
Fri Aug 2, 2013 11:31 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try adding the end of the HTML tag right in front of it:
=RCHGetTableCell("
http://asia.advfn.com/exchanges/nasdaq/aapl/financials?btn=annual_reports
",5,">depreciation")
...otherwise it just looks for the first occurrence of the word
"depreciation".
On Fri, Aug 2, 2013 at 11:27 PM, lawrence.leesh <lawrence.leesh@yahoo.com >wrote:
> When I enter =RCHGetTableCell("
> http://asia.advfn.com/exchanges/nasdaq/aapl/financials?btn=annual_reports
> ",5,"depreciation")
> Instead of returning 3277, it gives me 87,846 which is "cost of sales with
> depreciation". How can I get it to return the right value?
>
=RCHGetTableCell(
http://asia.
",5,"
...otherwise it just looks for the first occurrence of the word
"depreciation&
On Fri, Aug 2, 2013 at 11:27 PM, lawrence.leesh <lawrence.leesh@
> When I enter =RCHGetTableCell(
> http://asia.
> ",5,"
> Instead of returning 3277, it gives me 87,846 which is "cost of sales with
> depreciation"
>
Fri Aug 2, 2013 11:21 pm (PDT) . Posted by:
"ajtalukdar" ajtalukdar
I have been hit by the Asia advfn site, as have other users. Applying the UK prefix fix works, however only partly. Now I find that
the following calls work
RCHGetElementNumber("ORCL";,8186)
RCHGetElementNumber("YUM",8186)
while the following DO NOT work - returning Error
RCHGetElementNumber("CSX",8186)
RCHGetElementNumber("WAG",8186)
Any ideas why some stock codes are working while others are not?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> You can try the AdvFN fix described in the LINKS area of the group.
>
> Otherwise, I'll need more details -- a specific ticker symbol, a specific
> element number, do you override the default prefix, etc. For example, this
> works fine for me:
>
> =RCHGetElementNumber("MMM";,5196)
>
> On Thu, Aug 1, 2013 at 10:41 PM, ajtalukdar <ajtalukdar@...> wrote:
>
> > All of a sudden, since this morning the smf-addin in Excel is not pulling
> > any data for any stocks. I am getting error codes everywhere. I have
> > checked that the add-in itself is working since it is able to pull data
> > from Google.
> >
> > Is anyone else facing this problem?
> >
>
the following calls work
RCHGetElementNumber
RCHGetElementNumber
while the following DO NOT work - returning Error
RCHGetElementNumber
RCHGetElementNumber
Any ideas why some stock codes are working while others are not?
--- In smf_addin@yahoogrou
>
> You can try the AdvFN fix described in the LINKS area of the group.
>
> Otherwise, I'll need more details -- a specific ticker symbol, a specific
> element number, do you override the default prefix, etc. For example, this
> works fine for me:
>
> =RCHGetElementNumbe
>
> On Thu, Aug 1, 2013 at 10:41 PM, ajtalukdar <ajtalukdar@
>
> > All of a sudden, since this morning the smf-addin in Excel is not pulling
> > any data for any stocks. I am getting error codes everywhere. I have
> > checked that the add-in itself is working since it is able to pull data
> > from Google.
> >
> > Is anyone else facing this problem?
> >
>
Fri Aug 2, 2013 11:36 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's because you have a CSX and WAG on the London Stock Exchange, which
is what the "uk" website will default to when no stock exchange is cited.
If you're after U.S. stocks, you should always use the exchange prefix when
using the "uk" website. So, try NYSE:CSX and NYSE:WAG as your ticker
symbols.
On Fri, Aug 2, 2013 at 11:21 PM, ajtalukdar <ajtalukdar@yahoo.com > wrote:
> Applying the UK prefix fix works, however only partly. Now I find that
>
> the following calls work
> RCHGetElementNumber("ORCL";,8186)
> RCHGetElementNumber("YUM",8186)
>
> while the following DO NOT work - returning Error
> RCHGetElementNumber("CSX",8186)
> RCHGetElementNumber("WAG",8186)
>
> Any ideas why some stock codes are working while others are not?
>
is what the "uk" website will default to when no stock exchange is cited.
If you're after U.S. stocks, you should always use the exchange prefix when
using the "uk" website. So, try NYSE:CSX and NYSE:WAG as your ticker
symbols.
On Fri, Aug 2, 2013 at 11:21 PM, ajtalukdar <ajtalukdar@yahoo.
> Applying the UK prefix fix works, however only partly. Now I find that
>
> the following calls work
> RCHGetElementNumber
> RCHGetElementNumber
>
> while the following DO NOT work - returning Error
> RCHGetElementNumber
> RCHGetElementNumber
>
> Any ideas why some stock codes are working while others are not?
>
Tidak ada komentar:
Posting Komentar