Rabu, 14 Maret 2012

[smf_addin] Digest Number 2146

Messages In This Digest (17 Messages)

Messages

1a.

Getting Stock names from a list of Stock symbols

Posted by: "HankD" HankDfrmSD@aol.com   hankdfrmsd

Tue Mar 13, 2012 11:19 am (PDT)



Does anyone know of an Excel macro that will take a list of stock symbols in one column, and go to the internet and download the corresponding company names, placing them in the next column?

Hank

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

Re: Getting Stock names from a list of Stock symbols

Posted by: "Martin Topper" mtopper@yahoo.com   mtopper

Tue Mar 13, 2012 11:39 am (PDT)



the smf addin can do that

________________________________
From: HankD <HankDfrmSD@aol.com>
To: smf_addin@yahoogroups.com
Sent: Tuesday, March 13, 2012 1:32 PM
Subject: [smf_addin] Getting Stock names from a list of Stock symbols


 
Does anyone know of an Excel macro that will take a list of stock symbols in one column, and go to the internet and download the corresponding company names, placing them in the next column?

Hank

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

Re: Getting Stock names from a list of Stock symbols

Posted by: "sudhir agarwal" Agarwal.sudhir@gmail.com   sudhir_agarwal1

Tue Mar 13, 2012 11:43 am (PDT)



=RCHGetElementNumber($A459,'Dummy Sheet for Numbers'!A$1)
This gives you company details and the description starts with the company
name.
The sheet I had had the company name (S&P 500) so did not require it..

On Tue, Mar 13, 2012 at 2:39 PM, Martin Topper <mtopper@yahoo.com> wrote:

> **
>
>
> the smf addin can do that
>
> ------------------------------
> *From:* HankD <HankDfrmSD@aol.com>
> *To:* smf_addin@yahoogroups.com
> *Sent:* Tuesday, March 13, 2012 1:32 PM
> *Subject:* [smf_addin] Getting Stock names from a list of Stock symbols
>
>
> Does anyone know of an Excel macro that will take a list of stock symbols
> in one column, and go to the internet and download the corresponding
> company names, placing them in the next column?
>
> Hank
>
>
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
1d.

Re: Getting Stock names from a list of Stock symbols

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

Tue Mar 13, 2012 12:25 pm (PDT)



Just use the RCHGetYahooQuotes() function with the "n" Yahoo code.

On Tue, Mar 13, 2012 at 10:32 AM, HankD <HankDfrmSD@aol.com> wrote:

> Does anyone know of an Excel macro that will take a list of stock symbols
> in one column, and go to the internet and download the corresponding
> company names, placing them in the next column?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
2a.

Use page that requires login?

Posted by: "Craig" craig.sander@comcast.net   c1sander

Tue Mar 13, 2012 12:54 pm (PDT)



Is there a way to pull from a web page that requires a login?

Specifically, I am trying to get (near) real time option quotes using "=RCHGetTableCell" from E-trade (as an example). If I go to the site in my browser and login, I get near real-time quotes. If I don't log-in I get delayed quotes. When using =RCHGetTableCell in Excel, it always gives me the delayed quotes – even if I am concurrently logged in through my browser.

Thanks for any help.
Craig

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

Re: Use page that requires login?

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

Tue Mar 13, 2012 12:57 pm (PDT)



You need to log in with either the EXCEL Web Query dialog, or with IE.
Because EXCEL and the add-in use the MicroSoft Internet engine. So only IE
cookies and Temporary Internet Files are being used. Logging in with
something like FireFox won't do the trick, because it maintains its own
cookies.

On Tue, Mar 13, 2012 at 12:44 PM, Craig <craig.sander@comcast.net> wrote:

> Is there a way to pull from a web page that requires a login?
>
> Specifically, I am trying to get (near) real time option quotes using
> "=RCHGetTableCell" from E-trade (as an example). If I go to the site in my
> browser and login, I get near real-time quotes. If I don't log-in I get
> delayed quotes. When using =RCHGetTableCell in Excel, it always gives me
> the delayed quotes – even if I am concurrently logged in through my browser.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
2c.

Re: Use page that requires login?

Posted by: "Craig" craig.sander@comcast.net   c1sander

Tue Mar 13, 2012 1:10 pm (PDT)



I tried logging in from IE. This didn't work. It still gave me delayed quotes.

