Messages In This Digest (15 Messages)

1a.: request for info on mutual funds 52 week high & low from morningstar From: Rene Reyna
1b.: Re: request for info on mutual funds 52 week high & low from morning From: Randy Harmelink

2a.: IBD data From: ilmostro
2b.: Re: IBD data From: Randy Harmelink
2c.: Re: IBD data From: Bryan
2d.: Re: IBD data From: Randy Harmelink
2e.: Re: IBD data From: Bryan

3a.: Re: Heat Maps From: bobsledproductions
3b.: Re: Heat Maps From: Martin Topper

4a.: getyahoohistory From: chj.2010
4b.: Re: getyahoohistory From: Randy Harmelink

5a.: Re: Freeware TA add-on From: investor952
5b.: Re: Freeware TA add-on From: james morlock
5c.: Re: Freeware TA add-on From: investor952
5d.: Re: Freeware TA add-on From: Randy H

View All Topics | Create New Topic

Messages

1a.: request for info on mutual funds 52 week high & low from morningstar

Posted by: "Rene Reyna" rr76012@yahoo.com rr76012

Fri Jul 8, 2011 8:16 am (PDT)

Hello Randy,

A special request from morningstar.

I would like to request info on mutual funds, the 52 week highs & lows from morningstar?

I don't know how you do what you do, but if you could do this it would be very helpful info.

Thanks,
Rene

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
1b.: Re: request for info on mutual funds 52 week high & low from morning

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

Fri Jul 8, 2011 8:58 am (PDT)

Unfortunately, it needs to be extracted from Javascript code, but I think
this will work:

