Messages In This Digest (9 Messages)
- 1a.
- Is there any hope in getting the SMF Add-ins To Work on Excel for th From: Bob
- 1b.
- Re: Is there any hope in getting the SMF Add-ins To Work on Excel fo From: Randy Harmelink
- 2a.
- OnLive Desktop for the iPad From: broberts1745
- 2b.
- Re: OnLive Desktop for the iPad From: Randy Harmelink
- 3a.
- Re: S&P 500 Total Return History? From: pharnsbe
- 4a.
- How to get historical prices & % change for many tickers for first 1 From: learning2win1
- 4b.
- Re: How to get historical prices & % change for many tickers for fir From: Randy Harmelink
- 4c.
- Re: How to get historical prices & % change for many tickers for fir From: learning2win1
- 4d.
- Re: How to get historical prices & % change for many tickers for fir From: Randy Harmelink
Messages
- 1a.
-
Is there any hope in getting the SMF Add-ins To Work on Excel for th
Posted by: "Bob" jamesrwhite@gmail.com james_r_white
Sun Feb 26, 2012 3:59 am (PST)
Just curious. This looks handy, but the function calls just don't work on my Mac running Excel Version X under Mac OS X Version 10.6.8 on a dual Quad Core Intel Xenon processor.
- 1b.
-
Re: Is there any hope in getting the SMF Add-ins To Work on Excel fo
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Feb 26, 2012 4:01 am (PST)
No, sorry. It uses Windows DLLs for Internet access. Some have run it under
a Window environment on the Mac, but I know almost nothing about Macs, so
couldn't explain that in any more detail.
On Sun, Feb 26, 2012 at 4:30 AM, Bob <jamesrwhite@gmail.com > wrote:
> Just curious. This looks handy, but the function calls just don't work on
> my Mac running Excel Version X under Mac OS X Version 10.6.8 on a dual Quad
> Core Intel Xenon processor.
>
- 2a.
-
OnLive Desktop for the iPad
Posted by: "broberts1745" broberts1745@yahoo.com broberts1745
Sun Feb 26, 2012 2:29 pm (PST)
There is an app called OnLive Desktop, which allows users to open word, excel, powerpoint etc. on their iPad. I have not had a chance to use the app and was wondering if anyone has been successful in using the SMF_addin with this iPad app.
If so, is there something special needed to make it work?
- 2b.
-
Re: OnLive Desktop for the iPad
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Feb 26, 2012 2:44 pm (PST)
The add-in uses Windows link libraries, so I doubt it's going to work under
a different operating environment.
On Sun, Feb 26, 2012 at 3:29 PM, broberts1745 <broberts1745@yahoo.com >wrote:
> There is an app called OnLive Desktop, which allows users to open word,
> excel, powerpoint etc. on their iPad. I have not had a chance to use the
> app and was wondering if anyone has been successful in using the SMF_addin
> with this iPad app.
>
> If so, is there something special needed to make it work?
>
- 3a.
-
Re: S&P 500 Total Return History?
Posted by: "pharnsbe" harnsberger@gmail.com pharnsbe
Sun Feb 26, 2012 5:38 pm (PST)
Bloomberg and other similar providers have the "total return index", which most fund managers benchmark against.
http://www.bloomberg.com/quote/ SPXT:IND#
http://www.wikinvest.com/index/ (SPXTR)S%26P_500_ Total_Return_ INDEX_
I've searched for this as well and so far the only place I can find is S&P itself...
http://www.standardandpoors. com/indices/ sp-500/en/ us/?indexId= spusa-500- usduf--p- us-l--
Yahoo has a ticker but no historical data. I'm guessing S&P isn't letting providers give the data away.
http://finance.yahoo.com/ q?s=%5EPXTY
If anyone has found another source I'd be interested to hear about it. We usually just use adjusted VFINX as a proxy.
- 4a.
-
How to get historical prices & % change for many tickers for first 1
Posted by: "learning2win1" learning2win1@yahoo.com learning2win1
Mon Feb 27, 2012 1:04 am (PST)
Hi,
I have all Worlds ETF's in Row B1:Z1 and last 100 trading days in A2:A103. I want to extract adjusted closing prices for all ETF's last 100 days. How can I do this, because after reading documentation I get blank days (non trading days) which affects my calculation when I try to get % change (todays close divided by yesterday close - 1 to get % change).
This is what I do and get stuck:
If I use =today() in cell A1. Use =YEAR(A1) in B1, =MONTH(A1) in C1, =DAY(A1) in D1 and then link B1, C1, D1 to formula
'=RCHGetYahooHistory("IBM",B1, C1,D1,B1, C1,D1,,"A" ,0)
then in one row below link =A1-1 in cell A2 to calculate previous day.
and repeat the process again.
What I found that it will also give blanks for non trading days.
Please help!
- 4b.
-
Re: How to get historical prices & % change for many tickers for fir
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Feb 27, 2012 1:13 am (PST)
Oh, man, are you making it difficult for yourself. What you want is so easy
to do.
Just array-enter this in the range B2:B103:
=RCHGetYahooHistory(B1,,,,,, ,,"A",0)
...and then copy it to columns C:Z. Each range will contain the most recent
adjust closing prices.
If you want the trading dates in column A, then array-enter this for range
A2:A103:
=RCHGetYahooHistory(B1,,,,,, ,,"D",0)
At least that's what I assume you're trying to do. It's hard to tell
because you said you have tickers in cells B1:Z1, and then say you have
dates in cells B1:D1?
You don't want to retrieve the data day by day -- that will take you over
100 times as long to get the data.
On Mon, Feb 27, 2012 at 1:57 AM, learning2win1 <learning2win1@yahoo.com >wrote:
>
> I have all Worlds ETF's in Row B1:Z1 and last 100 trading days in A2:A103.
> I want to extract adjusted closing prices for all ETF's last 100 days. How
> can I do this, because after reading documentation I get blank days (non
> trading days) which affects my calculation when I try to get % change
> (todays close divided by yesterday close - 1 to get % change).
>
> This is what I do and get stuck:
> If I use =today() in cell A1. Use =YEAR(A1) in B1, =MONTH(A1) in C1,
> =DAY(A1) in D1 and then link B1, C1, D1 to formula
>
> '=RCHGetYahooHistory("IBM",B1, C1,D1,B1, C1,D1,,"A" ,0)
>
> then in one row below link =A1-1 in cell A2 to calculate previous day.
> and repeat the process again.
>
> What I found that it will also give blanks for non trading days.
>
> Please help!
>
- 4c.
-
Re: How to get historical prices & % change for many tickers for fir
Posted by: "learning2win1" learning2win1@yahoo.com learning2win1
Mon Feb 27, 2012 1:35 am (PST)
This is what I did.
My symbols are from B1:Z, so I highlighted all cells from B2:Z103, then press "=" and paste "RCHGetYahooHistory(B1,,,,,, ,,"A",0)" , then control+shift+ enter and only updates from B2:B103.
Then I highlighted B2:B103 and tried to drag towards column Z, but a pop up message comes up: "You can not change part of array"
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Oh, man, are you making it difficult for yourself. What you want is so easy
> to do.
>
> Just array-enter this in the range B2:B103:
>
> =RCHGetYahooHistory(B1,,,,,, ,,"A",0)
>
> ...and then copy it to columns C:Z. Each range will contain the most recent
> adjust closing prices.
>
> If you want the trading dates in column A, then array-enter this for range
> A2:A103:
>
> =RCHGetYahooHistory(B1,,,,,, ,,"D",0)
>
> At least that's what I assume you're trying to do. It's hard to tell
> because you said you have tickers in cells B1:Z1, and then say you have
> dates in cells B1:D1?
>
> You don't want to retrieve the data day by day -- that will take you over
> 100 times as long to get the data.
>
> On Mon, Feb 27, 2012 at 1:57 AM, learning2win1 <learning2win1@...>wrote:
>
> >
> > I have all Worlds ETF's in Row B1:Z1 and last 100 trading days in A2:A103.
> > I want to extract adjusted closing prices for all ETF's last 100 days. How
> > can I do this, because after reading documentation I get blank days (non
> > trading days) which affects my calculation when I try to get % change
> > (todays close divided by yesterday close - 1 to get % change).
> >
> > This is what I do and get stuck:
> > If I use =today() in cell A1. Use =YEAR(A1) in B1, =MONTH(A1) in C1,
> > =DAY(A1) in D1 and then link B1, C1, D1 to formula
> >
> > '=RCHGetYahooHistory("IBM",B1, C1,D1,B1, C1,D1,,"A" ,0)
> >
> > then in one row below link =A1-1 in cell A2 to calculate previous day.
> > and repeat the process again.
> >
> > What I found that it will also give blanks for non trading days.
> >
> > Please help!
> >
>
- 4d.
-
Re: How to get historical prices & % change for many tickers for fir
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Feb 27, 2012 1:44 am (PST)
As I said, you want to enter that formula over the range B2:B103, NOT
B2:Z103. The formula is only getting one column of information -- as you
saw. THEN copy THAT range to the other columns. Easiest way to do the copy
is to highlight B2:Z103 and hit Ctrl+R to copy right-ward. But AFTER you've
create the values in the B2:B103 range.
Note that you'll need to delete the entire B2:Z103 range before you can
restart the process. Because, as you've already found out, you can't change
part of an array.
On Mon, Feb 27, 2012 at 2:35 AM, learning2win1 <learning2win1@yahoo.com >wrote:
> This is what I did.
> My symbols are from B1:Z, so I highlighted all cells from B2:Z103, then
> press "=" and paste "RCHGetYahooHistory(B1,,,,,, ,,"A",0)" , then
> control+shift+enter and only updates from B2:B103.
>
> Then I highlighted B2:B103 and tried to drag towards column Z, but a pop
> up message comes up: "You can not change part of array"
>
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