Kamis, 01 Agustus 2013

[smf_addin] Digest Number 2718[1 Attachment]

6 New Messages

Digest #2718
1a
Re: Problem with multiple long arrays by "Randy Harmelink" rharmelink
1c
Re: Problem with multiple long arrays by "Peter Urbani" purbani1
2b
Re: Problem RCHGetYahooHistory date result ... by "Randy Harmelink" rharmelink

Messages

Wed Jul 31, 2013 6:30 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Does it consistently happen on the same ticker symbols?

On Wed, Jul 31, 2013 at 6:22 PM, Craig <craig.sander@comcast.net> wrote:

>
> Thanks for the suggestion. I tried a first group of 200 without using the
> NOW() command and followed it by a group of 100 with the NOW() command.
> The last cell of the second group comes back blank and when I recalculate
> it stays blank.
>

Wed Jul 31, 2013 6:30 pm (PDT) . Posted by:

"Craig" c1sander

I should also have mentioned that when I fetch the values individually, rather than using an array, I do not get any blank cells. It's just slow.

Craig

--- In smf_addin@yahoogroups.com, "Craig" <craig.sander@...> wrote:
>
> Randy,
>
> Thanks for the suggestion. I tried a first group of 200 without using the NOW() command and followed it by a group of 100 with the NOW() command. The last cell of the second group comes back blank and when I recalculate it stays blank.
>
> Craig
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > Sorry, but I have absolutely no experience with getting that much data at
> > one time. I usually only get about 10-20 quotes. From time to time, I'll
> > get quotes of the S&P 500, but have had no issues there with three
> > RCHGetYahooQuotes() functions. But it's usually after hours too, which
> > probably makes a difference.
> >
> > Can you stagger the update? For example, instead of using
> > smfForceRecalculation or the NOW() trick to trigger the update of the
> > quotes, use a cell reference for the NOW() value, but put a value of 1 or 2
> > or 3 in that cell. Then, that set of 200 quotes will only update when that
> > cell value changes. You could have one cell for each set of 200 quotes.
> > Then change the "trigger" cells one by one, with maybe a few seconds in
> > between (you could even have VBA do it, just incrementing the values with a
> > timer in between).
> >
> > I don't know if that would make a difference or not.
> >
> > On Wed, Jul 31, 2013 at 8:50 AM, Craig <craig.sander@> wrote:
> >
> > > I have a long list of about 1000 different symbols. I am trying to use
> > > RCHGetYahooQuotes to fetch data (l1 for example) and am doing this using
> > > 200 element arrays stacked on top of each other. (I've tried 10 100
> > > element arrays and have the same problem.) This works fine for the top two
> > > groups, then I start getting blank cells. For this error (blank cells)to
> > > occur, I need to use different symbols. If I use the same group of 200
> > > symbols, repeated on top of each other in 5 groups, I get no blank cells.
> > >
> > > Any suggestions?
> > >
> >
>

Wed Jul 31, 2013 6:51 pm (PDT) . Posted by:

"Peter Urbani" purbani1

This is what I use

On Thu, Aug 1, 2013 at 1:22 PM, Craig <craig.sander@comcast.net> wrote:

> **
>
>
> Randy,
>
> Thanks for the suggestion. I tried a first group of 200 without using the
> NOW() command and followed it by a group of 100 with the NOW() command. The
> last cell of the second group comes back blank and when I recalculate it
> stays blank.
>
> Craig
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
> >
> > Sorry, but I have absolutely no experience with getting that much data at
> > one time. I usually only get about 10-20 quotes. From time to time, I'll
> > get quotes of the S&P 500, but have had no issues there with three
> > RCHGetYahooQuotes() functions. But it's usually after hours too, which
> > probably makes a difference.
> >
> > Can you stagger the update? For example, instead of using
> > smfForceRecalculation or the NOW() trick to trigger the update of the
> > quotes, use a cell reference for the NOW() value, but put a value of 1
> or 2
> > or 3 in that cell. Then, that set of 200 quotes will only update when
> that
> > cell value changes. You could have one cell for each set of 200 quotes.
> > Then change the "trigger" cells one by one, with maybe a few seconds in
> > between (you could even have VBA do it, just incrementing the values
> with a
> > timer in between).
> >
> > I don't know if that would make a difference or not.
> >
> > On Wed, Jul 31, 2013 at 8:50 AM, Craig <craig.sander@...> wrote:
> >
> > > I have a long list of about 1000 different symbols. I am trying to use
> > > RCHGetYahooQuotes to fetch data (l1 for example) and am doing this
> using
> > > 200 element arrays stacked on top of each other. (I've tried 10 100
> > > element arrays and have the same problem.) This works fine for the top
> two
> > > groups, then I start getting blank cells. For this error (blank
> cells)to
> > > occur, I need to use different symbols. If I use the same group of 200
> > > symbols, repeated on top of each other in 5 groups, I get no blank
> cells.
> > >
> > > Any suggestions?
> > >
> >
>
>
>