=0+smfStrExtr(RCHGetWebData("
http://quote.morningstar.com/fund/f.aspx?t=vfinx","vkey:"),"_52Week:""","-")
=0+smfStrExtr(smfStrExtr(RCHGetWebData("
http://quote.morningstar.com/fund/f.aspx?t=vfinx
","vkey:"),"_52Week:""",",Min"),"-","""")

On Fri, Jul 8, 2011 at 8:16 AM, Rene Reyna <rr76012@yahoo.com> wrote:

>
> I would like to request info on mutual funds, the 52 week highs & lows from
> morningstar?
>
> I don't know how you do what you do, but if you could do this it would be
> very helpful info.
>

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

2a.: IBD data

Posted by: "ilmostro" ilmostrobtw@gmail.com ilmostro

Fri Jul 8, 2011 12:56 pm (PDT)

I am having trouble getting some data elements from IBD.
Here is the formula for EPS that I am using:
=RCHGetTableCell("http://www.investors.com/StockResearch/StockCheckup.aspx?symbol="&A2,1,">EPS Rating")
It used to work just fine and I still get some data elements so I don't know what is going on. It still gets the PE data fine and the %off 52 week high. But it won't grap the A/D,EPS,RS,GRS data anymore.

Thanks,
Bryan

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

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

Fri Jul 8, 2011 1:01 pm (PDT)

Us the EXCEL Web Query dialog to double check to make sure you are logged
in. I just cut and pasted your formula below and used ticker MMM with it,
and it worked fine for me.

Sometimes IBD will pop up an advertising page on your first visit to the
site. If that is happening, the add-in will never get beyond that
advertising page.

On Fri, Jul 8, 2011 at 12:28 PM, ilmostro <ilmostrobtw@gmail.com> wrote:

> I am having trouble getting some data elements from IBD.
> Here is the formula for EPS that I am using:
> =RCHGetTableCell("
> http://www.investors.com/StockResearch/StockCheckup.aspx?symbol="&A2,1,">EPS
> Rating")
> It used to work just fine and I still get some data elements so I don't
> know what is going on. It still gets the PE data fine and the %off 52 week
> high. But it won't grap the A/D,EPS,RS,GRS data anymore.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
2c.: Re: IBD data

Posted by: "Bryan" ilmostrobtw@gmail.com ilmostro

Fri Jul 8, 2011 1:57 pm (PDT)

Ok, total noob with this stuff. How do I use the web query. I have logged
into investors.com website with IE and like I say it will grab some of the
data. PE for example.
Thanks,
Bryan

On Fri, Jul 8, 2011 at 3:00 PM, Randy Harmelink <rharmelink@gmail.com>wrote:

> **
>
>
> Us the EXCEL Web Query dialog to double check to make sure you are logged
> in. I just cut and pasted your formula below and used ticker MMM with it,
> and it worked fine for me.
>
> Sometimes IBD will pop up an advertising page on your first visit to the
> site. If that is happening, the add-in will never get beyond that
> advertising page.
>
>
> On Fri, Jul 8, 2011 at 12:28 PM, ilmostro <ilmostrobtw@gmail.com> wrote:
>
>> I am having trouble getting some data elements from IBD.
>> Here is the formula for EPS that I am using:
>> =RCHGetTableCell("
>> http://www.investors.com/StockResearch/StockCheckup.aspx?symbol="&A2,1,">EPS
>> Rating")
>> It used to work just fine and I still get some data elements so I don't
>> know what is going on. It still gets the PE data fine and the %off 52 week
>> high. But it won't grap the A/D,EPS,RS,GRS data anymore.
>>
>
>
>

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

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

Fri Jul 8, 2011 3:02 pm (PDT)

Keyboard shortcut for EXCEL Web Query is alt+d+d+w. Then type "investors.com"
into the address bar and click "Go". If I'm logged in properly, I'll be on
their front page with it saying "Hi, Randy".

Are the items that are working coming from the "checkup" page or the "quote"
page?

On Fri, Jul 8, 2011 at 1:57 PM, Bryan <ilmostrobtw@gmail.com> wrote:

>
> Ok, total noob with this stuff. How do I use the web query. I have logged
> into investors.com website with IE and like I say it will grab some of the
> data. PE for example.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
2e.: Re: IBD data

Posted by: "Bryan" ilmostrobtw@gmail.com ilmostro

Fri Jul 8, 2011 3:10 pm (PDT)

Great!. I did the web query and logged in through excel. I had already
logged in via IE too. And now it works like it always did.
The items that were working were on the "quote" page and I think most if not
all that werent working was on the "stock checkup" page.

Thanks,
Bryan

On Fri, Jul 8, 2011 at 5:02 PM, Randy Harmelink <rharmelink@gmail.com>wrote:

> **
>
>
> Keyboard shortcut for EXCEL Web Query is alt+d+d+w. Then type "
> investors.com" into the address bar and click "Go". If I'm logged in
> properly, I'll be on their front page with it saying "Hi, Randy".
>
> Are the items that are working coming from the "checkup" page or the
> "quote" page?
>
>
> On Fri, Jul 8, 2011 at 1:57 PM, Bryan <ilmostrobtw@gmail.com> wrote:
>
>>
>> Ok, total noob with this stuff. How do I use the web query. I have logged
>> into investors.com website with IE and like I say it will grab some of
>> the data. PE for example.
>>
>
>
>

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

3a.: Re: Heat Maps

Posted by: "bobsledproductions" JPeters3515@snet.net bobsledproductions

Fri Jul 8, 2011 1:24 pm (PDT)

Download the portfolio monitor spreadsheet that is here:

http://finance.groups.yahoo.com/group/smf_addin/files/Uploads%20by%20forum%20members/Toteboard.net/

Not quite as pretty as SmartMoney's, but hopefully you'll get what you need.

--- In smf_addin@yahoogroups.com, "tylerohlmann" <tyler.ohlmann@...> wrote:
>
> I love the Harmelink add-ins! They are incredibly powerful and I've had a lot of fun learning and utilizing them. There is one tool I would really love to have that I haven't been able to find and I think you may be able to help me. Let's just say, if ANYone can help me, I think you'll be able to :)
>
> Heat Maps have always been a central part of my intraday research. For an example see http://www.smartmoney.com/map-of-the-market/
>
> The problem I've always had is that they're never customizable enough. If it was possible to create one in eXcel, I could make it exactly as needed.
>
> Have you worked on heat maps at all or know of resources that could help me create one? I'm looking to have several hundred tickers grouped into between 10 and 15 categories.
>
> I'd appreciate any kind of advice or help you could give in this area.
>
> Thanks in advance!
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
3b.: Re: Heat Maps

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

Fri Jul 8, 2011 2:11 pm (PDT)

Hi

I looked at the files you mentioned and they seem like a terrific set of tools,
even at first glance. I will look further when time permits.

However I noticed a bug in the Company Comparison.xls file.

It appears that Shares Outstanding (Est.) is actually the Total market cap in
dollars. To be shares outstanding it would need to be divided by the current
price.

regards

Marty

________________________________
From: bobsledproductions <JPeters3515@snet.net>
To: smf_addin@yahoogroups.com
Sent: Fri, July 8, 2011 4:24:10 PM
Subject: [smf_addin] Re: Heat Maps

Download the portfolio monitor spreadsheet that is here:

http://finance.groups.yahoo.com/group/smf_addin/files/Uploads%20by%20forum%20members/Toteboard.net/

Not quite as pretty as SmartMoney's, but hopefully you'll get what you need.

--- In smf_addin@yahoogroups.com, "tylerohlmann" <tyler.ohlmann@...> wrote:
>
> I love the Harmelink add-ins! They are incredibly powerful and I've had a lot
>of fun learning and utilizing them. There is one tool I would really love to
>have that I haven't been able to find and I think you may be able to help me.
>Let's just say, if ANYone can help me, I think you'll be able to :)
>
> Heat Maps have always been a central part of my intraday research. For an
>example see http://www.smartmoney.com/map-of-the-market/
>
> The problem I've always had is that they're never customizable enough. If it
>was possible to create one in eXcel, I could make it exactly as needed.
>
> Have you worked on heat maps at all or know of resources that could help me
>create one? I'm looking to have several hundred tickers grouped into between 10
>and 15 categories.
>
> I'd appreciate any kind of advice or help you could give in this area.
>
> Thanks in advance!
>

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

4a.: getyahoohistory

Posted by: "chj.2010" chasjohn02@yahoo.com chj.2010

Fri Jul 8, 2011 6:23 pm (PDT)

Looked through some of the posts and couldn't find anything germane to my question, which is:
Is it possible to use a Named Range in lieu of an actual stock symbol?

my Named Range would be a cell containing stock symbol.

e.g
getyahoohistory(Symbol) vs getyahoohistory("IBM")

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

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

Fri Jul 8, 2011 6:28 pm (PDT)

Sure. It's a user-defined function, so it can be used pretty much the same
way as a normal function -- literal, cell reference, or named range cell.

On Fri, Jul 8, 2011 at 5:38 PM, chj.2010 <chasjohn02@yahoo.com> wrote:

> Looked through some of the posts and couldn't find anything germane to my
> question, which is:
> Is it possible to use a Named Range in lieu of an actual stock symbol?
>
> my Named Range would be a cell containing stock symbol.
>
> e.g
> getyahoohistory(Symbol) vs getyahoohistory("IBM")
>

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

5a.: Re: Freeware TA add-on

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

Fri Jul 8, 2011 9:16 pm (PDT)

I just looked at this website..it doesn't appear to be free.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Check out: http://ta-lib.org/
>
> On Thu, Jul 7, 2011 at 6:39 PM, sergeh3 <sergeh3@...> wrote:
>
> >
> > does anyone know of an add-on for performing technical analysis via excel
> > (eg, Bollinger Bands, exponential moving averages, etc) that is truly
> > freeware (no trial-versions, etc)? any help would be appreciated, thanks a
> > million in advance.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
5b.: Re: Freeware TA add-on

Posted by: "james morlock" JimMorlock@optonline.net kagawonger

Fri Jul 8, 2011 9:28 pm (PDT)

There is a charge for the commercial version but the open source
versions are free.

http://ta-lib.org/hdr_dw.html

On Sat, Jul 9, 2011 at 12:08 AM, investor952 wrote:

I just looked at this website..it doesn't appear to be free.

--- In smf_addin@yahoogroups.com
<javascript:parent.wgMail.openComposeWindow('smf_addin@yahoogroups.com')>
, Randy Harmelink <rharmelink@...> wrote:
>
> Check out: http://ta-lib.org/ <http://ta-lib.org/>
> On Thu, Jul 7, 2011 at 6:39 PM, sergeh3 <sergeh3@...> wrote:
>>
>> does anyone know of an add-on for performing technical analysis via
>> excel (eg, Bollinger Bands, exponential moving averages, etc) that
>> is truly freeware (no trial-versions, etc)? any help would be
>> appreciated, thanks a million in advance.
>

<http://ta-lib.org/>
<http://docs.yahoo.com/info/terms/>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
5c.: Re: Freeware TA add-on

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

Fri Jul 8, 2011 9:47 pm (PDT)

Does this open source version work with Excel?

--- In smf_addin@yahoogroups.com, james morlock <JimMorlock@...> wrote:
>
>
> There is a charge for the commercial version but the open source
> versions are free.
>
> http://ta-lib.org/hdr_dw.html
>
> On Sat, Jul 9, 2011 at 12:08 AM, investor952 wrote:
>
> I just looked at this website..it doesn't appear to be free.
>
> --- In smf_addin@yahoogroups.com
> <javascript:parent.wgMail.openComposeWindow('smf_addin@yahoogroups.com')>
> , Randy Harmelink <rharmelink@> wrote:
> >
> > Check out: http://ta-lib.org/ <http://ta-lib.org/>
> > On Thu, Jul 7, 2011 at 6:39 PM, sergeh3 <sergeh3@> wrote:
> >>
> >> does anyone know of an add-on for performing technical analysis via
> >> excel (eg, Bollinger Bands, exponential moving averages, etc) that
> >> is truly freeware (no trial-versions, etc)? any help would be
> >> appreciated, thanks a million in advance.
> >
>
> <http://ta-lib.org/>
> <http://docs.yahoo.com/info/terms/>
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
5d.: Re: Freeware TA add-on

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

Sat Jul 9, 2011 12:37 am (PDT)

Of course. See:

http://finance.groups.yahoo.com/group/smf_addin/message/8806

--- In smf_addin@yahoogroups.com, "investor952" <investor952@...> wrote:
>
> Does this open source version work with Excel?

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

Create New Topic | Visit Your Group on the Web

Messages | Files | Photos | Polls

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

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

Sabtu, 09 Juli 2011

Messages In This Digest (15 Messages)

Messages

Posted by: "Rene Reyna" rr76012@yahoo.com rr76012

Fri Jul 8, 2011 8:16 am (PDT)

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

Fri Jul 8, 2011 8:58 am (PDT)

Posted by: "ilmostro" ilmostrobtw@gmail.com ilmostro

Fri Jul 8, 2011 12:56 pm (PDT)

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

Fri Jul 8, 2011 1:01 pm (PDT)

Posted by: "Bryan" ilmostrobtw@gmail.com ilmostro

Fri Jul 8, 2011 1:57 pm (PDT)

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

Fri Jul 8, 2011 3:02 pm (PDT)

Posted by: "Bryan" ilmostrobtw@gmail.com ilmostro

Fri Jul 8, 2011 3:10 pm (PDT)

Posted by: "bobsledproductions" JPeters3515@snet.net bobsledproductions

Fri Jul 8, 2011 1:24 pm (PDT)

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

Fri Jul 8, 2011 2:11 pm (PDT)

Posted by: "chj.2010" chasjohn02@yahoo.com chj.2010

Fri Jul 8, 2011 6:23 pm (PDT)

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

Fri Jul 8, 2011 6:28 pm (PDT)

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

Fri Jul 8, 2011 9:16 pm (PDT)

Posted by: "james morlock" JimMorlock@optonline.net kagawonger

Fri Jul 8, 2011 9:28 pm (PDT)

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

Fri Jul 8, 2011 9:47 pm (PDT)

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

Sat Jul 9, 2011 12:37 am (PDT)

Tidak ada komentar:

Posting Komentar

Followers

Blog Archive

About Me