Rabu, 15 Februari 2012

[smf_addin] Digest Number 2115

Messages In This Digest (11 Messages)

Messages

1a.

elementnumbers  5052-5058  yahoo fund performance not working

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

Tue Feb 14, 2012 8:06 am (PST)



Hello Randy,

Element numbers 5052-5058, yahoo fund performance rank in category, are returning - n/a?

I am using your previous version addin. I don't know if this matters.

Do I need to replace or update anything to keep using yahoo fund elements?

Thank you.

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

Re: elementnumbers 5052-5058 yahoo fund performance not working

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

Tue Feb 14, 2012 8:11 am (PST)



If you're getting N/A, then that is the value that Yahoo is posting...

On Tue, Feb 14, 2012 at 9:06 AM, rr76012 <rr76012@yahoo.com> wrote:

>
> Element numbers 5052-5058, yahoo fund performance rank in category, are
> returning - n/a?
>
> I am using your previous version addin. I don't know if this matters.
>
> Do I need to replace or update anything to keep using yahoo fund elements?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2a.

Option Quote Put Help

Posted by: "KonfusedDesi" mohandesai@yahoo.com   mohandesai

Tue Feb 14, 2012 1:54 pm (PST)



What am doing wrong ?

When I enter

= smfGetOptionQuotes("SPY Sep 2012 $110 Call","l",,"OX")

I get the Call Price but when I replace Call with Put

=smfGetOptionQuotes("SPY Sep 2012 $110 Put","l",,"OX")

- it gives me Invalid Call/Put Indicator message

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

Re: Option Quote Put Help

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

Tue Feb 14, 2012 2:52 pm (PST)



The "OX" data source only works for calls. There is a brief indication of
that in the documentation. It was the best source I could find for the
Greeks on the calls, but I couldn't find a bookmarkable URL for the puts.

Depending on what other data items you're interested in, you can use "OX2"
or "OX3".

On Tue, Feb 14, 2012 at 2:54 PM, KonfusedDesi <mohandesai@yahoo.com> wrote:

> What am doing wrong ?
>
> When I enter
>
> = smfGetOptionQuotes("SPY Sep 2012 $110 Call","l",,"OX")
>
> I get the Call Price but when I replace Call with Put
>
> =smfGetOptionQuotes("SPY Sep 2012 $110 Put","l",,"OX")
>
> - it gives me Invalid Call/Put Indicator message
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
2c.

Re: Option Quote Put Help

Posted by: "KonfusedDesi" mohandesai@yahoo.com   mohandesai

Tue Feb 14, 2012 5:15 pm (PST)



Thanks for the clarification. I like 888options.com but don't know you to import that into Excel.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The "OX" data source only works for calls. There is a brief indication of
> that in the documentation. It was the best source I could find for the
> Greeks on the calls, but I couldn't find a bookmarkable URL for the puts.
>
> Depending on what other data items you're interested in, you can use "OX2"
> or "OX3".
>
> On Tue, Feb 14, 2012 at 2:54 PM, KonfusedDesi <mohandesai@...> wrote:
>
> > What am doing wrong ?
> >
> > When I enter
> >
> > = smfGetOptionQuotes("SPY Sep 2012 $110 Call","l",,"OX")
> >
> > I get the Call Price but when I replace Call with Put
> >
> > =smfGetOptionQuotes("SPY Sep 2012 $110 Put","l",,"OX")
> >
> > - it gives me Invalid Call/Put Indicator message
> >
>

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

Re: Option Quote Put Help

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

Tue Feb 14, 2012 5:47 pm (PST)



Hmmm. That may be usable...

On Tue, Feb 14, 2012 at 6:15 PM, KonfusedDesi <mohandesai@yahoo.com> wrote:

> Thanks for the clarification. I like 888options.com but don't know you
> to import that into Excel.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3a.

Google Docs version of Company Overview

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

Tue Feb 14, 2012 6:44 pm (PST)



Previously I created a Company Overview worksheet leveraging the addin, that is in the "files" section, but recently I was curious to know how far Google Docs has come, and whether the same type of workbook could be created in the Spreadsheet app. So I spent about 3-4 hours the other day, and got pretty close. If you are interested, take a look at the Company Overview spreadsheet that I created and published here:

https://docs.google.com/templates?q=company+overview&category=2&type=spreadsheets&sort=rating&view=public

I also put together a blog that detailed the steps here and how it was done (a little rough, but hopefully you get the point):

http://justspreadsheets.blogspot.com/2012/02/company-overview-google-docs-version.html

I know this doesn't exactly fit within Randy's group, so apologies if you view this as spam, not my intention. But, from my perspective if something similar to the addin could be built and delivered through a fully hosted solution like google docs, with nothing required to be installed on your desktop, and work on say mobile devices, and be localized, it could be quite powerful and useful.

At this point in time, I'm far from convinced that I would ever replace Excel with Google docs, but....there is something compelling about a no cost, no download, device independent solution.

Anyways, let me know your thoughts.....

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

Re: Google Docs version of Company Overview

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

Tue Feb 14, 2012 6:56 pm (PST)



At one point, my "Internet version" vision was to have a URL that could
create the equivalent of an SSG file. Then, no matter which spreadsheet
tool was used, all of the data would be available in a fixed location.

