Messages In This Digest (14 Messages)
- 1a.
- Replacing non-printing charactes returned from a RCHGetTableCell for From: Steven
- 1b.
- Re: Replacing non-printing charactes returned from a RCHGetTableCell From: Randy Harmelink
- 2a.
- Force Recalc Inconsistent From: thomas91112
- 2b.
- Re: Force Recalc Inconsistent From: Mike McQuaid
- 2c.
- Re: Force Recalc Inconsistent From: dguillett1
- 2d.
- Re: Force Recalc Inconsistent From: Randy Harmelink
- 2e.
- Re: Force Recalc Inconsistent From: dguillett1
- 3a.
- Ex Div Date in History? From: Pete A
- 3b.
- Re: Ex Div Date in History? From: Mike McQuaid
- 3c.
- Re: Ex Div Date in History? From: Randy Harmelink
- 4a.
- beginner's excel errors. :( From: upsquare78
- 4b.
- Re: beginner's excel errors. :( From: Randy Harmelink
- 5a.
- worksheet slow? From: V. Shankar
- 5b.
- Re: worksheet slow? [1 Attachment] From: Randy Harmelink
Messages
- 1a.
-
Replacing non-printing charactes returned from a RCHGetTableCell for
Posted by: "Steven" stevenletzer@yahoo.com stevenletzer
Fri Dec 30, 2011 9:01 am (PST)
Using this formula to capture data from a database: RCHGetTableCell("https://www. bonddesk. "&A5,3,">CUSIP"com/hrbfa/ servlet/issuedes c/issuedesc. htm?p_id_ type=i&p_ cusip= ,,,,1)
Returns this text: CLARKSTON MICH CMNTY SCHS GO REF SCHOOL BDSCallable 05/16@100 - OID - Material Events- NATL, insured
The BDSCallable has a non-printing character.
The viewable text on the website is:
Clarkston Mich Cmnty Schs Go Ref School Bds EMMA
Callable 05/16@100 - OID - Material Events - NATL, insured
How can I view the non-printing characters?
Can I adjust the formula to replace the non-printing characters with a space?
The website is non-public.
- 1b.
-
Re: Replacing non-printing charactes returned from a RCHGetTableCell
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Dec 30, 2011 12:45 pm (PST)
The non-printable character is probably either a line feed or a carriage
return (or both) -- which is why it goes to two lines on the web page. If
you tell EXCEL to wrap the contents of the cell, it will break the line at
that point. Most probably, the add-in found a "<br>" HTML tag there and
replaced it with the CHAR(10), to get the same results in EXCEL.
Otherwise, you can use the SUBSTITUTE() function to replace the CHAR(10) to
be whatever you want.
On Fri, Dec 30, 2011 at 10:01 AM, Steven <stevenletzer@yahoo.com > wrote:
> Using this formula to capture data from a database: RCHGetTableCell("
> https://www.bonddesk. com/hrbfa/ servlet/issuedes c/issuedesc. htm?p_id_ type=i&p_ cusip=
> "&A5,3,">CUSIP",,,,1)
>
> Returns this text: CLARKSTON MICH CMNTY SCHS GO REF SCHOOL BDSCallable
> 05/16@100 - OID - Material Events- NATL, insured
>
> The BDSCallable has a non-printing character.
>
> The viewable text on the website is:
> Clarkston Mich Cmnty Schs Go Ref School Bds EMMA
> Callable 05/16@100 - OID - Material Events - NATL, insured
>
> How can I view the non-printing characters?
> Can I adjust the formula to replace the non-printing characters with a
> space?
>
> The website is non-public.
>
- 2a.
-
Force Recalc Inconsistent
Posted by: "thomas91112" thomas91112@yahoo.com thomas91112
Fri Dec 30, 2011 9:49 am (PST)
Am pulling down historical and latest values through GetYahooHistory. Force Recalc has been working fine for many months and then today when initiated not all data fields are populated (in particular the last data items).
For example, one time SPY will be updated through 12/29 but IWM will be blank. Then after I hit Recalc again, IWM will be filled in and XLU will go blank. No matter how many times I hit Recalc, some fields will go blank and others will populate but only for the latest values - other historical values all appear. Any ideas as to what is wrong or how to correct - it hasn't done this before and I would run this daily?
- 2b.
-
Re: Force Recalc Inconsistent
Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802
Fri Dec 30, 2011 10:02 am (PST)
Sounds like the Yahoo servers are mis-behaving again. A few months ago we
had chronic problems with obsolete quotes coming back. You'd retrieve a set
of quotes and some would be today's but some were from a previous day.
There seemed to be no rhyme or reason but after a week or so it resolved on
its own.
You could report it to Yahoo if you could recreate it on their website. Go
to the historical section and download to spreadsheet. It was hard to
recreate a few months ago so you might not be able to now either.
_____
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of thomas91112
Sent: Friday, December 30, 2011 12:49 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Force Recalc Inconsistent
Am pulling down historical and latest values through GetYahooHistory. Force
Recalc has been working fine for many months and then today when initiated
not all data fields are populated (in particular the last data items).
For example, one time SPY will be updated through 12/29 but IWM will be
blank. Then after I hit Recalc again, IWM will be filled in and XLU will go
blank. No matter how many times I hit Recalc, some fields will go blank and
others will populate but only for the latest values - other historical
values all appear. Any ideas as to what is wrong or how to correct - it
hasn't done this before and I would run this daily?
- 2c.
-
Re: Force Recalc Inconsistent
Posted by: "dguillett1" dguillett1@gmail.com donaldb36
Fri Dec 30, 2011 12:42 pm (PST)
I haven't tested or have any knowledge of the current situation. However, the previous problem was due to one of the servers stuck on a particular day. If you happened to connect to THAT server, you would get quotes for that day. Took them awhile to fix....
Don Guillett
SalesAid Software
dguillett1@gmail.com
From: Mike McQuaid
Sent: Friday, December 30, 2011 12:03 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] Force Recalc Inconsistent
Sounds like the Yahoo servers are mis-behaving again. A few months ago we had chronic problems with obsolete quotes coming back. You'd retrieve a set of quotes and some would be today's but some were from a previous day. There seemed to be no rhyme or reason but after a week or so it resolved on its own.
You could report it to Yahoo if you could recreate it on their website. Go to the historical section and download to spreadsheet. It was hard to recreate a few months ago so you might not be able to now either.
--------------------- --------- --------- --------- --------- -
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of thomas91112
Sent: Friday, December 30, 2011 12:49 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Force Recalc Inconsistent
Am pulling down historical and latest values through GetYahooHistory. Force Recalc has been working fine for many months and then today when initiated not all data fields are populated (in particular the last data items).
For example, one time SPY will be updated through 12/29 but IWM will be blank. Then after I hit Recalc again, IWM will be filled in and XLU will go blank. No matter how many times I hit Recalc, some fields will go blank and others will populate but only for the latest values - other historical values all appear. Any ideas as to what is wrong or how to correct - it hasn't done this before and I would run this daily?
- 2d.
-
Re: Force Recalc Inconsistent
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Dec 30, 2011 12:49 pm (PST)
My first suspicion would be that one (or more) Yahoo servers didn't get
updates propagated to them last night when Yahoo did their updates of the
historical quotes. So the results would depend on which server is giving
you the information.
I just went to the historical quotes web page for IWM in my browser and hit
F5 about 8 times. One of them showed the most recent date of history as
12/28. So I think that confirms that it is a Yahoo issue and not an add-in
issue.
On Fri, Dec 30, 2011 at 10:49 AM, thomas91112 <thomas91112@yahoo.com > wrote:
> Am pulling down historical and latest values through GetYahooHistory.
> Force Recalc has been working fine for many months and then today when
> initiated not all data fields are populated (in particular the last data
> items).
> For example, one time SPY will be updated through 12/29 but IWM will be
> blank. Then after I hit Recalc again, IWM will be filled in and XLU will
> go blank. No matter how many times I hit Recalc, some fields will go blank
> and others will populate but only for the latest values - other historical
> values all appear. Any ideas as to what is wrong or how to correct - it
> hasn't done this before and I would run this daily?
>
- 2e.
-
Re: Force Recalc Inconsistent
Posted by: "dguillett1" dguillett1@gmail.com donaldb36
Fri Dec 30, 2011 1:28 pm (PST)
I just tested that symbol using my .csv version and got 12/28 sometimes and 12/29 others. So, Yahoo,,,
Don Guillett
SalesAid Software
dguillett1@gmail.com
From: Randy Harmelink
Sent: Friday, December 30, 2011 2:49 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Force Recalc Inconsistent
My first suspicion would be that one (or more) Yahoo servers didn't get updates propagated to them last night when Yahoo did their updates of the historical quotes. So the results would depend on which server is giving you the information.
I just went to the historical quotes web page for IWM in my browser and hit F5 about 8 times. One of them showed the most recent date of history as 12/28. So I think that confirms that it is a Yahoo issue and not an add-in issue.
On Fri, Dec 30, 2011 at 10:49 AM, thomas91112 <thomas91112@yahoo.com > wrote:
Am pulling down historical and latest values through GetYahooHistory. Force Recalc has been working fine for many months and then today when initiated not all data fields are populated (in particular the last data items).
For example, one time SPY will be updated through 12/29 but IWM will be blank. Then after I hit Recalc again, IWM will be filled in and XLU will go blank. No matter how many times I hit Recalc, some fields will go blank and others will populate but only for the latest values - other historical values all appear. Any ideas as to what is wrong or how to correct - it hasn't done this before and I would run this daily?
- 3a.
-
Ex Div Date in History?
Posted by: "Pete A" optionzz@gmail.com option2z
Fri Dec 30, 2011 6:38 pm (PST)
Hi Randy, happy new year!
Is there an easy way to add the ex div date when using the "v" option in RCHGetYahooHistory()? I recall that you somehow got a table that has the div history in it. My simulation of the TtP-S operation needs to have dividends added to it for more realizm. Ideas appreciated. Thanks!
Pete A
- 3b.
-
Re: Ex Div Date in History?
Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802
Fri Dec 30, 2011 7:14 pm (PST)
The "v" option does return date and amount. The date was the ex-div last
time I checked.
_____
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of Pete A
Sent: Friday, December 30, 2011 9:38 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Ex Div Date in History?
Hi Randy, happy new year!
Is there an easy way to add the ex div date when using the "v" option in
RCHGetYahooHistory()? I recall that you somehow got a table that has the div
history in it. My simulation of the TtP-S operation needs to have dividends
added to it for more realizm. Ideas appreciated. Thanks!
Pete A
- 3c.
-
Re: Ex Div Date in History?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Dec 30, 2011 7:17 pm (PST)
The two columns being returned are the ex-dividend date and the amount of
the dividend...?
On Fri, Dec 30, 2011 at 7:37 PM, Pete A <optionzz@gmail.com > wrote:
>
> Is there an easy way to add the ex div date when using the "v" option in
> RCHGetYahooHistory()? I recall that you somehow got a table that has the
> div history in it. My simulation of the TtP-S operation needs to have
> dividends added to it for more realizm. Ideas appreciated. Thanks!
>
- 4a.
-
beginner's excel errors. :(
Posted by: "upsquare78" dwvancouver@yahoo.com dwvancouver
Fri Dec 30, 2011 11:37 pm (PST)
when I'm running modUtilities and some other mods I get a compile error: user-defined type not defined at Dim oHTML As New HTMLDocument...
As well how would I get data from http://online.wsj.com/mdc/ something I got no-longer works.public/page/ 2_3022-mfsctrsca n-moneyflow. html?
[vista, excel 2007]
- 4b.
-
Re: beginner's excel errors. :(
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Dec 30, 2011 11:49 pm (PST)
You probably need the HTML Object library as a reference.
I don't know what you're after specifically, but this basic form of the
function retrieves data for me:
=RCHGetTableCell("
http://online.wsj.com/mdc/ ",1,">Basicpublic/page/ 2_3022-mfsctrsca n-moneyflow. html
Materials")
On Sat, Dec 31, 2011 at 12:37 AM, upsquare78 <dwvancouver@yahoo.com > wrote:
> when I'm running modUtilities and some other mods I get a compile error:
> user-defined type not defined at Dim oHTML As New HTMLDocument...
>
> As well how would I get data from
> http://online.wsj.com/mdc/ public/page/ 2_3022-mfsctrsca n-moneyflow. html?
> something I got no-longer works.
>
> [vista, excel 2007]
>
- 5a.
-
worksheet slow?
Posted by: "V. Shankar" tarakayan@yahoo.com tarakayan
Sat Dec 31, 2011 1:16 am (PST)
[Attachment(s) from V. Shankar included below]
I have combined a few functions in the same sheet. It works fine, but is it normal that sheet takes more time to update?Attachment(s) from V. Shankar
1 of 1 File(s)
- 5b.
-
Re: worksheet slow? [1 Attachment]
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Dec 31, 2011 1:54 am (PST)
There are two things I would do to speed it up:
1. Array-enter all of the RCHGetYahooQuotes() cells as a single range
(or as three ranges), so that it only needs to access the Internet once (or
three times) for all of the data. Right now, as individual cell entries, it
needs to go to the Internet over 200 times for the data.
2. Change all of your AdvFN data retrievals into an
smfUpdateDownloadTable process. For any given company, you only need to
update the data once per quarter, not every time you open the workbook. But
that's another 100+ web pages to access, and AdvFN in not a fast site to
access. Another option would be to go to another (faster) site that may
have all the necessary data for each ticker symbol on one web page?
On Sat, Dec 31, 2011 at 2:16 AM, V. Shankar <tarakayan@yahoo.com > wrote:
>
> I have combined a few functions in the same sheet. It works fine, but is
> it normal that sheet takes more time to update?
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar