Rabu, 27 Juli 2011

[smf_addin] Digest Number 1899

Messages In This Digest (22 Messages)

Messages

1a.

I can't extract html table, please help

Posted by: "dkarbayev" dkarbayev@yahoo.com   dkarbayev

Tue Jul 26, 2011 3:52 am (PDT)



Hi,

I've been trying to extract an html table from http://trust.ru/investment/analitika/interactive/tn/cnt/kazakh_info1.html using the following formulas:

1. =RCHGetHTMLTable("http://trust.ru/investment/analitika/interactive/tn/cnt/kazakh_info1.html";"Bond Name";-1;"";1)

2. =RCHGetTableCell("http://trust.ru/investment/analitika/interactive/tn/cnt/kazakh_info1.html";1;"Bond Name";;;;1)

I've tried changing almost every parameter in these formulas, but in vain. I really don't get where I'm wrong. I desperately need help!

Dias

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
1b.

Re: I can't extract html table, please help

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Jul 26, 2011 11:12 am (PDT)



Sorry, but they don't code the ending HTML tags for the table rows and cells
on the web page, so the RCHGetHTMLTable() function won't work. The only
function I have that account for missing table tags is the
smfGetTagContent() function. For example:

=smfGetTagContent("
http://trust.ru/investment/analitika/interactive/tn/cnt/kazakh_info1.html
","td",row)

...varying "row" from 57 to 81 would get you all the items in the first row
of the table.

On Tue, Jul 26, 2011 at 3:24 AM, dkarbayev <dkarbayev@yahoo.com> wrote:

>
> I've been trying to extract an html table from
> http://trust.ru/investment/analitika/interactive/tn/cnt/kazakh_info1.htmlusing the following formulas:
>
> 1. =RCHGetHTMLTable("
> http://trust.ru/investment/analitika/interactive/tn/cnt/kazakh_info1.html";"Bond
> Name";-1;"";1)
>
> 2. =RCHGetTableCell("
> http://trust.ru/investment/analitika/interactive/tn/cnt/kazakh_info1.html";1;"Bond
> Name";;;;1)
>
> I've tried changing almost every parameter in these formulas, but in vain.
> I really don't get where I'm wrong. I desperately need help!
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
1c.

Re: I can't extract html table, please help

Posted by: "dkarbayev" dkarbayev@yahoo.com   dkarbayev

Tue Jul 26, 2011 8:19 pm (PDT)




Now I understand how this works better. Thank you very much!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Sorry, but they don't code the ending HTML tags for the table rows and cells
> on the web page, so the RCHGetHTMLTable() function won't work. The only
> function I have that account for missing table tags is the
> smfGetTagContent() function. For example:
>
> =smfGetTagContent("
> http://trust.ru/investment/analitika/interactive/tn/cnt/kazakh_info1.html
> ","td",row)
>
> ...varying "row" from 57 to 81 would get you all the items in the first row
> of the table.
>
> On Tue, Jul 26, 2011 at 3:24 AM, dkarbayev <dkarbayev@...> wrote:
>
> >
> > I've been trying to extract an html table from
> > http://trust.ru/investment/analitika/interactive/tn/cnt/kazakh_info1.htmlusing the following formulas:
> >
> > 1. =RCHGetHTMLTable("
> > http://trust.ru/investment/analitika/interactive/tn/cnt/kazakh_info1.html";"Bond
> > Name";-1;"";1)
> >
> > 2. =RCHGetTableCell("
> > http://trust.ru/investment/analitika/interactive/tn/cnt/kazakh_info1.html";1;"Bond
> > Name";;;;1)
> >
> > I've tried changing almost every parameter in these formulas, but in vain.
> > I really don't get where I'm wrong. I desperately need help!
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
2a.

breakout feed into excel

Posted by: "fffund" lukas.speiser@gmail.com   fffund

Tue Jul 26, 2011 5:45 am (PDT)



Hi, thanks for the great add-in. i'm trying to build a breakout system but can't seem to find the 55 day and 20 day highs/lows anywhere on the net to feed directly into excel. do you know if these are available somewhere?

thanks
L.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2b.

Re: breakout feed into excel

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Jul 26, 2011 11:20 am (PDT)



I think you'd need to compute them yourselves from data retrieved using
RCHGetYahooHistory().

Or use an online screener like StockScreen123.com or StockFetcher.com.

On Tue, Jul 26, 2011 at 5:37 AM, fffund <lukas.speiser@gmail.com> wrote:

> Hi, thanks for the great add-in. i'm trying to build a breakout system but
> can't seem to find the 55 day and 20 day highs/lows anywhere on the net to
> feed directly into excel. do you know if these are available somewhere?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3a.

Re: RCHGetTable Cell Question

Posted by: "GaryFera" gfera@shaw.ca   GaryFera

Tue Jul 26, 2011 6:35 am (PDT)



Randy, I am okay to use either of your suggestions (text or color) but I cannot figure out how to extract that information from what SMF returns in the data. Any advice would be welcomed.

Gary

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> In similar situations, I've looked for the text of the actual image of the
> arrow, then used that to determine if it was positive or negative. Or you
> can look at the font color on the change amount, since they usually use red
> or green.
>
> On Mon, Jul 25, 2011 at 6:30 AM, GaryFera <gfera@...> wrote:
>
> > Randy, one of the available views on Finance.Yahoo.com is the Real-Time
> > view an example of which is shown below.
> >
> > The "change" data contains an arrow indicating if the security is up or
> > down in price. But this arrow is a small image and when I use the
> > RCHGetTableCell function to retrieve the data from the web site I do get the
> > dollar value of the change but not the small image. So I cannot tell from
> > the inquiry if the security has gone up or down because that particular
> > Yahoo view does not provide the previous close price.
> >
> > Do you have any suggestions that would allow me to determine the direction
> > of the change? Thanks.
> >
> > Gary
> >
> > Symbol Last Trade Change Related Info
> > AA 9:12AM EDT 15.60 0.23 1.45% Chart, Message, Profile, more...
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3b.

Re: RCHGetTable Cell Question

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Jul 26, 2011 11:51 am (PDT)



How about a simpler solution -- use RCHGetYahooQuotes() to retrieve the
prior day close of all of your ticker symbols, then compute the $ change and
% change yourself?

On Tue, Jul 26, 2011 at 6:35 AM, GaryFera <gfera@shaw.ca> wrote:

> Randy, I am okay to use either of your suggestions (text or color) but I
> cannot figure out how to extract that information from what SMF returns in
> the data. Any advice would be welcomed.
>
> Gary
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
> >
> > In similar situations, I've looked for the text of the actual image of
> the
> > arrow, then used that to determine if it was positive or negative. Or you
> > can look at the font color on the change amount, since they usually use
> red
> > or green.
> >
> > On Mon, Jul 25, 2011 at 6:30 AM, GaryFera <gfera@...> wrote:
> >
> > > Randy, one of the available views on Finance.Yahoo.com is the
> Real-Time
> > > view an example of which is shown below.
> > >
> > > The "change" data contains an arrow indicating if the security is up
> or
> > > down in price. But this arrow is a small image and when I use the
> > > RCHGetTableCell function to retrieve the data from the web site I do
> get the
> > > dollar value of the change but not the small image. So I cannot tell
> from
> > > the inquiry if the security has gone up or down because that particular
> > > Yahoo view does not provide the previous close price.
> > >
> > > Do you have any suggestions that would allow me to determine the
> direction
> > > of the change? Thanks.
> > >
> > > Gary
> > >
> > > Symbol Last Trade Change Related Info
> > > AA 9:12AM EDT 15.60 0.23 1.45% Chart, Message, Profile, more...
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
4a.

barrons data

Posted by: "Bartjan Van Hulten" vanhulten@yahoo.com   vanhulten

Tue Jul 26, 2011 6:52 am (PDT)



Hi Randy,
Thanks for the help on retrieving bloomberg data. I have been able to pull most of the data out. I have also found a way, using the bloomberg ticker, to find the unique page on Barrons, where you can find more data (sentiment, more estimates, ratings, longer, more detailed financial history, and historical stock quotes). What you need is (where $c$4=BB ticker)

=LEFT($C$4,FIND(":",$C$4,1)-1) >> which gives you the BB identifier,

=smfStrExtr(smfGetTagContent("http://investing.businessweek.com/research/stocks/snapshot/snapshot.asp?ticker="&$C$2,"h2",1,"name=""employees"""),"country=","""")
>>> which gives you the country identifier where the stock is listed.

Now with barrons data, i have had 2 small problems where i wonder if you had a smart solution for this?

1) =smfGetTagContent("http://quotes.barrons.com/CH/GALN/financials/annual/income-statement","td",3,"Unusual Expense"). Here the number is lower than 1 million (if you replace the 3 with 1, you will get a number). I wonder if there is some way, or tag, to get the actual number out (on the page source code the numbers are all listed at the final line.
2)
=smfGetTagContent("http://quotes.barrons.com/US/PFE/financials/annual/income-statement","td",3,"Income Tax - Deferred Domestic"). Here the number is negative and it cant properly discern between that and positive number (replace the 3 with 5 and you will see).

Wonder if you had any thoughts on this? Happy to send you the result when i have it done. Cheers

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4b.

Re: barrons data

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Jul 26, 2011 11:46 am (PDT)



Typically, I only use the smfGetTagContent() function when RCHGetTableCell()
will not work -- RCHGetTableCell() does additional processing in conversion
of data, while smfGetTagContent() just gets you the raw data, leaving you to
interpret the results. For example, although RCHGetTableCell() does get the
raw data of the table cell, it also then removes all internal HTML tagged
data -- which is what is causing both of your problems. If you use
smfGetTagContent(), you'll need to manually handle such exceptions.

For RCHGetTableCell(), the two functions would just be:

=RCHGetTableCell("
http://quotes.barrons.com/CH/GALN/financials/annual/income-statement",3,"Unusual
Expense")

=RCHGetTableCell("
http://quotes.barrons.com/US/PFE/financials/annual/income-statement",3,"Income
Tax - Deferred Domestic")

On Tue, Jul 26, 2011 at 6:51 AM, Bartjan Van Hulten <vanhulten@yahoo.com>wrote:

>
> Now with barrons data, i have had 2 small problems where i wonder if you
> had a smart solution for this?
>
> 1) =smfGetTagContent("
> http://quotes.barrons.com/CH/GALN/financials/annual/income-statement","td",3,"Unusual
> Expense"). Here the number is lower than 1 million (if you replace the 3
> with 1, you will get a number). I wonder if there is some way, or tag, to
> get the actual number out (on the page source code the numbers are all
> listed at the final line.
> 2)
> =smfGetTagContent("
> http://quotes.barrons.com/US/PFE/financials/annual/income-statement","td",3,"Income
> Tax - Deferred Domestic"). Here the number is negative and it cant properly
> discern between that and positive number (replace the 3 with 5 and you will
> see).
>
> Wonder if you had any thoughts on this? Happy to send you the result when i
> have it done. Cheers
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
5a.

Options Greeks Data

Posted by: "GaryFera" gfera@shaw.ca   GaryFera

Tue Jul 26, 2011 8:25 am (PDT)



Does anyone frequently download options Greeks data? Any suggestions would be appreciated.

Gary

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
5b.

Re: Options Greeks Data

Posted by: "Kermit W. Prather" kermitp@tampabay.rr.com   kermitpra

Tue Jul 26, 2011 10:01 am (PDT)



If you are looking for option data to download, you should checkout
Valueline. They provide daily updates on almost every optionable stock.
Things have change since I last worked with it. They also provide several
spreadsheets to help you pick positions. I think it is the best kept secret
in the options world. I told Lawrence that back in 2008 and they still
haven't expanded their marketing.

The cost is $149/yr it is run by my friend Lawrence Cavanagh. Lawrence was a
guest speaker on my 2008 Seminar at Sea

Kermit

This is from the last weekly newsletter. They come out every Thursday.

Welcome Value Line Research Center Subscribers: Did you know that as a
subscriber to the Value Line Research Center, that you have full access to
The Value Line Daily Options Survey? To read up on how to use this useful
and exciting product, you can visit our Reports Archive, which includes both
our guidebooks and our past Weekly Strategist reports.
http://www3.valueline.com/secure/options/reports/listfiles.aspx?library=opti
ons_reports

Also, you can address any questions that you might have to
vloptions@valueline.com.

If you would like to subscribe to The Value Line Daily Options Survey or
would like to know more about our product, go to
http://www.valueline.com/Products/Product_Detail.aspx?id=7063

Lawrence D. Cavanagh
vloptions@valueline.com

-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of GaryFera
Sent: Tuesday, July 26, 2011 11:25 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Options Greeks Data

Does anyone frequently download options Greeks data? Any suggestions would
be appreciated.

Gary

------------------------------------

Yahoo! Groups Links

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
6a.

Austrian Stocks

Posted by: "jcarlosd" jcdelrio@procesando.com   jcarlosd

Tue Jul 26, 2011 9:56 am (PDT)



I am trying to extract data from Austrian Stock Market. The address I use is http://kurse.wienerborse.at/teledata_php/prices/dispatch_list.php?LANG=en&TYPE=ATX

I am trying with function RCHGetHTMLTable, passing that URL and ">Name" as the beginning of the table with 12 columns. However, I do not get the results, since it gets in an infinite loop.

Could anybody please help me with this extraction?

I appreciate your contribution

J. Carlos

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
6b.

Re: Austrian Stocks

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Jul 26, 2011 11:30 am (PDT)



There's some funky coding going on there -- they've got table rows coded
within table rows, which is not valid HTML. So I'd suggest using
RCHGetTableCell() instead:

=RCHGetTableCell(URL,column,">Name",,,,row)

...varying "column" from 1 to 13 and "row" as 1, 3, 5, ..., so that you can
skip those extra table rows they have coded.

On Tue, Jul 26, 2011 at 9:56 AM, jcarlosd <jcdelrio@procesando.com> wrote:

> I am trying to extract data from Austrian Stock Market. The address I use
> is
> http://kurse.wienerborse.at/teledata_php/prices/dispatch_list.php?LANG=en&TYPE=ATX
>
> I am trying with function RCHGetHTMLTable, passing that URL and ">Name" as
> the beginning of the table with 12 columns. However, I do not get the
> results, since it gets in an infinite loop.
>
> Could anybody please help me with this extraction?
>
> I appreciate your contribution
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
6c.

Re: Austrian Stocks

Posted by: "jcarlosd" jcdelrio@procesando.com   jcarlosd

Wed Jul 27, 2011 12:16 am (PDT)



Ok, I see. I created a loop (I'm working with VBA) the way you said and got the data without further problems

Thanks a lot

JC

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> There's some funky coding going on there -- they've got table rows coded
> within table rows, which is not valid HTML. So I'd suggest using
> RCHGetTableCell() instead:
>
> =RCHGetTableCell(URL,column,">Name",,,,row)
>
> ...varying "column" from 1 to 13 and "row" as 1, 3, 5, ..., so that you can
> skip those extra table rows they have coded.
>
> On Tue, Jul 26, 2011 at 9:56 AM, jcarlosd <jcdelrio@...> wrote:
>
> > I am trying to extract data from Austrian Stock Market. The address I use
> > is
> > http://kurse.wienerborse.at/teledata_php/prices/dispatch_list.php?LANG=en&TYPE=ATX
> >
> > I am trying with function RCHGetHTMLTable, passing that URL and ">Name" as
> > the beginning of the table with 12 columns. However, I do not get the
> > results, since it gets in an infinite loop.
> >
> > Could anybody please help me with this extraction?
> >
> > I appreciate your contribution
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
7a.

MSN Company Description Returns Bad Characters Whenever Apostrophe i

Posted by: "lundyfinancial" lundyfinancial@yahoo.com   lundyfinancial

Tue Jul 26, 2011 1:56 pm (PDT)



Hi,

I am having an issue with =RCHGetElementNumber(Ticker, 1) where the function incorrectly returns the text for any company description that has an apostrophe in it. In place of the apostrophe it returns a square box with a question mark inside it. This becomes quite an issue for me as I am retrieving the data from an outside program which goes wonky when it runs into this unknown character.

Any idea's how I can get the company description properly, or a way to remove this character automatically when the string is retrieved?

Thank You

Here is a cut and paste of the returned string in excel. You can see instances towards the end. (box doesn't show question mark here but does if i copy it into other editors)
==============
Las Vegas Sands Corp. (LVSC) owns and operates The Venetian Resort Hotel Casino (The Venetian Las Vegas), The Palazzo Resort Hotel Casino (The Palazzo) and The Sands Expo and Convention Center (the Sands Expo Center) in Las Vegas, Nevada, and the Sands Macao, The Venetian Macao Resort Hotel (The Venetian Macao), the Four Seasons Hotel Macao, Cotai Strip (the Four Seasons Hotel Macao, which is managed by Four Seasons Hotels Inc.) and the Plaza Casino (together with the Four Seasons Hotel Macao, the Four Seasons Macao) in the Macau Special Administrative Region (Macau) of the People&#65535;s Republic of China (China). Its segments include The Venetian Las Vegas, which includes the Sands Expo Center; The Palazzo; Sands Bethlehem; Sands Macao; The Venetian Macao; Four Seasons Macao; Other Asia (comprised primarily of the Company&#65535;s ferry operations and various other operations that are ancillary to the Company&#65535;s properties in Macau), and Marina Bay Sands.
==============

I am using Excel 2010 with Windows 7. Have the latest definition files for SMF Addin.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
7b.

Re: MSN Company Description Returns Bad Characters Whenever Apostrop

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Jul 26, 2011 2:06 pm (PDT)



Just use a SUBSTITUTE() function around it and replace the HTML encoded
characters with apostrophes. I can't give you an exact formula because it
has unprintable characters and will vary by font.

On Tue, Jul 26, 2011 at 12:23 PM, lundyfinancial
<lundyfinancial@yahoo.com>wrote:

>
> I am having an issue with =RCHGetElementNumber(Ticker, 1) where the
> function incorrectly returns the text for any company description that has
> an apostrophe in it. In place of the apostrophe it returns a square box
> with a question mark inside it. This becomes quite an issue for me as I am
> retrieving the data from an outside program which goes wonky when it runs
> into this unknown character.
>
> Any idea's how I can get the company description properly, or a way to
> remove this character automatically when the string is retrieved?
>
> Thank You
>
>
> Here is a cut and paste of the returned string in excel. You can see
> instances towards the end. (box doesn't show question mark here but does if
> i copy it into other editors)
> ==============
> Las Vegas Sands Corp. (LVSC) owns and operates The Venetian Resort Hotel
> Casino (The Venetian Las Vegas), The Palazzo Resort Hotel Casino (The
> Palazzo) and The Sands Expo and Convention Center (the Sands Expo Center) in
> Las Vegas, Nevada, and the Sands Macao, The Venetian Macao Resort Hotel (The
> Venetian Macao), the Four Seasons Hotel Macao, Cotai Strip (the Four Seasons
> Hotel Macao, which is managed by Four Seasons Hotels Inc.) and the Plaza
> Casino (together with the Four Seasons Hotel Macao, the Four Seasons Macao)
> in the Macau Special Administrative Region (Macau) of the People�s Republic
> of China (China). Its segments include The Venetian Las Vegas, which
> includes the Sands Expo Center; The Palazzo; Sands Bethlehem; Sands Macao;
> The Venetian Macao; Four Seasons Macao; Other Asia (comprised primarily of
> the Company�s ferry operations and various other operations that are
> ancillary to the Company�s properties in Macau), and Marina Bay Sands.
> ==============
>
> I am using Excel 2010 with Windows 7. Have the latest definition files for
> SMF Addin.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
7c.

Re: MSN Company Description Returns Bad Characters Whenever Apostrop

Posted by: "lundyfinancial" lundyfinancial@yahoo.com   lundyfinancial

Tue Jul 26, 2011 2:06 pm (PDT)



Just noticed here it appears as &#65535; In excel it just appears as a small box in the text.

--- In smf_addin@yahoogroups.com, "lundyfinancial" <lundyfinancial@...> wrote:
>
> Hi,
>
> I am having an issue with =RCHGetElementNumber(Ticker, 1) where the function incorrectly returns the text for any company description that has an apostrophe in it. In place of the apostrophe it returns a square box with a question mark inside it. This becomes quite an issue for me as I am retrieving the data from an outside program which goes wonky when it runs into this unknown character.
>
> Any idea's how I can get the company description properly, or a way to remove this character automatically when the string is retrieved?
>
> Thank You
>
>
>
> Here is a cut and paste of the returned string in excel. You can see instances towards the end. (box doesn't show question mark here but does if i copy it into other editors)
> ==============
> Las Vegas Sands Corp. (LVSC) owns and operates The Venetian Resort Hotel Casino (The Venetian Las Vegas), The Palazzo Resort Hotel Casino (The Palazzo) and The Sands Expo and Convention Center (the Sands Expo Center) in Las Vegas, Nevada, and the Sands Macao, The Venetian Macao Resort Hotel (The Venetian Macao), the Four Seasons Hotel Macao, Cotai Strip (the Four Seasons Hotel Macao, which is managed by Four Seasons Hotels Inc.) and the Plaza Casino (together with the Four Seasons Hotel Macao, the Four Seasons Macao) in the Macau Special Administrative Region (Macau) of the People&#65535;s Republic of China (China). Its segments include The Venetian Las Vegas, which includes the Sands Expo Center; The Palazzo; Sands Bethlehem; Sands Macao; The Venetian Macao; Four Seasons Macao; Other Asia (comprised primarily of the Company&#65535;s ferry operations and various other operations that are ancillary to the Company&#65535;s properties in Macau), and Marina Bay Sands.
> ==============
>
> I am using Excel 2010 with Windows 7. Have the latest definition files for SMF Addin.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
7d.

Re: MSN Company Description Returns Bad Characters Whenever Apostrop

Posted by: "lundyfinancial" lundyfinancial@yahoo.com   lundyfinancial

Tue Jul 26, 2011 2:11 pm (PDT)



The SUBSTITUTE() function has worked in correcting the issue.

Thank you for your help.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Just use a SUBSTITUTE() function around it and replace the HTML encoded
> characters with apostrophes. I can't give you an exact formula because it
> has unprintable characters and will vary by font.
>
> On Tue, Jul 26, 2011 at 12:23 PM, lundyfinancial
> <lundyfinancial@...>wrote:
>
> >
> > I am having an issue with =RCHGetElementNumber(Ticker, 1) where the
> > function incorrectly returns the text for any company description that has
> > an apostrophe in it. In place of the apostrophe it returns a square box
> > with a question mark inside it. This becomes quite an issue for me as I am
> > retrieving the data from an outside program which goes wonky when it runs
> > into this unknown character.
> >
> > Any idea's how I can get the company description properly, or a way to
> > remove this character automatically when the string is retrieved?
> >
> > Thank You
> >
> >
> > Here is a cut and paste of the returned string in excel. You can see
> > instances towards the end. (box doesn't show question mark here but does if
> > i copy it into other editors)
> > ==============
> > Las Vegas Sands Corp. (LVSC) owns and operates The Venetian Resort Hotel
> > Casino (The Venetian Las Vegas), The Palazzo Resort Hotel Casino (The
> > Palazzo) and The Sands Expo and Convention Center (the Sands Expo Center) in
> > Las Vegas, Nevada, and the Sands Macao, The Venetian Macao Resort Hotel (The
> > Venetian Macao), the Four Seasons Hotel Macao, Cotai Strip (the Four Seasons
> > Hotel Macao, which is managed by Four Seasons Hotels Inc.) and the Plaza
> > Casino (together with the Four Seasons Hotel Macao, the Four Seasons Macao)
> > in the Macau Special Administrative Region (Macau) of the People�s Republic
> > of China (China). Its segments include The Venetian Las Vegas, which
> > includes the Sands Expo Center; The Palazzo; Sands Bethlehem; Sands Macao;
> > The Venetian Macao; Four Seasons Macao; Other Asia (comprised primarily of
> > the Company�s ferry operations and various other operations that are
> > ancillary to the Company�s properties in Macau), and Marina Bay Sands.
> > ==============
> >
> > I am using Excel 2010 with Windows 7. Have the latest definition files for
> > SMF Addin.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
8.1.

Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11

Posted by: "smortonm" smmarder@yahoo.com   smortonm

Tue Jul 26, 2011 3:14 pm (PDT)



Bon't know what happened, but YAHOO sees to have fixed the problem -- no
more erratic quotes. Hope everyone else has the same experience.
Sid
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...>
wrote:
>
> Are those hundreds of quote downloads in a single array-entered
formula or
> individual formulas in each cell? The latter can take a bit longer,
> especially if Yahoo is lagging. Maybe the "bad server" is timing out
and
> returning the bogus info -- that could really extend the time it takes
to
> get quotes...
>
> On Thu, Jul 21, 2011 at 6:35 AM, smortonm smmarder@... wrote:
>
> > Just wondering: Since the Yahoo Quote issue arose, I noticed that my
> > main spreadsheet has taken a VERY long time to open. I'm talking 20
> > minutes or so. This SS has hundreds of quote downloads.. Is anyone
else
> > experiencing this, and is there any ideas on how to speed it up??
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (27)
8.2.

Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11

Posted by: "dguillett1" dguillett1@gmail.com   donaldb36

Tue Jul 26, 2011 3:51 pm (PDT)



Using an external .cvs query I had also been getting some weird and very high values. Seems to be fixed. Let's hope it stays fixed.
Now, if they could get the 21.70 trailing dividend for MRO fixed....

From: smortonm
Sent: Tuesday, July 26, 2011 5:13 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11

Bon't know what happened, but YAHOO sees to have fixed the problem -- no
more erratic quotes. Hope everyone else has the same experience.
Sid
--- In mailto:smf_addin%40yahoogroups.com, Randy Harmelink <rharmelink@...>
wrote:
>
> Are those hundreds of quote downloads in a single array-entered
formula or
> individual formulas in each cell? The latter can take a bit longer,
> especially if Yahoo is lagging. Maybe the "bad server" is timing out
and
> returning the bogus info -- that could really extend the time it takes
to
> get quotes...
>
> On Thu, Jul 21, 2011 at 6:35 AM, smortonm smmarder@... wrote:
>
> > Just wondering: Since the Yahoo Quote issue arose, I noticed that my
> > main spreadsheet has taken a VERY long time to open. I'm talking 20
> > minutes or so. This SS has hundreds of quote downloads.. Is anyone
else
> > experiencing this, and is there any ideas on how to speed it up??
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (27)
9a.

Help!VBA! trying to create a formula that wit "RCHGetElementNumber"

Posted by: "Ilya R" ilya559@yahoo.com   ilya559

Tue Jul 26, 2011 7:25 pm (PDT)



I want to create a VBA with an array and a loop that would input
"=RCHGetElementNumber(Ticker, 5565)" into different cells.
I have the following code-----------------------------------------Sub
ilya49() Dim colNum As Long, rowNum As Long, rch As String rch =
"=RCHGetElementNumber(Ticker, " colNum = 2 For nm = 5565 To
5556 Step -1 colNum = colNum + 2 Sheets(1).Cells(24,
colNum).Value = rch & nm Next nmEnd
Sub------------------------------------------
However, when I run it, it gives me an error "Run-time error '1004':
Application-defined or object-defined error"
the reason for that is because rch = "=RCHGetElementNumber(Ticker, "
Is there any way to solve it or work around it???Please Help!!!!!
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
9b.

Re: Help!VBA! trying to create a formula that wit "RCHGetElementNumb

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Jul 26, 2011 7:49 pm (PDT)



Check the "Links" area of the group for a link to a message on using add-in
functions in VBA.

Also, check out the links related to smfUpdateDownloadTable. There's already
a macro that more or less does the looping for you automatically.

Also note that typically "Ticker" is a defined worksheet cell name. You
can't use it like you're doing below. You need to access it through the
Range() function of VBA.

On Tue, Jul 26, 2011 at 7:24 PM, Ilya R <ilya559@yahoo.com> wrote:

>
> I want to create a VBA with an array and a loop that would input
> "=RCHGetElementNumber(Ticker, 5565)" into different cells.
>
> I have the following code
> -----------------------------------------
> Sub ilya49()
> Dim colNum As Long, rowNum As Long, rch As String
> rch = "=RCHGetElementNumber(Ticker, "
>
>
> colNum = 2
> For nm = 5565 To 5556 Step -1
> colNum = colNum + 2
> Sheets(1).Cells(24, colNum).Value = rch & nm
> Next nm
> End Sub
> ------------------------------------------
>
> However, when I run it, it gives me an error "Run-time error '1004':
> Application-defined or object-defined error"
>
> the reason for that is because *rch = "=RCHGetElementNumber(Ticker, "*
>
> Is there any way to solve it or work around it???
> Please Help!!!!!
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Odd News

You won't believe

it, but it's true

Need traffic?

Drive customers

With search ads

on Yahoo!

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
Diposting oleh EXCEL FEED LEARNING di 03.48

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)