6 New Messages
Digest #2774
3
Attention all members: PLEASE VOTE TO GET YAHOO GROUPS RETORED TO A by "Kermit W. Prather" kermitpra
Messages
Sun Sep 15, 2013 3:57 am (PDT) . Posted by:
"ben916770" ben916770
Hello Randy
Have followed the intro you have written for working with options data:
http://finance.groups.yahoo.com/group/smf_addin/message/17234
When I get to step 5 and copy the expression "=smfGetOptionQuotes($C9,D$7,,$B$3)" across cells "D9:F18" I do not get any options prices? Rather, i get the following text:
"Last Price Bid Price Ask Price"
I have installed the RCH add-in file and have been happily using the "simple" GetYahooQuotes for many years.
Have I missed a vital step?
Many thanks
Ben
Have followed the intro you have written for working with options data:
http://finance.
When I get to step 5 and copy the expression "=smfGetOption
"Last Price Bid Price Ask Price"
I have installed the RCH add-in file and have been happily using the "simple" GetYahooQuotes for many years.
Have I missed a vital step?
Many thanks
Ben
Sun Sep 15, 2013 4:01 am (PDT) . Posted by:
"ben916770" ben916770
Randy - I've spotted my error - am now getting Option prices.
Apologies for confusion.
Ben
--- In smf_addin@yahoogroups.com, "ben916770" <benjaminheaton@...> wrote:
>
> Hello Randy
>
> Have followed the intro you have written for working with options data:
> http://finance.groups.yahoo.com/group/smf_addin/message/17234
>
> When I get to step 5 and copy the expression "=smfGetOptionQuotes($C9,D$7,,$B$3)" across cells "D9:F18" I do not get any options prices? Rather, i get the following text:
>
> "Last Price Bid Price Ask Price"
>
> I have installed the RCH add-in file and have been happily using the "simple" GetYahooQuotes for many years.
>
> Have I missed a vital step?
>
> Many thanks
>
> Ben
>
Apologies for confusion.
Ben
--- In smf_addin@yahoogrou
>
> Hello Randy
>
> Have followed the intro you have written for working with options data:
> http://finance.
>
> When I get to step 5 and copy the expression "=smfGetOption
>
> "Last Price Bid Price Ask Price"
>
> I have installed the RCH add-in file and have been happily using the "simple" GetYahooQuotes for many years.
>
> Have I missed a vital step?
>
> Many thanks
>
> Ben
>
Sun Sep 15, 2013 8:46 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
What did you get in cells C9:C18, and what did you get when you first
entered the formula in cell D9?
On Sun, Sep 15, 2013 at 3:57 AM, ben916770 <benjaminheaton@btinternet.com>wrote:
>
> Have followed the intro you have written for working with options data:
> http://finance.groups.yahoo.com/group/smf_addin/message/17234
>
> When I get to step 5 and copy the expression
> "=smfGetOptionQuotes($C9,D$7,,$B$3)" across cells "D9:F18" I do not get any
> options prices? Rather, i get the following text:
>
> "Last Price Bid Price Ask Price"
>
> I have installed the RCH add-in file and have been happily using the
> "simple" GetYahooQuotes for many years.
>
> Have I missed a vital step?
>
entered the formula in cell D9?
On Sun, Sep 15, 2013 at 3:57 AM, ben916770 <benjaminheaton@
>
> Have followed the intro you have written for working with options data:
> http://finance.
>
> When I get to step 5 and copy the expression
> "=smfGetOption
> options prices? Rather, i get the following text:
>
> "Last Price Bid Price Ask Price"
>
> I have installed the RCH add-in file and have been happily using the
> "simple" GetYahooQuotes for many years.
>
> Have I missed a vital step?
>
Sun Sep 15, 2013 6:42 am (PDT) . Posted by:
manmohanbang
Hi,
I wanted to use the morning star data from key ratios and
valuation tabs. I didn't find any of these in the
'RCHGetElementN
to include these numbers?
Thanks,
Sun Sep 15, 2013 8:49 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
MorningStar has been changing all of their web pages to be dynamic. That
means the add-in functions can't get the data from those web pages, because
it extracts data from the source code of the web page.
However, you can grab their CSV file, by array-entering this formula over a
range:
=smfGetCSVFile("
http://financials.morningstar.com/ajax/exportKR2CSV.html?t=MMM")
...and then referring to that range of data for your desired data items.
On Sat, Sep 14, 2013 at 11:59 PM, <manmohanbang@yahoo.in> wrote:
> I wanted to use the morning star data from key ratios and valuation tabs.
> I didn't find any of these in the 'RCHGetElementNumber-Element-Definitions'
> Excel. Is there a plan to include these numbers?
>
means the add-in functions can't get the data from those web pages, because
it extracts data from the source code of the web page.
However, you can grab their CSV file, by array-entering this formula over a
range:
=smfGetCSVFile(
http://financials.
...and then referring to that range of data for your desired data items.
On Sat, Sep 14, 2013 at 11:59 PM, <manmohanbang@
> I wanted to use the morning star data from key ratios and valuation tabs.
> I didn't find any of these in the 'RCHGetElementN
> Excel. Is there a plan to include these numbers?
>
Sun Sep 15, 2013 10:27 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
In addition to being a member of this excellent group I moderate several
groups. I hate this new groups format. It is almost unusable.
If you are like me, you probably did not know we even had a vote in what we
like or dislike on Yahoo.
I think it is great they provide us a say so on changes. If we get enough to
vote maybe they will reverse the change
Attention all members: PLEASE go to this links and vote to have the new
groups format changed back to its previous version.
The first link has 44,946 votes already but more are needed to convince
Yahoo the new group format is not useable.
http://yahoo.
n-groups-format-
The second link will take you to more posting if you want to vote more than
once.
http://yahoo.
Thank you for voting,
Kermit Prather
Tidak ada komentar:
Posting Komentar