Messages In This Digest (20 Messages)
- 1a.
- Re: 10Y EPS from MSN table From: antonvanas1989
- 1b.
- Re: 10Y EPS from MSN table From: antonvanas1989
- 1c.
- Re: 10Y EPS from MSN table From: Randy Harmelink
- 2a.
- Re: smfPrice by and between From: antonvanas1989
- 2b.
- Re: smfPrice by and between From: Randy Harmelink
- 2c.
- Re: smfPrice by and between From: antonvanas1989
- 2d.
- Re: smfPrice by and between From: Randy Harmelink
- 2e.
- Re: smfPrice by and between From: antonvanas1989
- 2f.
- Re: smfPrice by and between From: Randy Harmelink
- 2g.
- Re: smfPrice by and between From: antonvanas1989
- 3a.
- Re: How to call UDF RCHGetYahooHistory in an Excel Macro From: notkoushik
- 3b.
- Re: How to call UDF RCHGetYahooHistory in an Excel Macro From: Randy Harmelink
- 4a.
- cannot see addin in excel option From: umesh
- 4b.
- Re: cannot see addin in excel option From: Randy Harmelink
- 4c.
- Re: cannot see addin in excel option From: umesh parab
- 4d.
- Re: cannot see addin in excel option From: Randy Harmelink
- 4e.
- Re: cannot see addin in excel option From: umesh parab
- 4f.
- Re: cannot see addin in excel option From: Randy Harmelink
- 5a.
- Yearly Close From: ronmac17
- 5b.
- Re: Yearly Close From: Randy Harmelink
Messages
- 1a.
-
Re: 10Y EPS from MSN table
Posted by: "antonvanas1989" antonvanas1989@yahoo.com antonvanas1989
Sun Jan 8, 2012 7:53 am (PST)
Thnxs
--- In smf_addin@yahoogroups.com , "antonvanas1989" <antonvanas1989@...> wrote:
>
> Hi Randy,
> Im trying to get 10Y eps from data table from MSN web but can't get it fixed..
>
>
>
> http://moneycentral.msn.com/ investor/ invsub/results/ statemnt. aspx?lstStatemen t=10YearSummary& symbol=US% 3aKO&stmtView= Ann
>
>
> =RCHGetTableCell("http://moneycentral .msn.com/ "&Ticker; ?????investor/ invsub/results/ statemnt. aspx?lstStatemen t=Income& stmtView= Ann&Symbol=
>
> Dont know if i use the correct parameter..
>
>
> Anton
>
- 1b.
-
Re: 10Y EPS from MSN table
Posted by: "antonvanas1989" antonvanas1989@yahoo.com antonvanas1989
Sun Jan 8, 2012 10:13 am (PST)
Is there a last 10-Y EPS from Yahoo too?
--- In smf_addin@yahoogroups.com , "antonvanas1989" <antonvanas1989@...> wrote:
>
> Thnxs
>
> --- In smf_addin@yahoogroups.com , "antonvanas1989" <antonvanas1989@> wrote:
> >
> > Hi Randy,
> > Im trying to get 10Y eps from data table from MSN web but can't get it fixed..
> >
> >
> >
> > http://moneycentral.msn.com/ investor/ invsub/results/ statemnt. aspx?lstStatemen t=10YearSummary& symbol=US% 3aKO&stmtView= Ann
> >
> >
> > =RCHGetTableCell("http://moneycentral .msn.com/ "&Ticker; ?????investor/ invsub/results/ statemnt. aspx?lstStatemen t=Income& stmtView= Ann&Symbol=
> >
> > Dont know if i use the correct parameter..
> >
> >
> > Anton
> >
>
- 1c.
-
Re: 10Y EPS from MSN table
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Jan 8, 2012 10:16 am (PST)
Not that I'm aware of.
On Sun, Jan 8, 2012 at 11:13 AM, antonvanas1989 <antonvanas1989@yahoo.com >wrote:
> Is there a last 10-Y EPS from Yahoo too?
>
- 2a.
-
Re: smfPrice by and between
Posted by: "antonvanas1989" antonvanas1989@yahoo.com antonvanas1989
Sun Jan 8, 2012 8:55 am (PST)
Oke, How Yahoo handle's an 3-1 split then?
I assume that after the split the past data divided by 3?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Both functions only use adjusted prices. To me, the prices aren't
> comparable between or over periods without the adjustments. For example,
> suppose there was a 3-1 split mid-year.
>
> On Fri, Jan 6, 2012 at 6:13 AM, antonvanas1989 <antonvanas1989@...>wrote:
>
> >
> > I got a problem now but i can't fix it by myself.
> >
> > In my spreadsheet i uses Prices by dates:
> > Year low
> > Year high
> > Year end
> >
> > herefor i different formulas:
> > low =smfPricesBetween(Ticker;M3; M4;"06")
> > high =smfPricesBetween(Ticker;M3; M4;"04")
> > end =smfPricesByDates(Ticker;M4)
> >
> > The cells contain:
> > M3 = 01-01-10
> > M4 = 12-31-10
> >
> > I'm Europian but using English (U.S.) for Data format
> >
> > Now my problem is that i get the adjusted closed values insteed of the
> > correct; high, low and close values from Yahoo.
> >
> > Also tried [2010,12,31] , [Dec 31, 2010] , [12/31/2010] , [31-12-2010]
> > but i still get adj. close value.
> >
> > How can i solve this problem?
> >
>
- 2b.
-
Re: smfPrice by and between
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Jan 8, 2012 10:12 am (PST)
Yup. Whether a dividend or a split, they have adjusted closing prices for
all history, so that it will be compatible with all prices forward. Until
the next dividend or split, the closing prices and adjusted closing prices
for any given date will match.
It's one reason you can't keep adding current data to previously retrieved
historical data, unless you adjust the historical data yourself. I used to
do that -- it was a real pain.
On Sun, Jan 8, 2012 at 9:55 AM, antonvanas1989 <antonvanas1989@yahoo.com >wrote:
> Oke, How Yahoo handle's an 3-1 split then?
>
> I assume that after the split the past data divided by 3?
>
- 2c.
-
Re: smfPrice by and between
Posted by: "antonvanas1989" antonvanas1989@yahoo.com antonvanas1989
Sun Jan 8, 2012 10:30 am (PST)
But one problem is,
I can't use formulas as P/E then.. because the price is changed..
How do you go along with this??
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Yup. Whether a dividend or a split, they have adjusted closing prices for
> all history, so that it will be compatible with all prices forward. Until
> the next dividend or split, the closing prices and adjusted closing prices
> for any given date will match.
>
> It's one reason you can't keep adding current data to previously retrieved
> historical data, unless you adjust the historical data yourself. I used to
> do that -- it was a real pain.
>
> On Sun, Jan 8, 2012 at 9:55 AM, antonvanas1989 <antonvanas1989@...>wrote:
>
> > Oke, How Yahoo handle's an 3-1 split then?
> >
> > I assume that after the split the past data divided by 3?
> >
>
- 2d.
-
Re: smfPrice by and between
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Jan 8, 2012 11:18 am (PST)
Then you'll need to retrieve the historical quotes using the
RCHGetYahooHistory() statement.
I would think a bigger problem would be matching the date of the release of
the earnings amount. Not to mention which earnings number to use and which
number of shares to use...
Most people don't compute their own ratios because it's easier to retrieve
the published ones.
On Sun, Jan 8, 2012 at 11:30 AM, antonvanas1989 <antonvanas1989@yahoo.com >wrote:
>
> But one problem is,
>
> I can't use formulas as P/E then.. because the price is changed..
>
> How do you go along with this??
>
- 2e.
-
Re: smfPrice by and between
Posted by: "antonvanas1989" antonvanas1989@yahoo.com antonvanas1989
Sun Jan 8, 2012 2:30 pm (PST)
http://uk.advfn.com/p.php? pid=financials& btn=start_ date&mode= annual_reports& symbol=NYSE% 3AKO&start_ date=7
this is Statement of Ko from 2000 but if i use these data with the historical share price i could caluclate that wright??
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Then you'll need to retrieve the historical quotes using the
> RCHGetYahooHistory() statement.
>
> I would think a bigger problem would be matching the date of the release of
> the earnings amount. Not to mention which earnings number to use and which
> number of shares to use...
>
> Most people don't compute their own ratios because it's easier to retrieve
> the published ones.
>
> On Sun, Jan 8, 2012 at 11:30 AM, antonvanas1989 <antonvanas1989@...>wrote:
>
> >
> > But one problem is,
> >
> > I can't use formulas as P/E then.. because the price is changed..
> >
> > How do you go along with this??
> >
>
- 2f.
-
Re: smfPrice by and between
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Jan 8, 2012 2:35 pm (PST)
I can't say. I haven't tried it.
Why bother when they have the PE ratios on the same page?
On Sun, Jan 8, 2012 at 3:30 PM, antonvanas1989 <antonvanas1989@yahoo.com >wrote:
>
> http://uk.advfn.com/p.php? pid=financials& btn=start_ date&mode= annual_reports& symbol=NYSE% 3AKO&start_ date=7
>
> this is Statement of Ko from 2000 but if i use these data with the
> historical share price i could caluclate that wright??
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > Then you'll need to retrieve the historical quotes using the
> > RCHGetYahooHistory() statement.
>
- 2g.
-
Re: smfPrice by and between
Posted by: "antonvanas1989" antonvanas1989@yahoo.com antonvanas1989
Sun Jan 8, 2012 2:44 pm (PST)
true indeed, but not all formulas are on that page. P/S for example.
But i give it a try tomorrow.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I can't say. I haven't tried it.
>
> Why bother when they have the PE ratios on the same page?
>
> On Sun, Jan 8, 2012 at 3:30 PM, antonvanas1989 <antonvanas1989@...>wrote:
>
> >
> > http://uk.advfn.com/p.php? pid=financials& btn=start_ date&mode= annual_reports& symbol=NYSE% 3AKO&start_ date=7
> >
> > this is Statement of Ko from 2000 but if i use these data with the
> > historical share price i could caluclate that wright??
> >
> > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> > >
> > > Then you'll need to retrieve the historical quotes using the
> > > RCHGetYahooHistory() statement.
> >
>
- 3a.
-
Re: How to call UDF RCHGetYahooHistory in an Excel Macro
Posted by: "notkoushik" koushik@gmail.com notkoushik
Sun Jan 8, 2012 12:38 pm (PST)
Hi Randy,
Firstly, thank you for all the time you put in supporting this group. I am trying to update historical quotes from a specified start to end date (specified in cells in excelsheet). I found many examples where you use pDim1=DaysLength to extract data, but not many examples where you extract from a start date to end date (DaysLen is difficult to determine here).
An example VBA code looks something like this:
sub priceupdate()
Dim oCell as Range
Dim DaysLen as Integer
Set oCell=[c2]
'First I get the return the length of the extract using --
MsgBox Application.CountA(RCHGetYah ooHistory( "SPY", 2006, 6, 1, 2006, 7, 1, "d", "D", 1, 1, 1))
DaysLen= Application.CountA(RCHGetYah ooHistory( "SPY", 2006, 6, 1, 2006, 7, 1, "d", "D", 1, 1, 1))
'I get an error - invalid procedure call or arguement when calculating DaysLen
'I then want use the captured DaysLen as
Range(oCell.Offset(1, 0), oCell.Offset( DaysLen, 0)) = RCHGetYahooHistory( "SPY", 2006, 6, 1, 2006, 7, 1, "d", "D", 1, 1, 1)
end sub
I get an error - 'invalid procedure call or arguement' for DaysLen.
As you can see, I am a bit challenged using vba scripting, and am only tailoring the existing code to meet my needs. What is a good reference book to keep while vba coding?
Secondly, every time I open macro-enabled excel sheet, the addin files are refered with complete path 'C:\Program Files\SMF Add-In\RCH_Stock_Market_Functions .xla!'RCHGetYaho oHistory( ...) which are often stale locations.
I have to manually remove the complete path, keeping the function, which then calculates the results correctly referencing the addin library. Any tip to avoid this edit frequently?
Many Thanks,
Koushik
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Easiest to just do something like:
>
> Option Explicit
> Sub Test()
> Dim vData() As Variant
> vData = RCHGetYahooHistory("MMM", , , , , , , , , , , , 1000, 6)
> End Sub
>
> On Thu, Dec 29, 2011 at 5:22 PM, Tianhao Li <tianhao.li@...> wrote:
>
> >
> > However, is there anyway that I can assign the output of smf function to a
> > data array as I defined in below?
> >
> > Dim sData(1 To 1000, 1 To 6) As Variant
> >
> >
>
- 3b.
-
Re: How to call UDF RCHGetYahooHistory in an Excel Macro
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Jan 8, 2012 2:21 pm (PST)
On Sun, Jan 8, 2012 at 1:38 PM, notkoushik <koushik@gmail.com > wrote:
>
> Firstly, thank you for all the time you put in supporting this group. I am
> trying to update historical quotes from a specified start to end date
> (specified in cells in excelsheet). I found many examples where you use
> pDim1=DaysLength to extract data, but not many examples where you extract
> from a start date to end date (DaysLen is difficult to determine here).
>
Just make sure the pDim1 is large enough to hold the range of stocks you
need. For example, you could just subtract the begin date from the end date
and add 3. That will always make sure you won't lose any quotes.
As you can see, I am a bit challenged using vba scripting, and am only
> tailoring the existing code to meet my needs. What is a good reference book
> to keep while vba coding?
>
Can't help. I learned basic 43 years ago by reading the IBM reference
manual and programmer's guide from cover to cover. I learn most through
examples and trial and error, so I tend to have EXCEL generate macros on
how I am doing things, and use Google to get more detail on any process I'm
attempting.
Secondly, every time I open macro-enabled excel sheet, the addin files are
> refered with complete path 'C:\Program Files\SMF
> Add-In\RCH_Stock_Market_Functions .xla!'RCHGetYaho oHistory( ...) which are
> often stale locations.
> I have to manually remove the complete path, keeping the function, which
> then calculates the results correctly referencing the addin library. Any
> tip to avoid this edit frequently?
>
It's an EXCEL thing. As long as the location of the add-in is in a
different location when the workbook is saved and then opened, that problem
will occur. Check the "Location Errors" item in the "Links" area of the
group.
The add-in does have an smfFixLinks macro that should automatically fix
links, but only my personal copy has the most recent update. The beta
version of the add-in in the "Works in Progress" folder has a more advanced
copy than the normal version.
- 4a.
-
cannot see addin in excel option
Posted by: "umesh" umeshlp@yahoo.com umeshlp
Sun Jan 8, 2012 2:08 pm (PST)
I did copy 'RCH_Stock_Market_Functions. zip' in c:\Program files|SMF folder & extracted all files in same folder. I am using MS2007. I could not find this add-in in Excel options - Add-ins.
Need help.
- 4b.
-
Re: cannot see addin in excel option
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Jan 8, 2012 2:22 pm (PST)
You have to add it via the add-in manager, as described in the
documentation.
On Sun, Jan 8, 2012 at 2:02 PM, umesh <umeshlp@yahoo.com > wrote:
> I did copy 'RCH_Stock_Market_Functions. zip' in c:\Program files|SMF folder
> & extracted all files in same folder. I am using MS2007. I could not find
> this add-in in Excel options - Add-ins.
>
> Need help.
>
- 4c.
-
Re: cannot see addin in excel option
Posted by: "umesh parab" umeshlp@yahoo.com umeshlp
Sun Jan 8, 2012 4:38 pm (PST)
Can you please tell me the location of 'add-in manager?
--- On Sun, 1/8/12, Randy Harmelink <rharmelink@gmail.com > wrote:
From: Randy Harmelink <rharmelink@gmail.com >
Subject: Re: [smf_addin] cannot see addin in excel option
To: smf_addin@yahoogroups.com
Date: Sunday, January 8, 2012, 10:22 PM
You have to add it via the add-in manager, as described in the documentation.
On Sun, Jan 8, 2012 at 2:02 PM, umesh <umeshlp@yahoo.com > wrote:
I did copy 'RCH_Stock_Market_Functions. zip' in c:\Program files|SMF folder & extracted all files in same folder. I am using MS2007. I could not find this add-in in Excel options - Add-ins.
Need help.
- 4d.
-
Re: cannot see addin in excel option
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Jan 8, 2012 6:56 pm (PST)
Keyboard shortcut Alt+t+i
On Sun, Jan 8, 2012 at 5:38 PM, umesh parab <umeshlp@yahoo.com > wrote:
>
> Can you please tell me the location of 'add-in manager?
>
- 4e.
-
Re: cannot see addin in excel option
Posted by: "umesh parab" umeshlp@yahoo.com umeshlp
Sun Jan 8, 2012 8:35 pm (PST)
?????
--- On Mon, 1/9/12, Randy Harmelink <rharmelink@gmail.com > wrote:
From: Randy Harmelink <rharmelink@gmail.com >
Subject: Re: [smf_addin] cannot see addin in excel option
To: smf_addin@yahoogroups.com
Date: Monday, January 9, 2012, 2:56 AM
Keyboard shortcut Alt+t+i
On Sun, Jan 8, 2012 at 5:38 PM, umesh parab <umeshlp@yahoo.com > wrote:
Can you please tell me the location of 'add-in manager?
- 4f.
-
Re: cannot see addin in excel option
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Jan 8, 2012 8:38 pm (PST)
See:
http://office.microsoft. com/en-us/ help/enable- or-disable- add-ins-in- office-programs- HA010034127. aspx
On Sun, Jan 8, 2012 at 9:34 PM, umesh parab <umeshlp@yahoo.com > wrote:
>
> ?????
>
- 5a.
-
Yearly Close
Posted by: "ronmac17" ronmac17@yahoo.com ronmac17
Sun Jan 8, 2012 2:36 pm (PST)
I put "y" in the period input to get the yearly close for the 30 DJI stocks. It doesn't seem to work now. I thought the period input took d,w,m,and y. Is there another way get the yearly close as an array?
Thanks
- 5b.
-
Re: Yearly Close
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Jan 8, 2012 2:40 pm (PST)
Year is not an option provided by Yahoo for their historical quotes.
You can use the smfPricesByDates() function and provide it year-end dates
-- easy to create using the EOMONTH() function.
On Sun, Jan 8, 2012 at 3:36 PM, ronmac17 <ronmac17@yahoo.com > wrote:
> I put "y" in the period input to get the yearly close for the 30 DJI
> stocks. It doesn't seem to work now. I thought the period input took
> d,w,m,and y. Is there another way get the yearly close as an array?
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
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