13 New Messages
Digest #2503
6b
Re: Is it possible to reference stock symbol in =RCHGetElementNumber by "Randy Harmelink" rharmelink
Messages
Sat Feb 9, 2013 11:06 am (PST) . Posted by:
"PLA" option2z
Thanks Randy. Yes, the examples posted are at the end of the alphabet, but
there were many more. I thought that YAHOO had fixed it, but not.
2/1/2002, a Friday is missing from them all, but not from SPY. I solved it
the brute force way. I run a routine that deletes any extra SPY days that
don't match. Works for me, and unlikely to have much effect on my
simulation runs. Yukie solution, but practical enough.
Thanks,
Pete A
http://www.sundognorth.com/TtP-S/ >
RE:
Years ago, this used to be a common issue -- there would be a lot of "date
missing" in Yahoo historical data, because they didn't use to post an entry
for a day with zero volume (is that a "trading" day?).
It could be they just had an issue with the update process on that
particular day, and some stocks didn't get updated. Note that many of the
ones you listed are late in the alphabet.
My suggestion would be to mention it to Yahoo.
On Fri, Feb 8, 2013 at 5:29 PM, PLA optionzz@gmail.com
> wrote:
>
> All,****
>
> I've been running some simulations that require downloading daily adjusted
> close data for each stock. I also download the same period for the SPY.
It's
> worked well for many months. Recently, though, MANY stocks have a single
> day missing out of 11 years of daily data. The SPY downloads perfectly
> and is complete. ****
>
> ** **
>
> I'd suspect my code, except that that the same called routine downloads
> both the SPY and the others. It has persisted across a couple of days
> now, and not all stocks. Here's a list of a few of them: WR, UIL, WBK,
> WDR, WEC, WM. 12/21/2001 - 12/21/2012. 2/1/2002 is a date that has a
> SPY value, but not for any of these stocks. It is a Friday according to DR
> Google. ****
>
> ** **
>
> If anyone has an idea, I'd certainly appreciate it. I can patch the
> download to insert a dummy value, but SHEESH, that seems improper to me J
> Thanks!****
>
> * Thanks, *
>
> * Pete A*
>
> http://www.sundognorth.com/TtP-S/ >****
>
> ****
>
> ** **
>
>
there were many more. I thought that YAHOO had fixed it, but not.
2/1/2002, a Friday is missing from them all, but not from SPY. I solved it
the brute force way. I run a routine that deletes any extra SPY days that
don't match. Works for me, and unlikely to have much effect on my
simulation runs. Yukie solution, but practical enough.
Thanks,
Pete A
http://www.sundogno
RE:
Years ago, this used to be a common issue -- there would be a lot of "date
missing" in Yahoo historical data, because they didn't use to post an entry
for a day with zero volume (is that a "trading" day?).
It could be they just had an issue with the update process on that
particular day, and some stocks didn't get updated. Note that many of the
ones you listed are late in the alphabet.
My suggestion would be to mention it to Yahoo.
On Fri, Feb 8, 2013 at 5:29 PM, PLA optionzz@gmail.
> wrote:
>
> All,****
>
> I've been running some simulations that require downloading daily adjusted
> close data for each stock. I also download the same period for the SPY.
It's
> worked well for many months. Recently, though, MANY stocks have a single
> day missing out of 11 years of daily data. The SPY downloads perfectly
> and is complete. ****
>
> ** **
>
> I'd suspect my code, except that that the same called routine downloads
> both the SPY and the others. It has persisted across a couple of days
> now, and not all stocks. Here's a list of a few of them: WR, UIL, WBK,
> WDR, WEC, WM. 12/21/2001 - 12/21/2012. 2/1/2002 is a date that has a
> SPY value, but not for any of these stocks. It is a Friday according to DR
> Google. ****
>
> ** **
>
> If anyone has an idea, I'd certainly appreciate it. I can patch the
> download to insert a dummy value, but SHEESH, that seems improper to me J
> Thanks!****
>
> * Thanks, *
>
> * Pete A*
>
> http://www.sundogno
>
> ****
>
> ** **
>
>
Sat Feb 9, 2013 1:25 pm (PST) . Posted by:
"Jacob Jose" pepecan47
I am trying to extract dividends history from Earnings.com, elements 1421 to 1509.
When I try MCD, I get duplicate dates from different dividends. I went to the WEB site, and for the dividends, there are 2 different symbols, MCD and MCD.BA
It seems SMF is mixing them up. Is it possible for the SMF, when I type MCD as the ticker, to grab only the dividends related to MCD?
Another suggestion, is it possible to increase the number of dividends from 23 to 44, so we can get 10 (40 quarters past 10 years + 4 quarters current year) years of data?
thx a lot.
Regards,
Jose L. Jacob
I am using SMF-Template-Earnings.com-Data.sls.
When I try MCD, I get duplicate dates from different dividends. I went to the WEB site, and for the dividends, there are 2 different symbols, MCD and MCD.BA
It seems SMF is mixing them up. Is it possible for the SMF, when I type MCD as the ticker, to grab only the dividends related to MCD?
Another suggestion, is it possible to increase the number of dividends from 23 to 44, so we can get 10 (40 quarters past 10 years + 4 quarters current year) years of data?
thx a lot.
Regards,
Jose L. Jacob
I am using SMF-Template-
Sat Feb 9, 2013 1:34 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Yeah. I didn't find out about the mix of ticker symbols until after I had
defined the elements, which is why ticker symbol isn't one of the elements.
The example I had used to define the elements didn't have multiple ticker
symbols.
At that point, I just decided earnings.com wasn't a good source of such
data and left the element definitions alone, instead of deleting them.
The things you want to do can be done by using RCHGetTableCell() to grab
the data, or grabbing it with RCHGetHTMLTable() and then selecting which
pieces you want to use.
Otherwise, RCHGetYahooHistory() would be a much better way to go.
On Sat, Feb 9, 2013 at 2:25 PM, Jacob Jose pepecan47@yahoo.ca > wrote:
>
> I am trying to extract dividends history from Earnings.com, elements 1421
> to 1509.
> I am using SMF-Template-Earnings.com-Data.sls.
> When I try MCD, I get duplicate dates from different dividends. I went to
> the WEB site, and for the dividends, there are 2 different symbols, MCDand
> MCD.BA
>
> It seems SMF is mixing them up. Is it possible for the SMF, when I type
> MCD as the ticker, to grab only the dividends related to MCD?
>
> Another suggestion, is it possible to increase the number of dividends
> from 23 to 44, so we can get 10 (40 quarters past 10 years + 4 quarters
> current year) years of data?
>
>
defined the elements, which is why ticker symbol isn't one of the elements.
The example I had used to define the elements didn't have multiple ticker
symbols.
At that point, I just decided earnings.com wasn't a good source of such
data and left the element definitions alone, instead of deleting them.
The things you want to do can be done by using RCHGetTableCell(
the data, or grabbing it with RCHGetHTMLTable(
pieces you want to use.
Otherwise, RCHGetYahooHistory(
On Sat, Feb 9, 2013 at 2:25 PM, Jacob Jose pepecan47@yahoo.
>
> I am trying to extract dividends history from Earnings.com, elements 1421
> to 1509.
> I am using SMF-Template-
> When I try MCD, I get duplicate dates from different dividends. I went to
> the WEB site, and for the dividends, there are 2 different symbols, MCDand
> MCD.BA
>
> It seems SMF is mixing them up. Is it possible for the SMF, when I type
> MCD as the ticker, to grab only the dividends related to MCD?
>
> Another suggestion, is it possible to increase the number of dividends
> from 23 to 44, so we can get 10 (40 quarters past 10 years + 4 quarters
> current year) years of data?
>
>
Sat Feb 9, 2013 3:32 pm (PST) . Posted by:
"Tze Wei," tzewei_79
hi,
I realised yahoo data is different from MSN.MSN seems to match the company's report.
Regards,
Lewis
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> Yeah. I didn't find out about the mix of ticker symbols until after I had
> defined the elements, which is why ticker symbol isn't one of the elements.
> The example I had used to define the elements didn't have multiple ticker
> symbols.
>
> At that point, I just decided earnings.com wasn't a good source of such
> data and left the element definitions alone, instead of deleting them.
>
> The things you want to do can be done by using RCHGetTableCell() to grab
> the data, or grabbing it with RCHGetHTMLTable() and then selecting which
> pieces you want to use.
>
> Otherwise, RCHGetYahooHistory() would be a much better way to go.
>
> On Sat, Feb 9, 2013 at 2:25 PM, Jacob Jose wrote:
>
> >
> > I am trying to extract dividends history from Earnings.com, elements 1421
> > to 1509.
> > I am using SMF-Template-Earnings.com-Data.sls.
> > When I try MCD, I get duplicate dates from different dividends. I went to
> > the WEB site, and for the dividends, there are 2 different symbols, MCDand
> > MCD.BA
> >
> > It seems SMF is mixing them up. Is it possible for the SMF, when I type
> > MCD as the ticker, to grab only the dividends related to MCD?
> >
> > Another suggestion, is it possible to increase the number of dividends
> > from 23 to 44, so we can get 10 (40 quarters past 10 years + 4 quarters
> > current year) years of data?
> >
> >
>
I realised yahoo data is different from MSN.MSN seems to match the company'
Regards,
Lewis
--- In smf_addin@yahoogrou
>
> Yeah. I didn't find out about the mix of ticker symbols until after I had
> defined the elements, which is why ticker symbol isn't one of the elements.
> The example I had used to define the elements didn't have multiple ticker
> symbols.
>
> At that point, I just decided earnings.com wasn't a good source of such
> data and left the element definitions alone, instead of deleting them.
>
> The things you want to do can be done by using RCHGetTableCell(
> the data, or grabbing it with RCHGetHTMLTable(
> pieces you want to use.
>
> Otherwise, RCHGetYahooHistory(
>
> On Sat, Feb 9, 2013 at 2:25 PM, Jacob Jose wrote:
>
> >
> > I am trying to extract dividends history from Earnings.com, elements 1421
> > to 1509.
> > I am using SMF-Template-
> > When I try MCD, I get duplicate dates from different dividends. I went to
> > the WEB site, and for the dividends, there are 2 different symbols, MCDand
> > MCD.BA
> >
> > It seems SMF is mixing them up. Is it possible for the SMF, when I type
> > MCD as the ticker, to grab only the dividends related to MCD?
> >
> > Another suggestion, is it possible to increase the number of dividends
> > from 23 to 44, so we can get 10 (40 quarters past 10 years + 4 quarters
> > current year) years of data?
> >
> >
>
Sun Feb 10, 2013 7:09 am (PST) . Posted by:
"Jacob Jose" pepecan47
Hi Randy - thanks a lot for your answers.
If I use RCHGetYahooHistory() to get the dividends history, how can I get the totals by year?
If I have a cell with the value 2010 (for example), how can I get in another cell the sum al all dividends paid in 2010?
Regards,
Jose L. Jacob
________________________________
From: Randy Harmelink rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Saturday, February 9, 2013 4:34:12 PM
Subject: Re: [smf_addin] Dividends from Earnings.com
Yeah. I didn't find out about the mix of ticker symbols until after I had defined the elements, which is why ticker symbol isn't one of the elements. The example I had used to define the elements didn't have multiple ticker symbols.
At that point, I just decided earnings.com wasn't a good source of such data and left the element definitions alone, instead of deleting them.
The things you want to do can be done by using RCHGetTableCell() to grab the data, or grabbing it with RCHGetHTMLTable() and then selecting which pieces you want to use.
Otherwise, RCHGetYahooHistory() would be a much better way to go.
On Sat, Feb 9, 2013 at 2:25 PM, Jacob Jose pepecan47@yahoo.ca > wrote:
>
>I am trying to extract dividends history from Earnings.com, elements 1421 to 1509.
>I am using SMF-Template-Earnings.com-Data.sls.
>When I try MCD, I get duplicate dates from different dividends. I went to the WEB site, and for the dividends, there are 2 different symbols, MCD and MCD.BA
>
>It seems SMF is mixing them up. Is it possible for the SMF, when I type MCD as the ticker, to grab only the dividends related to MCD?
>
>Another suggestion, is it possible to increase the number of dividends from 23 to 44, so we can get 10 (40 quarters past 10 years + 4 quarters current year) years of data?
>
>
If I use RCHGetYahooHistory(
If I have a cell with the value 2010 (for example), how can I get in another cell the sum al all dividends paid in 2010?
Regards,
Jose L. Jacob
____________
From: Randy Harmelink rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Saturday, February 9, 2013 4:34:12 PM
Subject: Re: [smf_addin] Dividends from Earnings.com
Yeah. I didn't find out about the mix of ticker symbols until after I had defined the elements, which is why ticker symbol isn't one of the elements. The example I had used to define the elements didn't have multiple ticker symbols.
At that point, I just decided earnings.com wasn't a good source of such data and left the element definitions alone, instead of deleting them.
The things you want to do can be done by using RCHGetTableCell(
Otherwise, RCHGetYahooHistory(
On Sat, Feb 9, 2013 at 2:25 PM, Jacob Jose pepecan47@yahoo.
>
>I am trying to extract dividends history from Earnings.com, elements 1421 to 1509.
>I am using SMF-Template-
>When I try MCD, I get duplicate dates from different dividends. I went to the WEB site, and for the dividends, there are 2 different symbols, MCD and MCD.BA
>
>It seems SMF is mixing them up. Is it possible for the SMF, when I type MCD as the ticker, to grab only the dividends related to MCD?
>
>Another suggestion, is it possible to increase the number of dividends from 23 to 44, so we can get 10 (40 quarters past 10 years + 4 quarters current year) years of data?
>
>
Sat Feb 9, 2013 4:10 pm (PST) . Posted by:
"bobc94595" bobc94595
Randy, I have entered in Cell b5 the following formula: =IF($A$6<>"y","--",RCHGetYahooQuotes(A8:A114,B7:E7)) In Cell A6, I entered "n" to halt the recalculation.
Unfortunately, all the "last quote" prices which are triggered by Yahoo Code l1 are updating automatically when I open the file. Is there another solution, or am I placing the formula in the wrong place?
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> Only two ways to prevent the recalculation and preserve what is displayed
> -- turn of automatic calculation, or convert everything to values. If you
> wanted to preserve the values infrequently, as in the year-end case, I
> would first create another worksheet, then copy the original worksheet and
> paste special both values and formats into the new empty workbook, and then
> name the tab appropriately.
>
> As far as a trigger cell, it would be something like:
>
> =IF($B$2<>"Y","--",RCHGetYahooQuotes(A4:A106,B3:E3))
>
> ...so when you save the workbook, you set cell B2 to "N", and everything
> will be set to "--". When you next open the workbook, no Internet access
> would be performed, because the RCHGetYahooQuotes() function would not be
> executed.
>
> Typically, I do that when it would take some time to open a workbook,
> because of the number of Internet accesses that need to be done. And I may
> not want the current formulas to update until after I've made some changes
> to the workbook.
>
> On Wed, Jan 16, 2013 at 11:00 PM, bobc94595 wrote:
>
> > Is there a formula modification which can be made to the array formula
> > "RCHGetYahooQuotes(A4:A106,B3:E3)" which will prevent automatic
> > recalculation or update of the worksheet upon its next opening? I would
> > like to preserve the sheet as of a particular date (e.g. year end
> > 12/31/12,) and not have it recalculated automatically if I open it
> > thereafter. How do I preserve the sheet as of a specific date?
> >
> > How does one establish a trigger cell for recalculation?
> >
>
Unfortunately, all the "last quote" prices which are triggered by Yahoo Code l1 are updating automatically when I open the file. Is there another solution, or am I placing the formula in the wrong place?
--- In smf_addin@yahoogrou
>
> Only two ways to prevent the recalculation and preserve what is displayed
> -- turn of automatic calculation, or convert everything to values. If you
> wanted to preserve the values infrequently, as in the year-end case, I
> would first create another worksheet, then copy the original worksheet and
> paste special both values and formats into the new empty workbook, and then
> name the tab appropriately.
>
> As far as a trigger cell, it would be something like:
>
> =IF($B$2<
>
> ...so when you save the workbook, you set cell B2 to "N"
> will be set to "--"
> would be performed, because the RCHGetYahooQuotes(
> executed.
>
> Typically, I do that when it would take some time to open a workbook,
> because of the number of Internet accesses that need to be done. And I may
> not want the current formulas to update until after I've made some changes
> to the workbook.
>
> On Wed, Jan 16, 2013 at 11:00 PM, bobc94595 wrote:
>
> > Is there a formula modification which can be made to the array formula
> > "RCHGetYahooQu
> > recalculation or update of the worksheet upon its next opening? I would
> > like to preserve the sheet as of a particular date (e.g. year end
> > 12/31/12,) and not have it recalculated automatically if I open it
> > thereafter. How do I preserve the sheet as of a specific date?
> >
> > How does one establish a trigger cell for recalculation?
> >
>
Sat Feb 9, 2013 4:23 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I don't understand why the formula you cite would be in cell B5? It looks
like it should be array-entered over B8:E117. And that should be such a
fast calculation, I'm not sure why you would need a trigger cell.
In any case, entering "n" in cell A6 would not HALT recalculation,it would
trigger more calculations. You want to set the value to "n" when you save
the file, so that when you open the file, no calculations are being done.
Then, changing it to "y" is what triggers the recalculation.
On Sat, Feb 9, 2013 at 5:10 PM, bobc94595 conlonrc@comcast.net > wrote:
> Randy, I have entered in Cell b5 the following formula:
> =IF($A$6<>"y","--",RCHGetYahooQuotes(A8:A114,B7:E7)) In Cell A6, I entered
> "n" to halt the recalculation.
>
> Unfortunately, all the "last quote" prices which are triggered by Yahoo
> Code l1 are updating automatically when I open the file. Is there another
> solution, or am I placing the formula in the wrong place?
>
like it should be array-entered over B8:E117. And that should be such a
fast calculation, I'm not sure why you would need a trigger cell.
In any case, entering "n" in cell A6 would not HALT recalculation,
trigger more calculations. You want to set the value to "n" when you save
the file, so that when you open the file, no calculations are being done.
Then, changing it to "y" is what triggers the recalculation.
On Sat, Feb 9, 2013 at 5:10 PM, bobc94595 conlonrc@comcast.
> Randy, I have entered in Cell b5 the following formula:
> =IF($A$6<
> "n" to halt the recalculation.
>
> Unfortunately, all the "last quote" prices which are triggered by Yahoo
> Code l1 are updating automatically when I open the file. Is there another
> solution, or am I placing the formula in the wrong place?
>
Sat Feb 9, 2013 6:04 pm (PST) . Posted by:
"Cesar Augusto Crivelli" cesarcrivelli
Randy,
I am trying to retreive from 4-Traders the projections for Sales, EBITDA, Net Income and EPS, for almost 150 companies
Sometimes the spreadsheet retrieves the data as it should be, for 2013-2016, but sometimes the data is wrong.... for example I opened in the browser (mozila) the following url - http://www.4-traders.com/mods_a/reuters/TableYears.php?&RepNo=A582A&CurrentYear=2015
This is the result
Annual results 2011 2012
Sales
Million BRL Released
Forecast
Spread 244 176
281 379
Operating income (EBITDA)
Million BRL Released
Forecast
Spread 62 246
53 439
Operating profit (EBIT)
Million BRL Released
Forecast
Spread 45 403
32 397
Pre-Tax Profit (EBT)
Million BRL Released
Forecast
Spread 45 403
27 753
Net income
Million BRL Released
Forecast
Spread 33 313
21 182
EPS
BRL Released
Forecast
Spread 2,55
1,62
Announcement Date 02/09/2012 02/04/2013
If i visit the url again I get
Annual results 2013 (e) 2014 (e) 2015 (e) 2016 (e)
Sales
Million BRL Released
Forecast
Spread
283 882
294 980
291 506
290 846
Operating income (EBITDA)
Million BRL Released
Forecast
Spread
72 827
80 346
87 789
97 930
Operating profit (EBIT)
Million BRL Released
Forecast
Spread
47 607
52 879
61 218
61 215
Pre-Tax Profit (EBT)
Million BRL Released
Forecast
Spread
46 584
51 227
47 283
48 300
Net income
Million BRL Released
Forecast
Spread
32 571
36 095
39 574
35 350
EPS
BRL Released
Forecast
Spread
2,65
2,79
3,12
2,71
Announcement Date
The second table is the right one... Do you have any idea why this is happening? Do I have to empty the temporary internet files each time the spreadsheet is opened?
Thanks
Cesar Crivelli
I am trying to retreive from 4-Traders the projections for Sales, EBITDA, Net Income and EPS, for almost 150 companies
Sometimes the spreadsheet retrieves the data as it should be, for 2013-2016, but sometimes the data is wrong.... for example I opened in the browser (mozila) the following url - http://www.4-
This is the result
Annual results 2011 2012
Sales
Million BRL Released
Forecast
Spread 244 176
281 379
Operating income (EBITDA)
Million BRL Released
Forecast
Spread 62 246
53 439
Operating profit (EBIT)
Million BRL Released
Forecast
Spread 45 403
32 397
Pre-Tax Profit (EBT)
Million BRL Released
Forecast
Spread 45 403
27 753
Net income
Million BRL Released
Forecast
Spread 33 313
21 182
EPS
BRL Released
Forecast
Spread 2,55
1,62
Announcement Date 02/09/2012 02/04/2013
If i visit the url again I get
Annual results 2013 (e) 2014 (e) 2015 (e) 2016 (e)
Sales
Million BRL Released
Forecast
Spread
283 882
294 980
291 506
290 846
Operating income (EBITDA)
Million BRL Released
Forecast
Spread
72 827
80 346
87 789
97 930
Operating profit (EBIT)
Million BRL Released
Forecast
Spread
47 607
52 879
61 218
61 215
Pre-Tax Profit (EBT)
Million BRL Released
Forecast
Spread
46 584
51 227
47 283
48 300
Net income
Million BRL Released
Forecast
Spread
32 571
36 095
39 574
35 350
EPS
BRL Released
Forecast
Spread
2,65
2,79
3,12
2,71
Announcement Date
The second table is the right one... Do you have any idea why this is happening? Do I have to empty the temporary internet files each time the spreadsheet is opened?
Thanks
Cesar Crivelli
Sat Feb 9, 2013 6:44 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Sorry. I have no answer for you. It could be the URL parameters work
differently than suspected.
Or, it could be the site limits you to only so many accesses to such data
within a certain time frame. I tried the "RepNo" source page below, and
originally got the correct data. But, after a few refreshes, all I get is
data through 2012.
And, if I now go to the source web page:
http://www.4-traders.com/PETROLEO-BRASILEIRO-PETRO-6496795/calendar/
...the "Next Year" link isn't even clickable. But if I wait a while, it
comes back.
So I'm pretty sure it is something the site is doing to restrict data
access.
Hmmm. Or, it is a weekend. Maybe they're updating data?
On Sat, Feb 9, 2013 at 7:04 PM, Cesar Augusto Crivelli <
cesarcrivelli@yahoo.com > wrote:
>
> Randy,
>
> I am trying to retreive from 4-Traders the projections for Sales, EBITDA,
> Net Income and EPS, for almost 150 companies
>
> Sometimes the spreadsheet retrieves the data as it should be, for
> 2013-2016, but sometimes the data is wrong.... for example I opened in the
> browser (mozila) the following url -
> http://www.4-traders.com/mods_a/reuters/TableYears.php?&RepNo=A582A&CurrentYear=2015
>
> The second table is the right one... Do you have any idea why this is
> happening? Do I have to empty the temporary internet files each time the
> spreadsheet is opened?
>
differently than suspected.
Or, it could be the site limits you to only so many accesses to such data
within a certain time frame. I tried the "RepNo" source page below, and
originally got the correct data. But, after a few refreshes, all I get is
data through 2012.
And, if I now go to the source web page:
http://www.4-
...the "Next Year" link isn't even clickable. But if I wait a while, it
comes back.
So I'm pretty sure it is something the site is doing to restrict data
access.
Hmmm. Or, it is a weekend. Maybe they're updating data?
On Sat, Feb 9, 2013 at 7:04 PM, Cesar Augusto Crivelli <
cesarcrivelli@
>
> Randy,
>
> I am trying to retreive from 4-Traders the projections for Sales, EBITDA,
> Net Income and EPS, for almost 150 companies
>
> Sometimes the spreadsheet retrieves the data as it should be, for
> 2013-2016, but sometimes the data is wrong.... for example I opened in the
> browser (mozila) the following url -
> http://www.4-
>
> The second table is the right one... Do you have any idea why this is
> happening? Do I have to empty the temporary internet files each time the
> spreadsheet is opened?
>
Sat Feb 9, 2013 10:31 pm (PST) . Posted by:
"Igor Rivin" igorrivin
I have just started using SMF, and it is great, but here is a question:
I need to have historical data for market indices for a few years, and when
I use smfPricesbyDates to get this, it takes forever to initialize (since
presumably it is making ten thousand or so http queries). Since this data
is not likely to change (this would be false for single stock data,
assuming it is adjusted for corporate actions), I wonder if there is a way
to only get new data...
A more minor question is this: for most indices, the Yahoo symbol works in
smfPricesbyDates (e.g., ^IXIC for the nasdaq data), but ^DJI does not work
for Dow Jones industrials (DJIA does). I am curious why this is...
Many thanks for a great package,
Igor
I need to have historical data for market indices for a few years, and when
I use smfPricesbyDates to get this, it takes forever to initialize (since
presumably it is making ten thousand or so http queries). Since this data
is not likely to change (this would be false for single stock data,
assuming it is adjusted for corporate actions), I wonder if there is a way
to only get new data...
A more minor question is this: for most indices, the Yahoo symbol works in
smfPricesbyDates (e.g., ^IXIC for the nasdaq data), but ^DJI does not work
for Dow Jones industrials (DJIA does). I am curious why this is...
Many thanks for a great package,
Igor
Sat Feb 9, 2013 10:56 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Second question first -- Dow Jones has enforced their licensing on the
quotes from their indexes, and will no longer allow Yahoo to provide them
in the CSV format. That's why they are no longer available to the
RCHGetYahooQuotes() or RCHGetYahooHistory() functions, which use Yahoo CSV
files.
====================================
Actually, smfPricesByDates() only does one Internet access per ticker
symbol and set of dates. It retrieves all of the historical data from
Yahoo, and then extracts only those requested dates. You're not doing one
function invocation per date, are you?
What I've sometimes done in such situations is create a "dummy" formula
row. For example, suppose I want to have ticker symbols starting in cell B5
and downward in the B column, with dates in cells C4:J4. Then I'll leave
cell B2 empty, and create this formula is cells C2:J2:
=IF($B2="","--",smfPricesByDates(B2,$C$4:$J$4))
Now, whenever I want to get quotes on something new, I insert a new row
below row 4, put my new symbol in the B column of that row, and copy cells
C2:J2 down to the C thru J columns of that row. Then I copy and paste
special as values for those values in the new row.
Then, I can add new things whenever I want. I can update any time I want.
But all the values stay there between closing and reopening of the workbook.
I used to use this technique quite a bit in some of my backtesting
routines, so I wouldn't need to recalculate everything every time I opened
the workbook. As long as you have that "dummy" row of formulas available to
copy, you don't lose any work you did on them.
On Sat, Feb 9, 2013 at 10:19 PM, Igor Rivin igor.rivin@gmail.com > wrote:
>
> I have just started using SMF, and it is great, but here is a question:
>
> I need to have historical data for market indices for a few years, and
> when I use smfPricesbyDates to get this, it takes forever to initialize
> (since presumably it is making ten thousand or so http queries). Since this
> data is not likely to change (this would be false for single stock data,
> assuming it is adjusted for corporate actions), I wonder if there is a way
> to only get new data...
>
> A more minor question is this: for most indices, the Yahoo symbol works in
> smfPricesbyDates (e.g., ^IXIC for the nasdaq data), but ^DJI does not work
> for Dow Jones industrials (DJIA does). I am curious why this is...
>
>
quotes from their indexes, and will no longer allow Yahoo to provide them
in the CSV format. That's why they are no longer available to the
RCHGetYahooQuotes(
files.
============
Actually, smfPricesByDates(
symbol and set of dates. It retrieves all of the historical data from
Yahoo, and then extracts only those requested dates. You're not doing one
function invocation per date, are you?
What I've sometimes done in such situations is create a "dummy" formula
row. For example, suppose I want to have ticker symbols starting in cell B5
and downward in the B column, with dates in cells C4:J4. Then I'll leave
cell B2 empty, and create this formula is cells C2:J2:
=IF($B2="
Now, whenever I want to get quotes on something new, I insert a new row
below row 4, put my new symbol in the B column of that row, and copy cells
C2:J2 down to the C thru J columns of that row. Then I copy and paste
special as values for those values in the new row.
Then, I can add new things whenever I want. I can update any time I want.
But all the values stay there between closing and reopening of the workbook.
I used to use this technique quite a bit in some of my backtesting
routines, so I wouldn't need to recalculate everything every time I opened
the workbook. As long as you have that "dummy" row of formulas available to
copy, you don't lose any work you did on them.
On Sat, Feb 9, 2013 at 10:19 PM, Igor Rivin igor.rivin@gmail.
>
> I have just started using SMF, and it is great, but here is a question:
>
> I need to have historical data for market indices for a few years, and
> when I use smfPricesbyDates to get this, it takes forever to initialize
> (since presumably it is making ten thousand or so http queries). Since this
> data is not likely to change (this would be false for single stock data,
> assuming it is adjusted for corporate actions), I wonder if there is a way
> to only get new data...
>
> A more minor question is this: for most indices, the Yahoo symbol works in
> smfPricesbyDates (e.g., ^IXIC for the nasdaq data), but ^DJI does not work
> for Dow Jones industrials (DJIA does). I am curious why this is...
>
>
Sun Feb 10, 2013 3:42 am (PST) . Posted by:
"Tze Wei," tzewei_79
Hi,
Oh sorry, I mistyped the question.
I meant:
Cell A1 = IBM
Cell B1 = =RCHGetTableCell("http://investing.money.msn.com/investments/stock-income-statement/?symbol=A1 ",1,"Total Revenue")
Actually I wanted to do something similar to "SMF-Template-Yahoo-Key-Statistics.xls" but using =RCHGetTableCell as only some data are available only in MSN but not in Yahoo.
Is that possible?
Regards,
Lewis
--- In smf_addin@yahoogroups.com , "Tze Wei," wrote:
>
> Hi,
>
> Is there a way to let =RCHGetElementNumber("IBM";, 941) reference the stock symbol to another cell so that we don't need to edit the symbols one by one for different data that we wanted to extract?
>
> Example
>
> Cell A1 = IBM
> Cell B1 = =RCHGetElementNumber("IBM";, 941)
>
> I tried the above, and excel always shows error.
> I'm using Excel 2007 with Win XP.
>
Oh sorry, I mistyped the question.
I meant:
Cell A1 = IBM
Cell B1 = =RCHGetTableCell(
Actually I wanted to do something similar to "SMF-Template-
Is that possible?
Regards,
Lewis
--- In smf_addin@yahoogrou
>
> Hi,
>
> Is there a way to let =RCHGetElementNumbe
>
> Example
>
> Cell A1 = IBM
> Cell B1 = =RCHGetElementNumbe
>
> I tried the above, and excel always shows error.
> I'm using Excel 2007 with Win XP.
>
Sun Feb 10, 2013 6:58 am (PST) . Posted by:
"Randy Harmelink" rharmelink
That also would just be a normal EXCEL operation, of concatenation:
=RCHGetTableCell("
http://investing.money.msn.com/investments/stock-income-statement/?symbol= "&A1,1,"Total
Revenue")
On Sun, Feb 10, 2013 at 4:42 AM, Tze Wei, tzewei_79@yahoo.com.sg > wrote:
>
> I meant:
>
> Cell A1 = IBM
> Cell B1 = =RCHGetTableCell("
> http://investing.money.msn.com/investments/stock-income-statement/?symbol=A1 ",1,"Total
> Revenue")
>
> Actually I wanted to do something similar to
> "SMF-Template-Yahoo-Key-Statistics.xls" but using =RCHGetTableCell as only
> some data are available only in MSN but not in Yahoo.
>
> Is that possible?
>
=RCHGetTableCell(
http://investing.
Revenue"
On Sun, Feb 10, 2013 at 4:42 AM, Tze Wei, tzewei_79@yahoo.
>
> I meant:
>
> Cell A1 = IBM
> Cell B1 = =RCHGetTableCell(
> http://investing.
> Revenue"
>
> Actually I wanted to do something similar to
> "SMF-Template-
> some data are available only in MSN but not in Yahoo.
>
> Is that possible?
>
Tidak ada komentar:
Posting Komentar