Jumat, 03 Juni 2011

[smf_addin] Digest Number 1845[1 Attachment]

Messages In This Digest (5 Messages)

1a.
Re: How to find the exchange From: Richard H. Wolf
1b.
Re: How to find the exchange From: Randy Harmelink
2a.
Fwd: [smf_addin] Digest Number 1843 From: Frederic Herrmann
2b.
Re: Digest Number 1843 [1 Attachment] From: Randy Harmelink
3.
Application in Access? From: darklordrises

Messages

1a.

Re: How to find the exchange

Posted by: "Richard H. Wolf" rhwolf@verizon.net   RHWOLF

Thu Jun 2, 2011 5:43 am (PDT)



Randy:

I am trying to download to excel for mac the following stock data from the
web: price, 52 wk high, 52 wk low, P?E, PEG, div yield from any free
source. I have a macBook running Mac OSX 10.6.7. I have excel for mac
2004. Do you know how I can do this?

Thanks

Richard

On 6/1/11 9:42 PM, "Randy Harmelink" <rharmelink@gmail.com> wrote:

>
>
>
>
>
> Use a Yahoo code of "x" with the RCHGetYahooQuotes() function.
>
> On Wed, Jun 1, 2011 at 5:43 PM, Anant Upadhyayula <uanant@ymail.com> wrote:
>>
>> based on the ticker, is there a way to find out which exchange it was listed
>> on. 
>> i.e. F is on NYSE
>> TSLA is on NASDAQ 
>>
>
>
>
>
>

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

Re: How to find the exchange

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

Thu Jun 2, 2011 5:44 am (PDT)



Sorry, but I know practically nil about Macs.

On Thu, Jun 2, 2011 at 3:57 AM, Richard H. Wolf <rhwolf@verizon.net> wrote:

>
> I am trying to download to excel for mac the following stock data from the
> web: price, 52 wk high, 52 wk low, P?E, PEG, div yield from any free
> source. I have a macBook running Mac OSX 10.6.7. I have excel for mac
> 2004. Do you know how I can do this?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2a.

Fwd: [smf_addin] Digest Number 1843

Posted by: "Frederic Herrmann" frederic.herrmann@gmail.com   luluka123456

Thu Jun 2, 2011 11:16 am (PDT)

[Attachment(s) from Frederic Herrmann included below]

Hi,

thanks for the extreme fast response. I have attached a screen shot what
happend after I have replaced the hard coded formula.

Do you have an ideas?

Regards,

Frederic

On Wed, Jun 1, 2011 at 1:00 PM, <smf_addin@yahoogroups.com> wrote:

