Kamis, 23 Mei 2013

[smf_addin] Digest Number 2627

7 New Messages

Digest #2627
1a
Re: A Question about getting the Delta by "bob_15861586" bob_15861586
2a
Re: Yahoo Prices problem by "antonvanas1989" antonvanas1989
2b
Re: Yahoo Prices problem by "Michael Blauer" mjblauer
2c
Re: Yahoo Prices problem by "Randy Harmelink" rharmelink
3
5a
Re: getting Zacks data by "zbgb952" zbgb952

Messages

Wed May 22, 2013 9:37 am (PDT) . Posted by:

"bob_15861586" bob_15861586


Thank you very much.

Bob

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I'm saying you can't get SPX index option quotes with the
> smfGetOptionQuotes() function, but you can get them with your own
> RCHGetTableCell() functions. For example:
>
> =RCHGetTableCell("
> https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?Range=0&lstMarket=0&ChainType=3&lstMonths=12/31/2013;3&Symbol=SPX
> ",-5,"SPXQ^^131231C01700000")
>
> On Mon, May 20, 2013 at 9:08 AM, bob_15861586 <bob_15861586@...>wrote:
>
> >
> > Thanks for the response. I am a bit confused by your answer. Are you
> > saying that I cannot get the Delta using Excel functions?
> >
>

Wed May 22, 2013 10:15 am (PDT) . Posted by:

"antonvanas1989" antonvanas1989

I would like to create my own ratios for value a company.

So for P/E i need Price and Earnings from past years.

i get the eps from years back from Advfn, and i get prices with:
low/high = SMFPricesBetween()
close = SMFPricesByDates()
close (not adjusted) = RCHGetYahooHistory()

Now is those data fully adjusted for dividends etc.

But when i want to know what the P/E ratio was last 10 years i need the non adjusted prices, otherwise all those adjustment etc would make a wrong view of the "real" P/E ratio at the time. Do you understand where my problem is?

Same with all other ratios using "Historical Prices" for calculations. (Like Price/Bookvalue).

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I'm not sure where you're stuck?
>
> On Tue, May 21, 2013 at 7:12 AM, antonvanas1989 <antonvanas1989@...>wrote:
>
> > Can you help me out please Randy? i am really stuck at this problem.
> >
>

Wed May 22, 2013 11:12 am (PDT) . Posted by:

"Michael Blauer" mjblauer

Great thanks!!!

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of antonvanas1989
Sent: Wednesday, May 22, 2013 1:15 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Yahoo Prices problem

I would like to create my own ratios for value a company.

So for P/E i need Price and Earnings from past years.

i get the eps from years back from Advfn, and i get prices with:
low/high = SMFPricesBetween()
close = SMFPricesByDates()
close (not adjusted) = RCHGetYahooHistory()

Now is those data fully adjusted for dividends etc.

But when i want to know what the P/E ratio was last 10 years i need the non adjusted prices, otherwise all those adjustment etc would make a wrong view of the "real" P/E ratio at the time. Do you understand where my problem is?

Same with all other ratios using "Historical Prices" for calculations. (Like Price/Bookvalue).

--- In smf_addin@yahoogroups.com<mailto:smf_addin%40yahoogroups.com>, Randy Harmelink <rharmelink@...> wrote:
>
> I'm not sure where you're stuck?
>
> On Tue, May 21, 2013 at 7:12 AM, antonvanas1989 <antonvanas1989@...>wrote:
>
> > Can you help me out please Randy? i am really stuck at this problem.
> >
>

Wed May 22, 2013 11:15 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Right. So you would need to use RCHGetYahooHistory() to get the unadjusted
prices. So where is the problem?

On Wed, May 22, 2013 at 10:15 AM, antonvanas1989
<antonvanas1989@yahoo.com>wrote:

> I would like to create my own ratios for value a company.
>
> So for P/E i need Price and Earnings from past years.
>
> i get the eps from years back from Advfn, and i get prices with:
> low/high = SMFPricesBetween()
> close = SMFPricesByDates()
> close (not adjusted) = RCHGetYahooHistory()
>
> Now is those data fully adjusted for dividends etc.
>
> But when i want to know what the P/E ratio was last 10 years i need the
> non adjusted prices, otherwise all those adjustment etc would make a wrong
> view of the "real" P/E ratio at the time. Do you understand where my
> problem is?
>
> Same with all other ratios using "Historical Prices" for calculations.
> (Like Price/Bookvalue).
>

Wed May 22, 2013 12:32 pm (PDT) . Posted by:

"zbgb952" zbgb952

and i get a blank white page when i try to go to zacks.com

looks like they locked me out for some reason

Wed May 22, 2013 2:20 pm (PDT) . Posted by:

"james morlock" kagawonger


In Firefox, try navigating to: View > ToolBars > Yahoo Toolbar

Then click on the + symbol and add add a custom app which links you to
http://groups.yahoo.com/.

On Wed, May 22, 2013 at 2:45 AM, zbgb952 wrote:

Mine seems to have disappeared starting yesterday. I use Firefox 20
with Windows 7. Where did it go? Anyone know? How do I get it back?

<javascript:parent.wgMail.openComposeWindow('ygroupsnotifications@yahoogroups.com')>

Wed May 22, 2013 9:05 pm (PDT) . Posted by:

"zbgb952" zbgb952

not doing anything different than what i've done in the past. Also..they have sent me no message. I just get a blank webpage for www.zacks.com .

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> When it works, are you doing a large number of requests? Is Zacks
> "throttling&quot; you for some reason?
>
> On Tue, May 21, 2013 at 10:22 AM, zbgb952 <mb0329@...> wrote:
>
> > I take that back. Zacks.com stopped working for me again today. I just get
> > a blank page when I try to go to their website and I get 'error&#39; in my
> > spreadsheets.
> >
>

Tidak ada komentar:

Posting Komentar