Senin, 20 Februari 2012

[smf_addin] Digest Number 2122

Messages In This Digest (7 Messages)

Messages

1a.

Re: MSN Money 10 year summary sometimes out of chrono. order

Posted by: "gsr2588" generivard@gmail.com   gsr2588

Sun Feb 19, 2012 8:30 pm (PST)



Ok, that makes sense. Until such time as MSN fixes this, I should be able to write a macro or something to align the data properly in cases when the ending month of the fiscal period changes in the 10 year summaries. For the Balance Sheet and Income Statements, they are sorting by month and then year (descending) rather than by year descending. It's a relatively new issue, they displayed these properly a few months ago.

Thanks again

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Element #153 comes from the 10-year summary table of the ratios, so it *is*
> in the correct order. However, the 10-year summary of amounts appears to be
> in a different order. It's dates are not defined as elements (as they
> SHOULD be redundant to those on the ratios table). But you could retrieve
> the dates from the amounts table and line them up...
>
> On Sun, Feb 19, 2012 at 12:54 PM, gsr2588 <generivard@...> wrote:
>
> >
> > Thanks for the quick reply. So the strange part is that they present the
> > data correctly within each row, the rows are just out of order. In JOY's
> > case, Date FY1 (param 153) shows as 10/11, and Sales FY1 (param 293) shows
> > as 1.19B. But yet based on relative position, it seems that FY1 should
> > have showed up as 11/03 (to align with the 1.19B). So it doesn't seem
> > sorting could fix anything, as there would be no way to know when FY1 is
> > lined up correctly, and when it wasn't. Does that make any sense ?
> > Thanks...
> >
>

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

Re: smfPricesBetween() as Array Formula

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

Sun Feb 19, 2012 8:37 pm (PST)



If the 52-week hi and lo are sufficient, you can get all of the data in one
shot from FinViz via the screener. Although its high and low are
percentages relative to the current price.

The Zacks screener can also export a single file with 52-week highs and
lows.

But you could take those export files, load them into EXCEL, and then use
some type of lookup function in EXCEL to extract them for your ticker
symbols.

BTW, I use the array functions quite a bit and don't need to change them
often -- you just have them refer to external values. So, to change the
output, you just change the external values and you never need to touch the
array formula.

On Sun, Feb 19, 2012 at 9:26 PM, rjemery7 <rjemery@gmail.com> wrote:

> As Randy pointed out, that function only works for one ticker symbol at a
> time, or one row at a time, which also needs to be defined as an array
> formula. If I have nearly 1000 rows in a worksheet, that means each of
> those rows would need to be defined as separate arrays.
>
> The hassle comes when the worksheet/table is updated. Some symbols
> disappear, new ones are added or a new column may be added. That now means
> I would have to break nearly 1000 arrays and re-establish them one by one,
> an onerous task most likely needed to be performed on a weekly basis.
>
> I already suffer under the 200 ticker Yahoo limitation for
> RCHGetYahooQuotes(). I never liked array formulas because of the need to
> change the array frequently. I just may go back to single cell updates,
> even if that means 10,000+ function calls and several minutes of recalc
> time, solely for the larger convenience of table updates.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
3a.

IWM Option Quote

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

Sun Feb 19, 2012 9:34 pm (PST)



Hi Randy,

I have difficulty in getting this IWM Option quote

http://finance.yahoo.com/q?s=IWM120330P00075000

The code I used is as follows :-

=smfGetYahooOptionQuote("IWM","P",DATE(2012,3,30),75,"b")

Also, I use this quote for individual entry (non array).

Thanks

Alan

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

Re: IWM Option Quote

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

Sun Feb 19, 2012 9:37 pm (PST)



Not sure what to tell you. I just cut and pasted your formula and it
returned $0.82, which is the amount I see on the Yahoo web page (this is
the web page it extracts it from):

http://finance.yahoo.com/q/op?s=IWM&m=2012-03

What result are you seeing?

On Sun, Feb 19, 2012 at 9:59 PM, alankc_mok <alankc_mok@yahoo.com> wrote:

>
> I have difficulty in getting this IWM Option quote
>
> http://finance.yahoo.com/q?s=IWM120330P00075000
>
> The code I used is as follows :-
>
> =smfGetYahooOptionQuote("IWM","P",DATE(2012,3,30),75,"b")
>
> Also, I use this quote for individual entry (non array).
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4a.

Re: Historical Price Comparison Workbook - Google docs version