Craig

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You need to log in with either the EXCEL Web Query dialog, or with IE.
> Because EXCEL and the add-in use the MicroSoft Internet engine. So only IE
> cookies and Temporary Internet Files are being used. Logging in with
> something like FireFox won't do the trick, because it maintains its own
> cookies.
>
> On Tue, Mar 13, 2012 at 12:44 PM, Craig <craig.sander@...> wrote:
>
> > Is there a way to pull from a web page that requires a login?
> >
> > Specifically, I am trying to get (near) real time option quotes using
> > "=RCHGetTableCell" from E-trade (as an example). If I go to the site in my
> > browser and login, I get near real-time quotes. If I don't log-in I get
> > delayed quotes. When using =RCHGetTableCell in Excel, it always gives me
> > the delayed quotes â€" even if I am concurrently logged in through my browser.
> >
>

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

Re: Use page that requires login?

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

Tue Mar 13, 2012 1:16 pm (PDT)



Did you run the smfForceRecalculation macro? It would still be extracting
data from the originally retrieved web page (i.e. PRE-log in) unless you
told the add-in to get a new copy of the web page AFTER the log in.

Also, you might need to change your Internet Options, to make sure IE is
always getting new content. See the new smfForceRecalculation items in the
"Links" area of the group for more information.

On Tue, Mar 13, 2012 at 1:10 PM, Craig <craig.sander@comcast.net> wrote:

> I tried logging in from IE. This didn't work. It still gave me delayed
> quotes.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
2e.

Re: Use page that requires login?

Posted by: "Ashish Mukerji" ashishkm@yahoo.com   ashishkm

Tue Mar 13, 2012 1:17 pm (PDT)



Hi Craig ... I have tried it too .... it doesn't seem to work for me even if I use IE browser and do the log in ... I have sort of given up .... If you can get it to work, I would appreciate knowing the process ... I am not as computer savvy as you seem to be ...

 
Ashish         

>________________________________
> From: Craig <craig.sander@comcast.net>
>To: smf_addin@yahoogroups.com
>Sent: Tuesday, March 13, 2012 4:10 PM
>Subject: [smf_addin] Re: Use page that requires login?
>
>
> 
>I tried logging in from IE. This didn't work. It still gave me delayed quotes.
>
>Craig
>
>--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>>
>> You need to log in with either the EXCEL Web Query dialog, or with IE.
>> Because EXCEL and the add-in use the MicroSoft Internet engine. So only IE
>> cookies and Temporary Internet Files are being used. Logging in with
>> something like FireFox won't do the trick, because it maintains its own
>> cookies.
>>
>> On Tue, Mar 13, 2012 at 12:44 PM, Craig <craig.sander@...> wrote:
>>
>> > Is there a way to pull from a web page that requires a login?
>> >
>> > Specifically, I am trying to get (near) real time option quotes using
>> > "=RCHGetTableCell" from E-trade (as an example). If I go to the site in my
>> > browser and login, I get near real-time quotes. If I don't log-in I get
>> > delayed quotes. When using =RCHGetTableCell in Excel, it always gives me
>> > the delayed quotes â€" even if I am concurrently logged in through my browser.
>> >
>>
>
>
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
3a.

RCHGetTableCell WSJ Global Government Bond Data

Posted by: "d.sweitzer22" d.sweitzer22@yahoo.com   d.sweitzer22

Tue Mar 13, 2012 1:08 pm (PDT)



Hi I am trying to use the RCHGetTableCell command to pull in global bond data from the Wall Street Journal http://online.wsj.com/mdc/public/page/2_3022-govtbonds.html?
I am trying to get the German 10 yr yield so I tried: =RCHGetTableCell("http://online.wsj.com/mdc/public/page/2_3022-govtbonds.html?",2,"Germany",2 )
where the cell I want is two columns over and 2 rows down. For some reason it returns the the 3rd column over on the same row. I don't know html so I am struggling. Please help! Thanks in advance for any suggestions.

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

Re: RCHGetTableCell WSJ Global Government Bond Data

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

Tue Mar 13, 2012 1:13 pm (PDT)



Right track, but wrong parameter values. Try:

=RCHGetTableCell("
http://online.wsj.com/mdc/public/page/2_3022-govtbonds.html",4,"Germany",,,,2
)

You need to have placeholders for the empty parameters before you enter the
pRows parameter.

On Tue, Mar 13, 2012 at 1:08 PM, d.sweitzer22 <d.sweitzer22@yahoo.com>wrote:

> Hi I am trying to use the RCHGetTableCell command to pull in global bond
> data from the Wall Street Journal
> http://online.wsj.com/mdc/public/page/2_3022-govtbonds.html?
> I am trying to get the German 10 yr yield so I tried: =RCHGetTableCell("
> http://online.wsj.com/mdc/public/page/2_3022-govtbonds.html?",2,"Germany",2
> )
> where the cell I want is two columns over and 2 rows down. For some reason
> it returns the the 3rd column over on the same row. I don't know html so I
> am struggling. Please help! Thanks in advance for any suggestions.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3c.