The problem is coming up with a file definition that has all data elements
defined.

Another option would be to create some form of XML file. Then, the tags can
be defined as needed, and the data is available to anything that wants to
use it.

In any case, the point would be to separate the tool from the data -- make
the data easily available independently of what is using the data.

On Tue, Feb 14, 2012 at 7:44 PM, bobsledproductions <JPeters3515@snet.net>wrote:

> Previously I created a Company Overview worksheet leveraging the addin,
> that is in the "files" section, but recently I was curious to know how far
> Google Docs has come, and whether the same type of workbook could be
> created in the Spreadsheet app. So I spent about 3-4 hours the other day,
> and got pretty close. If you are interested, take a look at the Company
> Overview spreadsheet that I created and published here:
>
>
> https://docs.google.com/templates?q=company+overview&category=2&type=spreadsheets&sort=rating&view=public
>
> I also put together a blog that detailed the steps here and how it was
> done (a little rough, but hopefully you get the point):
>
>
> http://justspreadsheets.blogspot.com/2012/02/company-overview-google-docs-version.html
>
> I know this doesn't exactly fit within Randy's group, so apologies if you
> view this as spam, not my intention. But, from my perspective if something
> similar to the addin could be built and delivered through a fully hosted
> solution like google docs, with nothing required to be installed on your
> desktop, and work on say mobile devices, and be localized, it could be
> quite powerful and useful.
>
> At this point in time, I'm far from convinced that I would ever replace
> Excel with Google docs, but....there is something compelling about a no
> cost, no download, device independent solution.
>
> Anyways, let me know your thoughts.....
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4a.

Re: Morningstar Stock Type & Stock Style

Posted by: "V. Shankar" tarakayan@yahoo.com   tarakayan

Tue Feb 14, 2012 7:30 pm (PST)



I am able to see data for individual stocks, one at a time, but doesn't work using an array ....{RCHGetElementNumber(a2:a10,b1:e1)}.

>________________________________
> From: V. Shankar <tarakayan@yahoo.com>
>To: "smf_addin@yahoogroups.com" <smf_addin@yahoogroups.com>
>Sent: Tuesday, January 31, 2012 2:13 PM
>Subject: Re: [smf_addin] Re: Morningstar Stock Type & Stock Style
>
>
>It seems to be working...I am able to get results using elements: 878,877,879,880?
>
>
>
>
>>________________________________
>> From: Randy H <rharmelink@gmail.com>
>>To: smf_addin@yahoogroups.com
>>Sent: Monday, January 30, 2012 9:15 PM
>>Subject: [smf_addin] Re: Morningstar Stock Type & Stock Style
>>
>>
>> 
>>Unfortunately, the add-in can't extract data from that page, because the data isn't within the source code of the web page. MorningStar is
starting to dynamically generate a lot of their data web pages.
>>
>>
>>On Mon, Jan 30, 2012 at 3:44 AM, V. Shankar <tarakayan@yahoo.com> wrote:
>>
>>
>>>
>>>http://quote.morningstar.com/stock/s.aspx?t=AAPL 
>>>
>>>
>>>
>>>I was looking at some of the morningstar examples for MF style %s.  
>>>
>>>
>>>How do we extract the stock profile details like sector, industry, stock type, stock style from morningstar?
>>>
>>>
>>>Sector 
>>>Technology
>>>Industry 
>>>Computer Systems
>>>Stock Type 
>>>Cyclical
>>>Employees 
>>>63,300
>>>Fiscal Year Ends 
>>>September
>>>Stock Style 
>>>Large Growth
>>>
>>>
>>>
>>
>>
>>
>>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
4b.

Re: Morningstar Stock Type & Stock Style

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

Tue Feb 14, 2012 8:06 pm (PST)



There is no array-entered version of the formula to get multiple tickers
and/or multiple element numbers. There would be no advantage in doing so,
since each data item would need to be retrieved individually anyway.

On Tue, Feb 14, 2012 at 8:29 PM, V. Shankar <tarakayan@yahoo.com> wrote:

>
> I am able to see data for individual stocks, one at a time, but doesn't
> work using an array ....{RCHGetElementNumber(a2:a10,b1:e1)}.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
4c.

Re: Morningstar Stock Type & Stock Style

Posted by: "V. Shankar" tarakayan@yahoo.com   tarakayan

Wed Feb 15, 2012 12:17 am (PST)



Ok..thanks.

>________________________________
> From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Wednesday, February 15, 2012 9:36 AM
>Subject: Re: [smf_addin] Re: Morningstar Stock Type & Stock Style
>
>
> 
>There is no array-entered version of the formula to get multiple tickers and/or multiple element numbers. There would be no advantage in doing so, since each data item would need to be retrieved individually anyway.
>
>
>On Tue, Feb 14, 2012 at 8:29 PM, V. Shankar <tarakayan@yahoo.com> wrote:
>
>
>>
>>I am able to see data for individual stocks, one at a time, but doesn't work using an array ....{RCHGetElementNumber(a2:a10,b1:e1)}.
>>
>
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
Recent Activity
Visit Your Group
New business?

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! News

Odd News

You won't believe

it, but it's true

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 02.45

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)