--

*Peter Urbani*

+64 21 0255 2816

LinkedIn Profile <http://nz.linkedin.com/in/peterurbani>

Skype peterurbani
Attachments with this message:
1 of 1 File(s)

Wed Jul 31, 2013 7:41 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The attachment has nothing to do with RCHGetYahooQuotes().

And I don't even know why you need to use VBA and looping to get the data
for that workbook...

On Wed, Jul 31, 2013 at 6:51 PM, Peter Urbani <peter.urbani@gmail.com>wrote:

> [Attachment(s) <#14037926c1fcebd3_TopText> from Peter Urbani included
> below]
>
> This is what I use
>

Wed Jul 31, 2013 7:47 pm (PDT) . Posted by:

"rob_gries" rob_gries

Thanks, I will try that.

Though I still find it inconsistent, that when downloading the Historical Prices for LAME4.SA (to continue with this example) into a csv spreadsheet, this error does not appear to happen for the data of the recent past (last few days or weeks, which disappear with the excel smf_addin).

From which source does RCHGetYahooHistory actually retrieve the data? Is there no way to simulate this retrieval in another way to identify if the problem is on Yahoo side or somewhere else... (black whole, NSA, etc.)?

Thanks again alot!
RG

--- In smf_addin@yahoogroups.com, "Kermit W. Prather" <kermitp@...> wrote:
>
>
> 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@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
> Of rob_gries
> Sent: Monday, July 29, 2013 11:56 AM
> To: smf_addin@yahoogroups.com
> 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@yahoogroups.com> smf_addin@yahoogroups.com,
> "Kermit W. Prather" < <mailto:kermitp@> 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: <mailto:smf_addin@yahoogroups.com> smf_addin@yahoogroups.com [
> <mailto:smf_addin@yahoogroups.com> mailto:smf_addin@yahoogroups.com] On
> > Behalf Of rob_gries
> > Sent: Wednesday, July 24, 2013 6:44 PM
> > To: <mailto:smf_addin@yahoogroups.com> 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>
> mailto:smf_addin-fullfeatured@yahoogroups.com>
> > <mailto:smf_addin-fullfeatured@yahoogroups.com>
> smf_addin-fullfeatured@yahoogroups.com
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
> (Yahoo! ID required)
>
> <mailto:smf_addin-fullfeatured@yahoogroups.com>
> smf_addin-fullfeatured@yahoogroups.com
>

Wed Jul 31, 2013 7:54 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The add-in is just parsing the CSV file provided by the "Download to
Spreadsheet" link on this web page:

http://finance.yahoo.com/q/hp?s=LAME4.SA

On Wed, Jul 31, 2013 at 7:47 PM, rob_gries <r.gries@tuhh.de> wrote:

>
> Though I still find it inconsistent, that when downloading the Historical
> Prices for LAME4.SA (to continue with this example) into a csv
> spreadsheet, this error does not appear to happen for the data of the
> recent past (last few days or weeks, which disappear with the excel
> smf_addin).
>
> From which source does RCHGetYahooHistory actually retrieve the data? Is
> there no way to simulate this retrieval in another way to identify if the
> problem is on Yahoo side or somewhere else... (black whole, NSA, etc.)?
>

Tidak ada komentar:

Posting Komentar