Messages In This Digest (9 Messages)
- 1a.
- disabled macros From: David
- 1b.
- Re: disabled macros From: Randy Harmelink
- 2.
- Re: Ignore #value errors, data retrieval error &windows security mes From: Steven Rourk
- 3a.
- Re: Ignore #value errors, data retrieval error & windows security me From: Duckwhisperer
- 4a.
- Finviz Earnings Date From: Market Monk
- 4b.
- Re: Finviz Earnings Date From: Randy Harmelink
- 4c.
- Re: Finviz Earnings Date From: Market Monk
- 4d.
- Re: Finviz Earnings Date From: Fred Wright
- 4e.
- Re: Finviz Earnings Date From: Market Monk
Messages
- 1a.
-
disabled macros
Posted by: "David" dnicholas6@comcast.net dnicholas4967
Fri Aug 12, 2011 4:38 am (PDT)
Everytime I open my excel worksheet, I have to enable macros because the computer doesn't recognize the smf worksheet as a secure source of information. And, that if I do enable this data, I could possibly allowing some viruses to access my computer.
Now, I know this is a safe source but, how do I get my computer to accept this worksheet so I don't have to bother with this annoying error message.
Thanks, David
- 1b.
-
Re: disabled macros
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Aug 12, 2011 8:30 am (PDT)
You shouldn't need to enable macros. When an add-in is installed, all of its
macros are automatically enabled. It really HAS to be security approved once
installed. Otherwise, if you opened up a new workbook, and then added a
formula, you'd get a security message.
Have you checked to make sure your EXCEL workbook doesn't have its own
macros? Even if it has an empty module, you'd still get the message.
On Fri, Aug 12, 2011 at 4:37 AM, David <dnicholas6@comcast.net > wrote:
> Everytime I open my excel worksheet, I have to enable macros because the
> computer doesn't recognize the smf worksheet as a secure source of
> information. And, that if I do enable this data, I could possibly allowing
> some viruses to access my computer.
>
> Now, I know this is a safe source but, how do I get my computer to accept
> this worksheet so I don't have to bother with this annoying error message.
>
- 2.
-
Re: Ignore #value errors, data retrieval error &windows security mes
Posted by: "Steven Rourk" steven_rourk@hotmail.com steven_rourk
Fri Aug 12, 2011 6:55 am (PDT)
You can also use the ISERROR formula...
Mensaje enviado desde mi terminal BlackBerry® de Porta
-----Original Message-----
From: Randy Harmelink <rharmelink@gmail.com >
Date: Thu, 11 Aug 2011 19:59:47
To: <smf_addin@yahoogroups.com >
Subject: Re: [smf_addin] Re: Ignore #value errors, data retrieval error &
windows security message
Just retrieve the raw data in one row.
Then, in the next row, you'll need IF() statements to verify that what you're getting back is usable or not. For example, you might do:
=IF(D10="N/A",0,D10/10)
...so that you'll substitute a zero value instead of the "N/A". Then you just use the new row for your calculations, where the new row is either a copy of the "work" row, or a modified version that has the values you want to substitute if you're not getting something usable back.
Or, another example -- I do recall that one of the "edits" of the Rule #1 workbooks from the forum wanted to make sure that a P/E ratio wasn't so outrageous that it would skew the calculation. So, the raw P/E values were retrieved in the "work" row. In the row used for calculations, a max value of 50 was placed on it. That way, a P/E of 300 for one year wouldn't throw everything off-kilter. You could use whatever edit(s) you feel comfortable with.
And, as I noted, some of the "N/A" values for P/E might be because earnings were negative for that year, or for some year of a 5-year average. The question would be if you returned the P/E for 5 consecutive years and one was "N/A", what would you assign for the 5-year average.
Basically, a "work" range is just a way for you to edit the data, either for reasonableness or for actual value.
On Thu, Aug 11, 2011 at 12:49 PM, Duckwhisperer <duckwhispering@yahoo.com <mailto:duckwhispering@yahoo.com > > wrote:
--- In smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com > , Randy Harmelink <rharmelink@...> wrote:
>
> 1. You'll need to use a "work range" so that you can handle any
> unexpected data that gets returned. That is, return the raw data in one
> range (i.e. "work") and then create the calculation values from the range.
Can you give an example? Because I'm not used to working with excel and can't figure it out in my head.
Thanks.
--------------------- --------- ------
Yahoo! Groups Links
- 3a.
-
Re: Ignore #value errors, data retrieval error & windows security me
Posted by: "Duckwhisperer" duckwhispering@yahoo.com duckwhispering
Fri Aug 12, 2011 1:03 pm (PDT)
It worked, thanks!
- 4a.
-
Finviz Earnings Date
Posted by: "Market Monk" marketmonk777@yahoo.com marketmonk777
Fri Aug 12, 2011 3:33 pm (PDT)
Hi,
When I use this code I don't get the title "Earnings" from the Finviz table for GE (http://www.finviz.com/quote. )ashx?t=ge
=RCHGetTableCell("http://finviz. com/quote. "&"GE",""&5,ashx?t= "fullview- ticker",, ,,""&15)
I get the long string:
BMO = Before Market Open<br>AMC = After Market Close] offsetx=[10] offsety=[20] delay=[300]
How do I skip over that to get to "Earnings"?
Monk
- 4b.
-
Re: Finviz Earnings Date
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Aug 12, 2011 3:57 pm (PDT)
Sorry, you can't. The add-in parser isn't designed to handle their variation
of HTML.
It should be a fixed string -- why bother extracting it?
Have you tried just using the Finviz screener output instead of extracting
the data from the web page? For example:
=smfGetCSVFile("http://finviz. com/export. ")ashx?v=151& t=GE&c=1, 68
There an item in the "Links" area of the group with more detail on the
process.
On Fri, Aug 12, 2011 at 3:33 PM, Market Monk <marketmonk777@yahoo.com >wrote:
>
> When I use this code I don't get the title "Earnings" from the Finviz table
> for GE (http://www.finviz.com/quote. )ashx?t=ge
>
> =RCHGetTableCell("http://finviz. com/quote. ashx?t=
> "&"GE",""&5,"fullview- ticker",, ,,""&15)
>
> I get the long string:
> BMO = Before Market Open<br>AMC = After Market Close] offsetx=[10]
> offsety=[20] delay=[300]
>
> How do I skip over that to get to "Earnings"?
>
- 4c.
-
Re: Finviz Earnings Date
Posted by: "Market Monk" marketmonk777@yahoo.com marketmonk777
Fri Aug 12, 2011 4:12 pm (PDT)
Hi Randy,
Just playing around learning the various functions. I will have a look at the function you suggest.
Thanks,
Monk
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Sorry, you can't. The add-in parser isn't designed to handle their variation
> of HTML.
>
> It should be a fixed string -- why bother extracting it?
>
> Have you tried just using the Finviz screener output instead of extracting
> the data from the web page? For example:
>
> =smfGetCSVFile("http://finviz. com/export. ")ashx?v=151& t=GE&c=1, 68
>
> There an item in the "Links" area of the group with more detail on the
> process.
>
> On Fri, Aug 12, 2011 at 3:33 PM, Market Monk <marketmonk777@...>wrote:
>
> >
> > When I use this code I don't get the title "Earnings" from the Finviz table
> > for GE (http://www.finviz.com/quote. )ashx?t=ge
> >
> > =RCHGetTableCell("http://finviz. com/quote. ashx?t=
> > "&"GE",""&5,"fullview- ticker",, ,,""&15)
> >
> > I get the long string:
> > BMO = Before Market Open<br>AMC = After Market Close] offsetx=[10]
> > offsety=[20] delay=[300]
> >
> > How do I skip over that to get to "Earnings"?
> >
>
- 4d.
-
Re: Finviz Earnings Date
Posted by: "Fred Wright" fredwwright@yahoo.com fredwwright
Fri Aug 12, 2011 5:17 pm (PDT)
Monk,
I useÂ
=RCHGetTableCell("http://www.finviz. com/quote. "&ticker,1,"ashx?t= >Earnings" )
to get the finviz earnings data and it seems to work fine.Â
Fred
_____________________ _________ __
From: Market Monk <marketmonk777@yahoo.com >
To: smf_addin@yahoogroups.com
Sent: Friday, August 12, 2011 7:11 PM
Subject: [smf_addin] Re: Finviz Earnings Date
Â
Hi Randy,
Just playing around learning the various functions. I will have a look at the function you suggest.
Thanks,
Monk
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Sorry, you can't. The add-in parser isn't designed to handle their variation
> of HTML.
>
> It should be a fixed string -- why bother extracting it?
>
> Have you tried just using the Finviz screener output instead of extracting
> the data from the web page? For example:
>
> =smfGetCSVFile("http://finviz. com/export. ")ashx?v=151& t=GE&c=1, 68
>
> There an item in the "Links" area of the group with more detail on the
> process.
>
> On Fri, Aug 12, 2011 at 3:33 PM, Market Monk <marketmonk777@...>wrote:
>
> >
> > When I use this code I don't get the title "Earnings" from the Finviz table
> > for GE (http://www.finviz.com/quote. )ashx?t=ge
> >
> > =RCHGetTableCell("http://finviz. com/quote. ashx?t=
> > "&"GE",""&5,"fullview- ticker",, ,,""&15)
> >
> > I get the long string:
> > BMO = Before Market Open<br>AMC = After Market Close] offsetx=[10]
> > offsety=[20] delay=[300]
> >
> > How do I skip over that to get to "Earnings"?
> >
>
- 4e.
-
Re: Finviz Earnings Date
Posted by: "Market Monk" marketmonk777@yahoo.com marketmonk777
Fri Aug 12, 2011 5:54 pm (PDT)
Thanks, that worked.
Don't know how or why just yet, but it works.
--- In smf_addin@yahoogroups.com , Fred Wright <fredwwright@...> wrote:
>
> Monk,
>
> I useÂ
>
> =RCHGetTableCell("http://www.finviz. com/quote. "&ticker,1,"ashx?t= >Earnings" )
>
>
> to get the finviz earnings data and it seems to work fine.Â
>
>
> Fred
>
>
>
> _____________________ _________ __
> From: Market Monk <marketmonk777@...>
> To: smf_addin@yahoogroups.com
> Sent: Friday, August 12, 2011 7:11 PM
> Subject: [smf_addin] Re: Finviz Earnings Date
>
>
> Â
> Hi Randy,
>
> Just playing around learning the various functions. I will have a look at the function you suggest.
>
> Thanks,
> Monk
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > Sorry, you can't. The add-in parser isn't designed to handle their variation
> > of HTML.
> >
> > It should be a fixed string -- why bother extracting it?
> >
> > Have you tried just using the Finviz screener output instead of extracting
> > the data from the web page? For example:
> >
> > =smfGetCSVFile("http://finviz. com/export. ")ashx?v=151& t=GE&c=1, 68
> >
> > There an item in the "Links" area of the group with more detail on the
> > process.
> >
> > On Fri, Aug 12, 2011 at 3:33 PM, Market Monk <marketmonk777@>wrote:
> >
> > >
> > > When I use this code I don't get the title "Earnings" from the Finviz table
> > > for GE (http://www.finviz.com/quote. )ashx?t=ge
> > >
> > > =RCHGetTableCell("http://finviz. com/quote. ashx?t=
> > > "&"GE",""&5,"fullview- ticker",, ,,""&15)
> > >
> > > I get the long string:
> > > BMO = Before Market Open<br>AMC = After Market Close] offsetx=[10]
> > > offsety=[20] delay=[300]
> > >
> > > How do I skip over that to get to "Earnings"?
> > >
> >
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
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