Messages In This Digest (10 Messages)
- 1a.
- Re: Historical Prices From: Ron Spruell
- 2a.
- Getting website link from Yahoo and Msn From: antonvanas1989
- 2b.
- Getting website link from Yahoo and Msn From: antonvanas1989
- 2c.
- Re: Getting website link from Yahoo and Msn From: Randy Harmelink
- 3.
- Fwd: From: Won-Jae Lee
- 4a.
- Future Stock Price Calculations From: confederate_yankee1965
- 4b.
- Re: Future Stock Price Calculations From: Randy Harmelink
- 4c.
- Re: Future Stock Price Calculations From: confederate_yankee1965
- 4d.
- Re: Future Stock Price Calculations From: Randy Harmelink
- 4e.
- Re: Future Stock Price Calculations From: confederate_yankee1965
Messages
- 1a.
-
Re: Historical Prices
Posted by: "Ron Spruell" hashky@yahoo.com hashky
Thu Jun 14, 2012 2:16 am (PDT)
From the Files > Documentation. Randy also has a Template in
Files > Templates and Examples >
smfPricesByDates Folder.
>____________________ _________ ___
> From: NicholasDavid <nicholasdavid@comcast.net >
>To: smf addin <smf_addin@yahoogroups.com >
>Sent: Wednesday, June 13, 2012 6:38 PM
>Subject: Re: [smf_addin] Historical Prices
>
>
>
>where do you find the code or syntax use between ()
>
>>___________________ _________ ____
>From: "Randy Harmelink" <rharmelink@gmail.com >
>To: "smf addin" <smf_addin@yahoogroups.com >
>Sent: Thursday, June 7, 2012 10:50:24 AM
>Subject: Re: [smf_addin] Historical Prices
>
>
>I typically use the smfPricesByDates() function for that type of thing.
>
>
>On Thu, Jun 7, 2012 at 6:56 AM, ufdn16 <ufdn16@yahoo.com > wrote:
>
>How can I access a stock's price as of a given date.
>>
>>Actually, I want a couple of columns in my excel worksheet that gives the performance over the last 30 days, the last 60 days, ....etc.
>>
>>Can you help me with this. Thanks, David
>>
>
>
>
>
- 2a.
-
Getting website link from Yahoo and Msn
Posted by: "antonvanas1989" antonvanas1989@yahoo.com antonvanas1989
Thu Jun 14, 2012 12:25 pm (PDT)
Randy,
I'm trying to get the website weblink from Msn and Yahoo but i can't get it right.
Example Advfn: =RCHGetTableCell("http://www.advfn. com/p.php? "&Quarter!C3;pid=financials& symbol= 1;"WWW A")
These are the websites where Yahoo en Msn show their weblink:
http://finance.yahoo.com/ q/pr?s=KO+ Profile
http://investing.money.msn. com/investments/ company-report? symbol=ko
- 2b.
-
Getting website link from Yahoo and Msn
Posted by: "antonvanas1989" antonvanas1989@yahoo.com antonvanas1989
Thu Jun 14, 2012 1:38 pm (PDT)
Randy,
I'm trying to get the website weblink from Msn and Yahoo but i can't get it right.
Example Advfn: =RCHGetTableCell("http://www.advfn. com/p.php? "&Quarter!C3;pid=financials& symbol= 1;"WWW A")
These are the websites where Yahoo en Msn show their weblink:
http://finance.yahoo.com/ q/pr?s=KO+ Profile
http://investing.money.msn. com/investments/ company-report? symbol=ko
- 2c.
-
Re: Getting website link from Yahoo and Msn
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Jun 14, 2012 1:55 pm (PDT)
Try:
=smfGetTagContent("http://finance. yahoo.com/ ","a",1,"Website:q/pr?s=KO ")
=smfStrExtr(RCHGetWebData( "
http://investing.money.msn. ","Fax:com/investments/ company-report? symbol=ko
",200),"href=""","""")
On Thu, Jun 14, 2012 at 12:25 PM, antonvanas1989
<antonvanas1989@yahoo.com >wrote:
>
> I'm trying to get the website weblink from Msn and Yahoo but i can't get
> it right.
>
> Example Advfn: =RCHGetTableCell("
> http://www.advfn.com/p.php? "&Quarter!C3;pid=financials& symbol= 1;"WWW A")
>
>
> These are the websites where Yahoo en Msn show their weblink:
> http://finance.yahoo.com/ q/pr?s=KO+ Profile
> http://investing.money.msn. com/investments/ company-report? symbol=ko
>
- 3.
-
Fwd:
Posted by: "Won-Jae Lee" jay_lee2037@yahoo.com jay_lee2037
Thu Jun 14, 2012 5:53 pm (PDT)
wow this is pretty awesome you should give it a look http://www.business15panews. net/work/ ?read=8997991
- 4a.
-
Future Stock Price Calculations
Posted by: "confederate_yankee1965" cyankee65@gmail.com confederate_yankee1965
Thu Jun 14, 2012 6:26 pm (PDT)
Can any of your function help calculate the future price of a stock? I found a website that shows one way of doing it, but, I am not sure any of your functions provide the needed information.
This is the website:
http://philtown.typepad.com/ frequently_ asked_question/ 2007/05/how_ do_i_set_ up.html
Then again, you might have it and I just missed the documentation.
- 4b.
-
Re: Future Stock Price Calculations
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Jun 14, 2012 6:39 pm (PDT)
A version of the Rule #1 price is already defined as element #15012, as
such:
Case "Rule #1 MOS Price"
n1 = RCHGetElementNumber(pTicker, 99) ' 5-Year High P/E
n2 = RCHGetElementNumber(pTicker, 102) ' 5-Year Low P/E
n3 = RCHGetElementNumber(pTicker, 44) ' Current EPS
n4 = RCHGetElementNumber(pTicker, 442) ' 5-Year Projected
Growth Rate
If n1 > 50 Then n1 = 50
n5 = FV(n4, 10, 0, -n3)
n6 = PV(0.15, 10, 0, -n5 * (n1 + n2) / 2) / 2
RCHSpecialExtraction = n6
So, you could just do:
=RCHGetElementNumber("IBM",15012)
Unfortunately, MSN has a lot of companies with "NA" for the 5-year high and
low P/E because of 2008, so the Rule #1 MOS Price gets an error in the
calculation.
On Thu, Jun 14, 2012 at 6:26 PM, confederate_yankee1965 <cyankee65@gmail. com
> wrote:
> Can any of your function help calculate the future price of a stock? I
> found a website that shows one way of doing it, but, I am not sure any of
> your functions provide the needed information.
>
> This is the website:
>
> http://philtown.typepad.com/ frequently_ asked_question/ 2007/05/how_ do_i_set_ up.html
>
> Then again, you might have it and I just missed the documentation.
>
- 4c.
-
Re: Future Stock Price Calculations
Posted by: "confederate_yankee1965" cyankee65@gmail.com confederate_yankee1965
Thu Jun 14, 2012 6:55 pm (PDT)
Damn, I checked and it didn't work with any of the stocks I am tracking.
Trying to get a rough idea of what the future stock price might be. The excel trend function only calculates a straight line trend. But most stocks do not trend in a straight line.
I stumbled upon the "Rule #1" method but, ya, 2008 messes with that.
Suggestions?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> A version of the Rule #1 price is already defined as element #15012, as
> such:
>
> Case "Rule #1 MOS Price"
> n1 = RCHGetElementNumber(pTicker, 99) ' 5-Year High P/E
> n2 = RCHGetElementNumber(pTicker, 102) ' 5-Year Low P/E
> n3 = RCHGetElementNumber(pTicker, 44) ' Current EPS
> n4 = RCHGetElementNumber(pTicker, 442) ' 5-Year Projected
> Growth Rate
> If n1 > 50 Then n1 = 50
> n5 = FV(n4, 10, 0, -n3)
> n6 = PV(0.15, 10, 0, -n5 * (n1 + n2) / 2) / 2
> RCHSpecialExtraction = n6
>
> So, you could just do:
>
> =RCHGetElementNumber("IBM",15012)
>
> Unfortunately, MSN has a lot of companies with "NA" for the 5-year high and
> low P/E because of 2008, so the Rule #1 MOS Price gets an error in the
> calculation.
>
> On Thu, Jun 14, 2012 at 6:26 PM, confederate_yankee1965 <cyankee65@. ..
> > wrote:
>
> > Can any of your function help calculate the future price of a stock? I
> > found a website that shows one way of doing it, but, I am not sure any of
> > your functions provide the needed information.
> >
> > This is the website:
> >
> > http://philtown.typepad.com/ frequently_ asked_question/ 2007/05/how_ do_i_set_ up.html
> >
> > Then again, you might have it and I just missed the documentation.
> >
>
- 4d.
-
Re: Future Stock Price Calculations
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Jun 14, 2012 7:23 pm (PDT)
What I've considered doing is going to AdvFN and getting the high and low
PE for each of the last 10 years, and averaging those, as a replacement for
the MSN 5-year values.
On Thu, Jun 14, 2012 at 6:52 PM, confederate_yankee1965 <cyankee65@gmail. com
> wrote:
> Damn, I checked and it didn't work with any of the stocks I am tracking.
>
> Trying to get a rough idea of what the future stock price might be. The
> excel trend function only calculates a straight line trend. But most
> stocks do not trend in a straight line.
>
> I stumbled upon the "Rule #1" method but, ya, 2008 messes with that.
>
> Suggestions?
>
- 4e.
-
Re: Future Stock Price Calculations
Posted by: "confederate_yankee1965" cyankee65@gmail.com confederate_yankee1965
Thu Jun 14, 2012 8:08 pm (PDT)
I would be interested. At the moment, I discovered the Growth function in Excel, but, I have to get so much price history for each stock (15 of them) that Excel is slowed down whenever calculations run. Something like what you are thinking about would help with that issue. (I hope) :)
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> What I've considered doing is going to AdvFN and getting the high and low
> PE for each of the last 10 years, and averaging those, as a replacement for
> the MSN 5-year values.
>
> On Thu, Jun 14, 2012 at 6:52 PM, confederate_yankee1965 <cyankee65@. ..
> > wrote:
>
> > Damn, I checked and it didn't work with any of the stocks I am tracking.
> >
> > Trying to get a rough idea of what the future stock price might be. The
> > excel trend function only calculates a straight line trend. But most
> > stocks do not trend in a straight line.
> >
> > I stumbled upon the "Rule #1" method but, ya, 2008 messes with that.
> >
> > Suggestions?
> >
>
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