> There are 12 messages in this issue.
>
> Topics in this digest:
>
> 1a. keeps telling me can't find add in when I open spreadsheets
> From: colobuyer123
> 1b. Re: keeps telling me can't find add in when I open spreadsheets
> From: Randy Harmelink
>
> 2a. Hi I am new to using the add in - Is it possible to access data on f
> From: yogimodak
> 2b. Re: Hi I am new to using the add in - Is it possible to access data
> From: Randy Harmelink
>
> 3a. Zacks Data
> From: JCHyjun
> 3b. Re: Zacks Data
> From: Randy Harmelink
> 3c. Re: Zacks Data
> From: JCHyjun
> 3d. Re: Zacks Data
> From: Randy Harmelink
>
> 4a. MSN StockScouter Web Page Error
> From: tbrayman
> 4b. Re: MSN StockScouter Web Page Error
> From: Randy Harmelink
>
> 5a. Running SMF on german excel
> From: Frederic Herrmann
> 5b. Re: Running SMF on german excel
> From: Randy Harmelink
>
>
> Messages
> __________________________________________________________
> 1a. keeps telling me can't find add in when I open spreadsheets
> Posted by: "colobuyer123" colobuyer123@yahoo.com colobuyer123
> Date: Tue May 31, 2011 8:55 am ((PDT))
>
> Excel keeps telling me can't find add in when I open spreadsheets although
> I've updated the links and the location of the add in in 'options'
> Help!
>
>
>
>
>
>
> Messages in this topic (2)
> __________________________________________________________
> 1b. Re: keeps telling me can't find add in when I open spreadsheets
> Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
> Date: Tue May 31, 2011 8:58 am ((PDT))
>
> Hopefully, this item from the "Links" area of the group will
> explain/resolve
> the problem:
>
> http://finance.groups.yahoo.com/group/smf_addin/message/11346
>
> On Tue, May 31, 2011 at 7:30 AM, colobuyer123 <colobuyer123@yahoo.com
> >wrote:
>
> > Excel keeps telling me can't find add in when I open spreadsheets
> although
> > I've updated the links and the location of the add in in 'options'
> > Help!
> >
>
>
>
>
> Messages in this topic (2)
> __________________________________________________________
> __________________________________________________________
> 2a. Hi I am new to using the add in - Is it possible to access data on f
> Posted by: "yogimodak" ymodak@gmail.com yogimodak
> Date: Tue May 31, 2011 9:42 am ((PDT))
>
> Yahoo Finance & MSN etc. dont have good earnings estaimates data for
> foreign stocks. Reuters.com does. Has anyone built anything to access the
> data from reuters.com or any other alternative source that is good for
> foreign stocks?
>
> Thanks.
>
>
>
>
>
>
> Messages in this topic (2)
> __________________________________________________________
> 2b. Re: Hi I am new to using the add in - Is it possible to access data
> Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
> Date: Tue May 31, 2011 9:47 am ((PDT))
>
> I just tried ticker HMb.ST with the
> RCHGetTableCell-Template-Reuters-Analysts.xls template from the files area
> and it seems to work OK...
>
> On Tue, May 31, 2011 at 9:26 AM, yogimodak <ymodak@gmail.com> wrote:
>
> > Yahoo Finance & MSN etc. dont have good earnings estaimates data for
> > foreign stocks. Reuters.com does. Has anyone built anything to access the
> > data from reuters.com or any other alternative source that is good for
> > foreign stocks?
> >
>
>
>
>
> Messages in this topic (2)
> __________________________________________________________
> __________________________________________________________
> 3a. Zacks Data
> Posted by: "JCHyjun" JCHyjun@aol.com JCHyjun
> Date: Tue May 31, 2011 11:29 am ((PDT))
>
> Hello,
>
> Zacks provides quite interesting data part of them are already included in
> SMF elements (848-876; 13869-13890) and template, but few quite unique are
> missing, such as variable in Zacks screen (
> http://www.zacks.com/screening_2/custom/) for: Ownership and Broker Rating
> & Changes.
>
> I don't know where also such info can be found for free at WWW. Anny
> suggestions?
>
> Randy,
> Is it possible to add SMF elements to get these data, please?
>
> Sincerely
> JCH
>
>
>
>
>
>
>
>
>
>
> Messages in this topic (4)
> __________________________________________________________
> 3b. Re: Zacks Data
> Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
> Date: Tue May 31, 2011 2:21 pm ((PDT))
>
> Everything I have for screening output is stuff I wouldn't document,
> especially since they seem to be making changes to it quite often. My
> membership there has lapsed, so I don't have access to a lot of their data
> any more.
>
> On Tue, May 31, 2011 at 11:28 AM, JCHyjun <JCHyjun@aol.com> wrote:
>
> >
> > Zacks provides quite interesting data part of them are already included
> in
> > SMF elements (848-876; 13869-13890) and template, but few quite unique
> are
> > missing, such as variable in Zacks screen (
> > http://www.zacks.com/screening_2/custom/) for: Ownership and Broker
> Rating
> > & Changes.
> >
> > I don't know where also such info can be found for free at WWW. Anny
> > suggestions?
> >
> > Randy,
> > Is it possible to add SMF elements to get these data, please?
> >
>
>
>
>
> Messages in this topic (4)
> __________________________________________________________
> 3c. Re: Zacks Data
> Posted by: "JCHyjun" JCHyjun@aol.com JCHyjun
> Date: Tue May 31, 2011 5:17 pm ((PDT))
>
> Hi Randy,
>
> You do NOT need access for most of Zacks data. Yes they change WWW design
> but they keep old one active (e.g. the link I mentioned is their "old"
> custom screen builder and it works as good as their "new" screen builder).
> Can you suggest how to create elements to Zacks' items "Change in Insider
> Holdings" (in screen Ownership area) and "Change in Avg Rec" in in screen
> Broker Rating& Changes area) please?
>
> Sincerely,
> JCH
>
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
> >
> > Everything I have for screening output is stuff I wouldn't document,
> > especially since they seem to be making changes to it quite often. My
> > membership there has lapsed, so I don't have access to a lot of their
> data
> > any more.
> >
> > On Tue, May 31, 2011 at 11:28 AM, JCHyjun <JCHyjun@...> wrote:
> >
> > >
> > > Zacks provides quite interesting data part of them are already included
> in
> > > SMF elements (848-876; 13869-13890) and template, but few quite unique
> are
> > > missing, such as variable in Zacks screen (
> > > http://www.zacks.com/screening_2/custom/) for: Ownership and Broker
> Rating
> > > & Changes.
> > >
> > > I don't know where also such info can be found for free at WWW. Anny
> > > suggestions?
> > >
> > > Randy,
> > > Is it possible to add SMF elements to get these data, please?
> > >
> >
>
>
>
>
>
>
>
> Messages in this topic (4)
> __________________________________________________________
> 3d. Re: Zacks Data
> Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
> Date: Tue May 31, 2011 6:44 pm ((PDT))
>
> Just run your screen and save the link that is on the "Export" button. Then
> do something like:
>
> =smfGetCSVFile("
> http://www.zacks.com/screening_2/custom/export.php?rptid=xxxx&sid=yyyy")
>
> ...where you'll have custom values for "xxxx" and "yyyy" that were
> generated
> when you created the screen. That gave me something like:
>
>
> Company Name Ticker % Held
> by
> Insiders Net % Chg
> Insider
> Holdings
> (12 Wks) # of
> Insider
> Buyers
> (12 Wks) # of
> Insider
> Sellers
> (12 Wks) % Held by
> Institutions Last
> Close NEWS COMMUN INC NWCM 65.38 N/A N/A N/A N/A 101 SCOPE INDUSTRIE SCPJ
> 68.1 N/A N/A N/A 1.3 212 SEABOARD CORP SEB 74.3 N/A N/A N/A N/A 2345
> POLARIS
> INDUS PII 2.8 N/A N/A N/A 76.55 104.55 WESCO FINANCIAL WSC 1 N/A N/A N/A
> 94.06 389 APPLE INC AAPL 0.67 -22.64 N/A 5 70.44 337.41 PANERA BREAD CO
> PNRA 9.75 -5.9 N/A 11 89.5 125.97 AJINOMOTO AJINY N/A N/A N/A N/A 2.86
> 109.99 ALEXANDERS INC ALX 27.34 N/A N/A N/A 46.99 380.8 TERRA NITROGEN
> TNH
> 1.95 N/A N/A N/A 5.73 124.7 AMEN PPTYS INC AMEN 30.34 N/A N/A N/A N/A
> 400 AFFIL
> MANAGERS AMG 4.34 -22.51 N/A 1 96.44 104.93 AMAZON.COM<http://amazon.com/>INC AMZN 1.97 -53.92
> N/A 3 76.49 194.13 APACHE CORP APA 0.73 -1.65 N/A 3 89.39 123.25
> ARKEMA-ADR ARKAY N/A N/A N/A N/A N/A 104.75 ATRION CORP ATRI 21.59 N/A N/A
> N/A 62.59 183.87 AUTOZONE INC AZO 38 -17.07 N/A 1 N/A 296.71 CREDICORP
> LTD
> BAP 15.9 N/A N/A N/A 81.7 104.46 BARD C R INC BCR 1.45 -5.24 N/A 2 95.64
> 110.89 BIO-RAD LABS -A BIO 25.8 -7.79 N/A 1 58.38 123.61
>
> On Tue, May 31, 2011 at 5:17 PM, JCHyjun <JCHyjun@aol.com> wrote:
>
> >
> > You do NOT need access for most of Zacks data. Yes they change WWW design
> > but they keep old one active (e.g. the link I mentioned is their "old"
> > custom screen builder and it works as good as their "new" screen
> builder).
> > Can you suggest how to create elements to Zacks' items "Change in Insider
> > Holdings" (in screen Ownership area) and "Change in Avg Rec" in in screen
> > Broker Rating& Changes area) please?
> >
>
>
>
>
> Messages in this topic (4)
> __________________________________________________________
> __________________________________________________________
> 4a. MSN StockScouter Web Page Error
> Posted by: "tbrayman" tbrayman@yahoo.com tbrayman
> Date: Tue May 31, 2011 2:04 pm ((PDT))
>
> It looks like MSN changed the link to their StockScouter web page.
>
> I was receiving Error in data from the StockScouter page. When I went
> to this URL
> http://moneycentral.msn.com/investor/srs/srsmain.asp?Symbol=CSCO;?;;;;;;\
> ;;0
> <http://moneycentral.msn.com/investor/srs/srsmain.asp?Symbol=CSCO;?;;;;;\
> ;;;0> I got page you requested cant be found. If you replace "srs"
> with "StockRating" in elements 540 - 552 the problem goes away. Ex:
> http://moneycentral.msn.com/investor/StockRating/srsmain.asp?Symbol=CSCO\
> ;?;;;;;;;;0
> <http://moneycentral.msn.com/investor/StockRating/srsmain.asp?Symbol=CSC\
> O;?;;;;;;;;0>
>
>
>
>
>
> Messages in this topic (2)
> __________________________________________________________
> 4b. Re: MSN StockScouter Web Page Error
> Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
> Date: Tue May 31, 2011 2:22 pm ((PDT))
>
> There are new element definitions for MSN web pages in the "Works in
> Progress" folder. I had to redefine the elements when they changed their
> web
> site back in January.
>
> On Tue, May 31, 2011 at 2:04 PM, tbrayman <tbrayman@yahoo.com> wrote:
>
> > It looks like MSN changed the link to their StockScouter web page.
> >
> > I was receiving Error in data from the StockScouter page. When I went to
> > this URL
> >
> http://moneycentral.msn.com/investor/srs/srsmain.asp?Symbol=CSCO;?;;;;;;;;0
> > I got page you requested cant be found. If you replace "srs" with
> > "StockRating" in elements 540 - 552 the problem goes away. Ex:
> >
> http://moneycentral.msn.com/investor/StockRating/srsmain.asp?Symbol=CSCO;?;;;;;;;;0
> >
>
>
>
>
> Messages in this topic (2)
> __________________________________________________________
> __________________________________________________________
> 5a. Running SMF on german excel
> Posted by: "Frederic Herrmann" frederic.herrmann@gmail.com luluka123456
> Date: Tue May 31, 2011 2:13 pm ((PDT))
>
> Hi,
>
> I am trying to install your add in on my PC. Excel 2003 Windows XP. I don't
> have a my programs on my c drive it's all installed on e. I have changed
> the
> source of the add in to correct position.
> Excel is showing a message like "the name is not defined or it is refering
> to a rectangular area".
>
>
> Do you have an idea how I can get to work? How do I create the formulars?
>
> Your help is highly appreciated.
>
> Thanks in advance
>
> Fred
>
>
>
>
> Messages in this topic (2)
> __________________________________________________________
> 5b. Re: Running SMF on german excel
> Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
> Date: Tue May 31, 2011 2:25 pm ((PDT))
>
> See this item from the "Links" area of the group:
>
> http://finance.groups.yahoo.com/group/smf_addin/message/11346
>
> On Tue, May 31, 2011 at 12:02 PM, Frederic Herrmann <
> frederic.herrmann@gmail.com> wrote:
>
> >
> > I am trying to install your add in on my PC. Excel 2003 Windows XP. I
> don't
> > have a my programs on my c drive it's all installed on e. I have changed
> the
> > source of the add in to correct position.
> > Excel is showing a message like "the name is not defined or it is
> refering
> > to a rectangular area".
> >
> > Do you have an idea how I can get to work? How do I create the formulars?
> >
> >
>
>
>
>
> Messages in this topic (2)
>
>
>
>
>
> ----------------------------------------------------------
> Yahoo! Groups Links
>
>
>
> ----------------------------------------------------------
>
>

Attachment(s) from Frederic Herrmann

1 of 1 Photo(s)

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

Re: Digest Number 1843 [1 Attachment]

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

Thu Jun 2, 2011 11:24 am (PDT)



I still see hard-coded locations in front of the function invocations --
they are what need to be replaced. What did you replace?

PS: If replying to a digest, please change the subject and retain only
relevant information.

On Thu, Jun 2, 2011 at 11:16 AM, Frederic Herrmann <
frederic.herrmann@gmail.com> wrote:

>
> thanks for the extreme fast response. I have attached a screen shot what
> happend after I have replaced the hard coded formula.
>
> Do you have an ideas?
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3.

Application in Access?

Posted by: "darklordrises" liuyuchen1117@hotmail.com   darklordrises

Fri Jun 3, 2011 1:10 am (PDT)



Guys, does anyone know how to import/write similar finance functions in Access? What I need is very simple, just the last price and some sort of intra day high and low given a ticker. But I need to embed that into Access.

Really appreciate it.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
Recent Activity
Visit Your Group
Yahoo! News

Odd News

You won't believe

it, but it's true

New web site?

Drive traffic now.

Get your business

on Yahoo! search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

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.38

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)