Posted by: "Pete A" optionzz@gmail.com   option2z

Sun Feb 19, 2012 11:03 pm (PST)



Thanks Don,

Did you mean to put a password on it? Would like to learn how you did what you did.

Pete A

--- In smf_addin@yahoogroups.com, "dguillett1" <dguillett1@...> wrote:
>
> Some of you might like this which uses Yahoo and excel external query. Opening date is set to today. Change either date as desired, select interval, select adjusted close or actual close. To chart total or individual stock,click on the symbol in the title bar.
> I have just added the line chart for each page to compare only comparable shortest period, as desired. Let me know if questions.
>
> Don Guillett
> SalesAid Software
> dguillett1@...
>
> From: Kermit W. Prather
> Sent: Sunday, February 19, 2012 9:45 AM
> To: smf_addin@yahoogroups.com
> Subject: RE: [smf_addin] Historical Price Comparison Workbook - Google docs version
>
>
> Very nice, any chance you might convert the spreadsheet to use the
> SMF-Addin? Then share it with the group.
>
> In 2010 I created a trading strategy using High Yield dividend stocks and
> published it in early 2011.
>
> I found trading the high yield stocks based on my trading strategy a lot
> more profitable than a buy & hold and capturing the dividends. But then I am
> a short term trader.
>
> It is interesting that you use CMO in your blog example, as it is one of the
> final 14 stocks used backtesting in my trading strategy.
>
> Kermit
>
> -----Original Message-----
> From: mailto:smf_addin%40yahoogroups.com [mailto:mailto:smf_addin%40yahoogroups.com] On Behalf
> Of bobsledproductions
> Sent: Saturday, February 18, 2012 5:54 PM
> To: mailto:smf_addin%40yahoogroups.com
> Subject: [smf_addin] Historical Price Comparison Workbook - Google docs
> version
>
> If you're interested I put together a simple historical price comparison
> workbook in google docs. Search for the template here:
>
> https://docs.google.com/templates?q=historical+price+comparison&type=spreads
> heets&sort=hottest&view=public
>
> I also blogged about the steps in creating the sheet here:
>
> http://justspreadsheets.blogspot.com/2012/02/charting-dividend-stocks.html
>
> Within the workbook I created a simple chart comparison between stocks with
> and without reinvested dividends. Far too many charts just show pricing
> data, and if you invest in high yielding stocks as I do, the charts you get
> don't do them justice.
>
> ------------------------------------
>
> Yahoo! Groups Links
>

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

Is there an Option chains with greek add ons yet solved?

Posted by: "millerd1_smf" millerd1_airmail_net@yahoo.com   millerd1_smf

Sun Feb 19, 2012 11:41 pm (PST)



I word searched for options, chain and/or greeks and see post as late as Nov 30 lastyear. I tried the Optionxpress URL and it needs a user login. Has my search I missed any resolution? Has a either a chain or the greeks been method been derived from a public site?

Thanks for a reply Randy
Millerd1

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

Re: Is there an Option chains with greek add ons yet solved?

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

Mon Feb 20, 2012 12:01 am (PST)



Still no luck on getting greeks for puts from OX.

However, check the latest version of the add-in in the "Works in Progress"
folder. I just last week added a new function to get data from
888options.com, so it can get greeks for both calls and puts. Updated
documentation for the new functionality is in that folder as well. If you
use the smfGetOptionQuotes() function, the source code for 888options.comis "8".

However, you do have to manually get a quote from the web site first before
using the add-in, so that it creates the proper security cookie.
888options.com uses ivolatility.com as their data source, displaying the
chains in a frame.

And, the frame with the iVolatility data also had the implied and
historical volatility data that has been asked about several times in the
past, so I added some data codes for the retrieval of all of those items as
well. For example:

=smfGet888OptionQuote("IWM",,,,"hv10c")

...would get the current value of the 10-day historical volatility of "IWM".

On Mon, Feb 20, 2012 at 12:41 AM, millerd1_smf <
millerd1_airmail_net@yahoo.com> wrote:

> I word searched for options, chain and/or greeks and see post as late as
> Nov 30 lastyear. I tried the Optionxpress URL and it needs a user login.
> Has my search I missed any resolution? Has a either a chain or the greeks
> been method been derived from a public site?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
Recent Activity
Visit Your Group
Yahoo! News

Fashion News

What's the word on

fashion and style?

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

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 02.08

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)