Re: RCHGetTableCell WSJ Global Government Bond Data

Posted by: "d.sweitzer22" d.sweitzer22@yahoo.com   d.sweitzer22

Tue Mar 13, 2012 1:49 pm (PDT)



Thanks!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Right track, but wrong parameter values. Try:
>
> =RCHGetTableCell("
> http://online.wsj.com/mdc/public/page/2_3022-govtbonds.html",4,"Germany",,,,2
> )
>
> You need to have placeholders for the empty parameters before you enter the
> pRows parameter.
>
> On Tue, Mar 13, 2012 at 1:08 PM, d.sweitzer22 <d.sweitzer22@...>wrote:
>
> > Hi I am trying to use the RCHGetTableCell command to pull in global bond
> > data from the Wall Street Journal
> > http://online.wsj.com/mdc/public/page/2_3022-govtbonds.html?
> > I am trying to get the German 10 yr yield so I tried: =RCHGetTableCell("
> > http://online.wsj.com/mdc/public/page/2_3022-govtbonds.html?",2,"Germany",2
> > )
> > where the cell I want is two columns over and 2 rows down. For some reason
> > it returns the the 3rd column over on the same row. I don't know html so I
> > am struggling. Please help! Thanks in advance for any suggestions.
> >
>

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

Re: RCHGetTableCell WSJ Global Government Bond Data

Posted by: "Philip S" Philip_R_Small@hotmail.com   philip_r_small

Wed Mar 14, 2012 12:43 am (PDT)





--- In smf_addin@yahoogroups.com, "d.sweitzer22" <d.sweitzer22@...> wrote:
>
> Hi I am trying to use the RCHGetTableCell command to pull in global bond data from the Wall Street Journal http://online.wsj.com/mdc/public/page/2_3022-govtbonds.html?
> I am trying to get the German 10 yr yield so I tried: =RCHGetTableCell("http://online.wsj.com/mdc/public/page/2_3022-govtbonds.html?",2,"Germany",2 )
> where the cell I want is two columns over and 2 rows down. For some reason it returns the the 3rd column over on the same row. I don't know html so I am struggling. Please help! Thanks in advance for any suggestions.
>

I use the following code to get a 10 year bund yield:

=VALUE(smfGetTagContent("http://www.fixedincomeinvestor.co.uk/x/bondtable.html?groupid=8","td",3,">EUR"))

This code brings in the date of the yield information as a check.

=smfGetTagContent("http://www.fixedincomeinvestor.co.uk/x/bondtable.html?groupid=8","td",1,">EUR")

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

Help on downloading options data

Posted by: "Lezhi Huang" lezhi@yahoo.com   lezhi

Tue Mar 13, 2012 10:16 pm (PDT)



Hi all,

I tried to download stock options data by using =smfGetOptionQuotes("SPY Jun 2010 $100 Call,SPY Jun 2010 $110 Call","zba",1) copy paste from the example in documentation folder online.

It gave "error" in the data cells. The title cells are working fine. It also works fine to download stock data by using function like =RCHGetYahooQuotes("IBM").

Anyone can kindly help?

Thank you,

Rachel

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

Re: Help on downloading options data

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

Tue Mar 13, 2012 10:19 pm (PDT)



The examples are two years old. Try changing the years to 2012 and they
should work.

On Tue, Mar 13, 2012 at 9:58 PM, Lezhi Huang <lezhi@yahoo.com> wrote:

>
> I tried to download stock options data by using =smfGetOptionQuotes("SPY
> Jun 2010 $100 Call,SPY Jun 2010 $110 Call","zba",1) copy paste from the
> example in documentation folder online.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
5a.

RCHGetElement Number 13629;ReutersRat;Comparison Ratios

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

Wed Mar 14, 2012 1:19 am (PDT)



Is there any update on reuters.com for their S&P 500? or are there any sites that have these functions too..Please tell me.

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

Re: RCHGetElement Number 13629;ReutersRat;Comparison Ratios

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

Wed Mar 14, 2012 2:02 am (PDT)



It appears Reuters no longer carries them. MSN seems to -- check out this
template:

SMF-Template-MSN-Key-Ratio-Comparisons.xls

On Wed, Mar 14, 2012 at 1:19 AM, bleushin19 <bleushin19@yahoo.com> wrote:

> Is there any update on reuters.com for their S&P 500? or are there any
> sites that have these functions too..Please tell me.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
Recent Activity
Visit Your Group
Search Ads

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Fashion News

What's the word on

fashion and style?

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 02.02

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)