6 New Messages
Digest #2715
Messages
Mon Jul 29, 2013 8:56 am (PDT) . Posted by:
"rob_gries" rob_gries
Dear Prather,
this seemed to be a good reason, but trying it out, it did not solve the problem. I have increased the array a lot, such that I have some 2400 rows empty at the lower end of the table. Nevertheless, everyday the last date is pushed back to the past, now it is already back on the 24/05/2013, while it was on the 02/05/2013 last time before updating. ... very strange.
If you had any idea, I would be happy.
Robert
--- In smf_addin@yahoogroups.com , "Kermit W. Prather" <kermitp@...> wrote:
>
> I had what appears to be the same problem yesterday. Took me awhile to
> figure out the array was not large enoughto handle all the days I was
> attempting to retrieve. Excel truncates the number of dates to fit the
> array.
>
> 1. Select the array, starting in the upper left corner and down to the
> lower right corner for the new number of rows you need
> 2. Press F2
> 3. Then select Control, Shift, enter to create the larger array
>
> I hope that fixes your problem.
>
> -----Original Message-----
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
> Of rob_gries
> Sent: Wednesday, July 24, 2013 6:44 PM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] Problem RCHGetYahooHistory date result ...
>
>
> Dear all,
>
> I have a workbook organized in different sheets, every sheet represents a
> specific symbol.
>
> I am having a problem with some symbols, in some cases the complete period
> of historic data is retrieved and in some cases the recent past is not
> retrieved and the values start from some weeks ago only. The parameters
> though do not change from sheet to sheet.
>
> What might be the reason for this?
>
> Please see the images within the Photos section (I have created a specific
> Album for this), that should illustrate the formulas I am using and the
> wrong result they bring.
>
> The symbol PETR4.SA brings the right values and the screenshot is taken for
> LAME4.SA, which shows the wrong history.
>
> What shall I take care of?
>
> Thanks a lot for your ideas!
>
> RG
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
> (Yahoo! ID required)
>
> <mailto:smf_addin-fullfeatured@yahoogroups.com >
> smf_addin-fullfeatured@yahoogroups.com
>
this seemed to be a good reason, but trying it out, it did not solve the problem. I have increased the array a lot, such that I have some 2400 rows empty at the lower end of the table. Nevertheless, everyday the last date is pushed back to the past, now it is already back on the 24/05/2013, while it was on the 02/05/2013 last time before updating. ... very strange.
If you had any idea, I would be happy.
Robert
--- In smf_addin@yahoogrou
>
> I had what appears to be the same problem yesterday. Took me awhile to
> figure out the array was not large enoughto handle all the days I was
> attempting to retrieve. Excel truncates the number of dates to fit the
> array.
>
> 1. Select the array, starting in the upper left corner and down to the
> lower right corner for the new number of rows you need
> 2. Press F2
> 3. Then select Control, Shift, enter to create the larger array
>
> I hope that fixes your problem.
>
> -----Original Message-----
> From: smf_addin@yahoogrou
> Of rob_gries
> Sent: Wednesday, July 24, 2013 6:44 PM
> To: smf_addin@yahoogrou
> Subject: [smf_addin] Problem RCHGetYahooHistory date result ...
>
>
> Dear all,
>
> I have a workbook organized in different sheets, every sheet represents a
> specific symbol.
>
> I am having a problem with some symbols, in some cases the complete period
> of historic data is retrieved and in some cases the recent past is not
> retrieved and the values start from some weeks ago only. The parameters
> though do not change from sheet to sheet.
>
> What might be the reason for this?
>
> Please see the images within the Photos section (I have created a specific
> Album for this), that should illustrate the formulas I am using and the
> wrong result they bring.
>
> The symbol PETR4.SA brings the right values and the screenshot is taken for
> LAME4.SA, which shows the wrong history.
>
> What shall I take care of?
>
> Thanks a lot for your ideas!
>
> RG
>
>
>
>
> ------------
>
> Yahoo! Groups Links
>
>
> (Yahoo! ID required)
>
> <mailto:smf_addin-fullfeatu
> smf_addin-fullfeatu
>
Mon Jul 29, 2013 11:21 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
You will need to contact yahoo. It appears to be their problem.
I tried retrieving PETR4.SA 5/2/2013 to 1/1/2005 it retrieved all values
correctly
When I tried LAME.SA 5/2/2013 to 1/1/2005
It looks like it retrieved most correctly but failed on dates older than
8/27/2007
Date
Adj. Open
Adj. High
Adj. Low
Adj. Close
Volume
Adj Close
8/10/2007
955699.51
972337.46
932730.43
967214.05
2539400
967214.05
8/13/2007
978728.55
990243.09
955699.47
958579.98
1553100
958579.98
8/14/2007
975788.02
975788.02
892425.74
915394.81
2691800
915394.81
8/15/2007
907338.44
907338.44
857882.17
863583.18
2431200
863583.18
8/16/2007
823278.50
828866.99
731166.66
826159.01
5975300
826159.01
8/17/2007
817637.50
872217.17
783093.87
868128.95
4413000
868128.95
8/20/2007
869396.69
886552.23
855864.29
875270.23
1683400
875270.23
8/21/2007
904225.38
924606.50
858114.70
898014.28
3127000
898014.28
8/22/2007
920518.23
928349.62
906760.79
912521.81
3821500
912521.81
8/23/2007
921155.83
931515.17
911366.60
915394.81
3017600
915394.81
8/24/2007
912521.85
931515.22
896168.95
931057.64
2265800
931057.64
8/27/2007
921328.42
948730.78
913497.03
921155.89
2099000
921155.89
8/28/2007
9.22
9.49
8.90
9.07
1427500
9.07
8/29/2007
9.10
9.45
9.05
9.32
1803200
9.32
8/30/2007
9.33
9.33
8.93
9.07
3573400
9.07
8/31/2007
9.27
9.38
8.93
9.21
8311000
9.21
9/3/2007
9.35
9.61
9.22
9.59
2010500
9.59
9/4/2007
9.67
9.78
9.50
9.69
1985600
9.69
9/5/2007
9.58
9.64
9.27
9.50
2474400
9.50
Dates 8/28/2007 thru 5/2/2013 appear to be okay.
4/24/2013
17.43
17.66
17.32
17.58
1593100
17.58
4/25/2013
17.50
17.80
17.30
17.51
2531600
17.51
4/29/2013
17.32
17.50
16.99
17.15
1628100
17.15
4/30/2013
17.28
17.73
16.96
17.73
2086100
17.73
5/2/2013
17.53
17.80
17.12
17.19
2185700
17.19
-----Original Message-----
From: smf_addin@yahoogrou
Of rob_gries
Sent: Monday, July 29, 2013 11:56 AM
To: smf_addin@yahoogrou
Subject: [smf_addin] Re: Problem RCHGetYahooHistory date result ...
Dear Prather,
this seemed to be a good reason, but trying it out, it did not solve the
problem. I have increased the array a lot, such that I have some 2400 rows
empty at the lower end of the table. Nevertheless, everyday the last date is
pushed back to the past, now it is already back on the 24/05/2013, while it
was on the 02/05/2013 last time before updating. ... very strange.
If you had any idea, I would be happy.
Robert
--- In <mailto:smf_addin@yahoogrou
"Kermit W. Prather" < <mailto:kermitp@
>
> I had what appears to be the same problem yesterday. Took me awhile to
> figure out the array was not large enoughto handle all the days I was
> attempting to retrieve. Excel truncates the number of dates to fit the
> array.
>
> 1. Select the array, starting in the upper left corner and down to
> the lower right corner for the new number of rows you need 2. Press
> F2 3. Then select Control, Shift, enter to create the larger array
>
> I hope that fixes your problem.
>
> -----Original Message-----
> From: <mailto:smf_addin@yahoogrou
<mailto:smf_addin@yahoogrou
> Behalf Of rob_gries
> Sent: Wednesday, July 24, 2013 6:44 PM
> To: <mailto:smf_addin@yahoogrou
> Subject: [smf_addin] Problem RCHGetYahooHistory date result ...
>
>
> Dear all,
>
> I have a workbook organized in different sheets, every sheet
> represents a specific symbol.
>
> I am having a problem with some symbols, in some cases the complete
> period of historic data is retrieved and in some cases the recent past
> is not retrieved and the values start from some weeks ago only. The
> parameters though do not change from sheet to sheet.
>
> What might be the reason for this?
>
> Please see the images within the Photos section (I have created a
> specific Album for this), that should illustrate the formulas I am
> using and the wrong result they bring.
>
> The symbol PETR4.SA brings the right values and the screenshot is
> taken for LAME4.SA, which shows the wrong history.
>
> What shall I take care of?
>
> Thanks a lot for your ideas!
>
> RG
>
>
>
>
> ------------
>
> Yahoo! Groups Links
>
>
> (Yahoo! ID required)
>
> < <mailto:smf_addin-fullfeatu
mailto:smf_addin-fullfeatu
> <mailto:smf_addin-fullfeatu
smf_addin-fullfeatu
>
------------
Yahoo! Groups Links
(Yahoo! ID required)
<mailto:smf_addin-fullfeatu
smf_addin-fullfeatu
Mon Jul 29, 2013 5:55 pm (PDT) . Posted by:
"okse26_26" okse26_26
Good news and I hope it will stay this way. When I opened my spreadsheet today, I saw today's closing price. Wonderful! Now I feel relieved and can see what other data I can play with as a dividend investor.
Thank you, Randy.
--- In smf_addin@yahoogroups.com , "okse26_26" <okse26_26@...> wrote:
>
> > For example, to get the current price of ticker "MMM":
> >
> > =RCHGetYahooQuotes("MMM","l1")
> >
> > One advantage of the RCHGetYahooQuotes() function is that you can
> > array-enter it over a range and retrieve numerous data items on up to 200
> > stocks, with a single Internet access. So it would be MUCH faster than
> > using RCHGetElementNumber() to get the individual items on the 200 stocks,
> > because you would need to access AT LEAST 200 different web pages.
>
> Thank you, Randy, for a quick reply.
> No, I didn't Google for the IE part yet, I'll wait for tomorrow.
>
> What I did is I started over: Deleted my spreadsheet and SMF file and started over again. I did notice that I missed to close the Excel completely the 1st after adding Smf via add-ins menu (author of the article on the SA didn't mention it either). Anyway, this time I did. I'll wait until tomorrow and see if it will update the last price. If not, then I've definitely have a problem with the IE radio button :-(.
>
> BTW, these kind of instructions here http://finance.groups.yahoo.com/group/smf_addin/message/124 are super helpful for me. Here's the question though. So, if I find an element that's available via Yahoo vs. the same element found on the "RCH...Definitions"; file, would you advise to use Yahoo data instead e.g.MSN, because extractions will be much easier? Also, wouldn't M* data be more dependable than Yahoo or is it just a user's preference?
>
> Thank you again.
>
Thank you, Randy.
--- In smf_addin@yahoogrou
>
> > For example, to get the current price of ticker "MMM"
> >
> > =RCHGetYahooQuotes(
> >
> > One advantage of the RCHGetYahooQuotes(
> > array-enter it over a range and retrieve numerous data items on up to 200
> > stocks, with a single Internet access. So it would be MUCH faster than
> > using RCHGetElementNumber
> > because you would need to access AT LEAST 200 different web pages.
>
> Thank you, Randy, for a quick reply.
> No, I didn't Google for the IE part yet, I'll wait for tomorrow.
>
> What I did is I started over: Deleted my spreadsheet and SMF file and started over again. I did notice that I missed to close the Excel completely the 1st after adding Smf via add-ins menu (author of the article on the SA didn't mention it either). Anyway, this time I did. I'll wait until tomorrow and see if it will update the last price. If not, then I've definitely have a problem with the IE radio button :-(.
>
> BTW, these kind of instructions here http://finance.
>
> Thank you again.
>
Mon Jul 29, 2013 10:34 pm (PDT) . Posted by:
"ajtalukdar" ajtalukdar
Hi Randy,
When I try using the GuruFocus dashboard template, I get data in the the 'Per Share Data' and 'Ratios' rows.
However all rows below that from the 'Income Statement' onwards return an Error.
Can you please revisit the GuruFocus dashboard template in the RCHGetTableCell samples section of this forum and check whether you get the same?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> You shouldn't be receiving any quarterly data at all -- the template is only
> intended to get annual data. Possibly the company you tried only had 8 years
> of financial history, so it showed the quarterly data, which follows the
> annual data. The template just grabs the first 10 columns of data, assuming
> that they are 10 years of annual data.
>
> What ticker symbol was it?
>
> On Sat, Feb 5, 2011 at 6:42 PM, mchiangsd <mchiangsd@...> wrote:
>
> > The annual data retrieval from GuruFocus works just fine. I had a hard time
> > getting all of the quarterly data, however - two columns are missing when
> > extending the cells to the right.
> > Can you please help?
> >
>
When I try using the GuruFocus dashboard template, I get data in the the 'Per Share Data' and 'Ratios&#
However all rows below that from the 'Income Statement' onwards return an Error.
Can you please revisit the GuruFocus dashboard template in the RCHGetTableCell samples section of this forum and check whether you get the same?
--- In smf_addin@yahoogrou
>
> You shouldn'
> intended to get annual data. Possibly the company you tried only had 8 years
> of financial history, so it showed the quarterly data, which follows the
> annual data. The template just grabs the first 10 columns of data, assuming
> that they are 10 years of annual data.
>
> What ticker symbol was it?
>
> On Sat, Feb 5, 2011 at 6:42 PM, mchiangsd <mchiangsd@
>
> > The annual data retrieval from GuruFocus works just fine. I had a hard time
> > getting all of the quarterly data, however - two columns are missing when
> > extending the cells to the right.
> > Can you please help?
> >
>
Mon Jul 29, 2013 10:59 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, they've changed all of the financial statements data to be
dynamically displayed, so the data isn't in the source code of the web page
for the add-in to extract.
On Mon, Jul 29, 2013 at 10:34 PM, ajtalukdar <ajtalukdar@yahoo.com > wrote:
>
> When I try using the GuruFocus dashboard template, I get data in the the
> 'Per Share Data' and 'Ratios' rows.
>
> However all rows below that from the 'Income Statement' onwards return an
> Error.
>
> Can you please revisit the GuruFocus dashboard template in the
> RCHGetTableCell samples section of this forum and check whether you get the
> same?
>
dynamically displayed, so the data isn't in the source code of the web page
for the add-in to extract.
On Mon, Jul 29, 2013 at 10:34 PM, ajtalukdar <ajtalukdar@yahoo.
>
> When I try using the GuruFocus dashboard template, I get data in the the
> 'Per Share Data' and 'Ratios&#
>
> However all rows below that from the 'Income Statement' onwards return an
> Error.
>
> Can you please revisit the GuruFocus dashboard template in the
> RCHGetTableCell samples section of this forum and check whether you get the
> same?
>
Tue Jul 30, 2013 12:17 am (PDT) . Posted by:
"Gururaj Rao" gurujapan
Based on one of your templates below,
I tried to collect data from this URL:
http://www.screener.in/company/?q=500530
I thought I could pick up one, I could probably make some headway with the
other elements (including 10 year data given here but alas!
This is the source data for Market cap <p class='span4'>Market
Cap: <b><span
class="WebRupee">Rs.</span> 27806.90 Crores</b></p>
They have introduced a symbol for the Rupee which has thrown me off
completely.
Here's what I tried to write ignoring the symbol for rupees:
=smfConvertData(smfGetTagContent("http://www.screener.in/company/q=500530 ","'span4'=""Market
Cap:""")) <http://quotes.morningstar.com/stock/c-header?&t=MMM >
Which gave an "Error"
Can somebody give me a start? I'd like to make a template for this URL, and
pull in data.
Thanks in advance
Gururaj Rao
THIS IS WHAT I REFERRED TO:
>
> Market Cap 80.4 bil =smfConvertData(smfGetTagContent("
> http://quotes.morningstar.com/stock/c-header?&t=MMM
> ","span",0,"id=""MarketCap"""))
>
>
>
I tried to collect data from this URL:
http://www.screener
I thought I could pick up one, I could probably make some headway with the
other elements (including 10 year data given here but alas!
This is the source data for Market cap <p class='span4&#
Cap: <b><
class="
They have introduced a symbol for the Rupee which has thrown me off
completely.
Here's what I tried to write ignoring the symbol for rupees:
=smfConvertData(
Cap:""
Which gave an "Error"
Can somebody give me a start? I'd like to make a template for this URL, and
pull in data.
Thanks in advance
Gururaj Rao
THIS IS WHAT I REFERRED TO:
>
> Market Cap 80.4 bil =smfConvertData(
> http://quotes.
> ","
>
>
>
Tidak ada komentar:
Posting Komentar