15 New Messages
Digest #2867
Messages
Thu Nov 21, 2013 5:48 am (PST) . Posted by:
"flangeneral" flangeneral
Hi,
=RCHGetTableCell("http://finance.yahoo.com/bonds/composite_bond_rates", 1,">Municipal Bonds",">20yr AAA", ">20YR AA")
I have used this to retrieve the 20 AA Comp Bond Rate from Yahoo for a long time. Last week it started returning an error. When I went to the Yahoo website, it showed different mortgage rates. Does anyone know where I can retrieve the 20 AA Comp Bond Rate.
=RCHGetTableCell(
I have used this to retrieve the 20 AA Comp Bond Rate from Yahoo for a long time. Last week it started returning an error. When I went to the Yahoo website, it showed different mortgage rates. Does anyone know where I can retrieve the 20 AA Comp Bond Rate.
Thu Nov 21, 2013 7:07 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Is this what you need?
=RCHGetTableCell("http://finance.yahoo.com/bonds/composite_bond_rates?pt=2",
1,">Municipal Bonds",">20yr AAA", ">20YR AA")
Yahoo has really futzed their finance pages up.
On Thu, Nov 21, 2013 at 6:48 AM, flangeneral <jefff@rogers.com> wrote:
>
> =RCHGetTableCell("http://finance.yahoo.com/bonds/composite_bond_rates",
> 1,">Municipal Bonds",">20yr AAA", ">20YR AA")
>
> I have used this to retrieve the 20 AA Comp Bond Rate from Yahoo for a
> long time. Last week it started returning an error. When I went to the
> Yahoo website, it showed different mortgage rates. Does anyone know where I
> can retrieve the 20 AA Comp Bond Rate.
>
=RCHGetTableCell(
1,">
Yahoo has really futzed their finance pages up.
On Thu, Nov 21, 2013 at 6:48 AM, flangeneral <jefff@rogers.
>
> =RCHGetTableCell(
> 1,">
>
> I have used this to retrieve the 20 AA Comp Bond Rate from Yahoo for a
> long time. Last week it started returning an error. When I went to the
> Yahoo website, it showed different mortgage rates. Does anyone know where I
> can retrieve the 20 AA Comp Bond Rate.
>
Thu Nov 21, 2013 7:39 am (PST) . Posted by:
"flangeneral" flangeneral
Randy,
Perfect, as usual. Thank you very much.
--- In smf_addin@yahoogrou
>
> Is this what you need?
>
> =RCHGetTableCell(
> 1,">
>
> Yahoo has really futzed their finance pages up.
>
> On Thu, Nov 21, 2013 at 6:48 AM, flangeneral <jefff@..
>
> >
> > =RCHGetTableCell(
> > 1,">
> >
> > I have used this to retrieve the 20 AA Comp Bond Rate from Yahoo for a
> > long time. Last week it started returning an error. When I went to the
> > Yahoo website, it showed different mortgage rates. Does anyone know where I
> > can retrieve the 20 AA Comp Bond Rate.
> >
>
Thu Nov 21, 2013 6:58 am (PST) . Posted by:
"v1das" v1das
--- In smf_addin@yahoogrou
>
> Just found a download and tutorial on Power Pivot:
>
> http://powerpivotsd
>
> I'll be trying this out.
>
> Garry
>
PowerPivot is extremely powerful add in for Excel 2010. With Excel 2013 it is not add in anymore, but it is built in. I am working on developing investment tracking application with Excel and PowerPivot: http://PortfolioSli
Idea is that if I have transaction list and if I have stock quote history, I can calculate your portfolio value at any point in time. And I can make a lot of useful reports.
Regards,
Thu Nov 21, 2013 7:12 am (PST) . Posted by:
"ridgebacksexcel" ridgebacksexcel
Does anyone here know why AAPL is not showing in the 10-Y Financials on GuruFocus.com? It says "cached" and then displays a trial membership.
All the other stocks I track seem to display fine.
All the other stocks I track seem to display fine.
Thu Nov 21, 2013 7:39 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Have you tried viewing it with your browser? When I go to 10-year
financials on AAPL, it says it requires a premium membership. It's either a
temporary glitch, or you guys have been using the pages so much, they
decided to put it under the premium membership umbrella (i.e. just the
first of many to go that route)...
Only time will tell which.
On Thu, Nov 21, 2013 at 8:06 AM, ridgebacksexcel <tmallen2@bellsouth.net>wrote:
> Does anyone here know why AAPL is not showing in the 10-Y Financials on
> GuruFocus.com? It says "cached" and then displays a trial membership.
>
> All the other stocks I track seem to display fine.
>
financials on AAPL, it says it requires a premium membership. It's either a
temporary glitch, or you guys have been using the pages so much, they
decided to put it under the premium membership umbrella (i.e. just the
first of many to go that route)...
Only time will tell which.
On Thu, Nov 21, 2013 at 8:06 AM, ridgebacksexcel <tmallen2@bellsouth.
> Does anyone here know why AAPL is not showing in the 10-Y Financials on
> GuruFocus.com? It says "cached" and then displays a trial membership.
>
> All the other stocks I track seem to display fine.
>
Thu Nov 21, 2013 11:25 am (PST) . Posted by:
"ridgebacksexcel" ridgebacksexcel
Yes I viewed it in my browser. I get the same thing. Hopefully it is temporary or I need to program another site for all my financials. :(
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Have you tried viewing it with your browser? When I go to 10-year
> financials on AAPL, it says it requires a premium membership. It's either a
> temporary glitch, or you guys have been using the pages so much, they
> decided to put it under the premium membership umbrella (i.e. just the
> first of many to go that route)...
>
> Only time will tell which.
>
>
> On Thu, Nov 21, 2013 at 8:06 AM, ridgebacksexcel <tmallen2@...>wrote:
>
> > Does anyone here know why AAPL is not showing in the 10-Y Financials on
> > GuruFocus.com? It says "cached" and then displays a trial membership.
> >
> > All the other stocks I track seem to display fine.
> >
>
--- In smf_addin@yahoogrou
>
> Have you tried viewing it with your browser? When I go to 10-year
> financials on AAPL, it says it requires a premium membership. It's either a
> temporary glitch, or you guys have been using the pages so much, they
> decided to put it under the premium membership umbrella (i.e. just the
> first of many to go that route)...
>
> Only time will tell which.
>
>
> On Thu, Nov 21, 2013 at 8:06 AM, ridgebacksexcel <tmallen2@
>
> > Does anyone here know why AAPL is not showing in the 10-Y Financials on
> > GuruFocus.com? It says "cached" and then displays a trial membership.
> >
> > All the other stocks I track seem to display fine.
> >
>
Thu Nov 21, 2013 4:05 pm (PST) . Posted by:
hamishthedenizen
I've only seen it on AAPL so far, no problem on other stocks. Are folks getting it for other tickers?
---In smf_addin@yahoogroups.com, <tmallen2@...> wrote:
Yes I viewed it in my browser. I get the same thing. Hopefully it is temporary or I need to program another site for all my financials. :(
--- In smf_addin@yahoogroups.com mailto:smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Have you tried viewing it with your browser? When I go to 10-year
> financials on AAPL, it says it requires a premium membership. It's either a
> temporary glitch, or you guys have been using the pages so much, they
> decided to put it under the premium membership umbrella (i.e. just the
> first of many to go that route)...
>
> Only time will tell which.
>
>
> On Thu, Nov 21, 2013 at 8:06 AM, ridgebacksexcel <tmallen2@...>wrote:
>
> > Does anyone here know why AAPL is not showing in the 10-Y Financials on
> > GuruFocus.com? It says "cached" and then displays a trial membership.
> >
> > All the other stocks I track seem to display fine.
> >
>
---In smf_addin@yahoogrou
Yes I viewed it in my browser. I get the same thing. Hopefully it is temporary or I need to program another site for all my financials. :(
--- In smf_addin@yahoogrou
>
> Have you tried viewing it with your browser? When I go to 10-year
> financials on AAPL, it says it requires a premium membership. It's either a
> temporary glitch, or you guys have been using the pages so much, they
> decided to put it under the premium membership umbrella (i.e. just the
> first of many to go that route)...
>
> Only time will tell which.
>
>
> On Thu, Nov 21, 2013 at 8:06 AM, ridgebacksexcel <tmallen2@
>
> > Does anyone here know why AAPL is not showing in the 10-Y Financials on
> > GuruFocus.com? It says "cached" and then displays a trial membership.
> >
> > All the other stocks I track seem to display fine.
> >
>
Thu Nov 21, 2013 8:12 am (PST) . Posted by:
almondtree
LOL, IT starts bright and early at 6 pm on the 28th Black FRIDAY
Thu Nov 21, 2013 3:12 pm (PST) . Posted by:
tnmc77
Many thanks.
Shashank
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Why would you even *care* about any volume numbers of QQQ? The volume doesn't mean anything, because the prices of an ETF aren't driven by supply and demand. Plus, the creation and redemption units wouldn't be included in it.
I would think you'd use the volume from ^IXIC instead. Isn't it a composite volume of the underlying equities? What would it mean if a volume analysis of ^IXIC indicated something different than QQQ?
Also, IMO, on a normal equity, the average per day would be more useful than total weekly volume. You wouldn't want any type of volume analysis to be affected by a 20% drop in volume because there were only 4 trading days in the week. I wonder if they adjust the average for half-day trading days? Probably not.
In any case, I don't have any easy solution to your problem. Just issues. Sorry. :(
The best method would probably be to retrieve the daily data and convert it into weekly data yourself.
On Wed, Nov 13, 2013 at 4:32 PM, tn mc <tnmc77@... mailto:tnmc77@...> wrote:
How do I get total weekly volume of QQQ. One that I get from yahoo appears to be an average volume per day during any given week. That means that one has to multiply it with 5 (or 4 if there is a holiday during the week) to get total weekly volume.
Shashank
---In smf_addin@yahoogrou
Why would you even *care* about any volume numbers of QQQ? The volume doesn't mean anything, because the prices of an ETF aren't driven by supply and demand. Plus, the creation and redemption units wouldn't be included in it.
I would think you'd use the volume from ^IXIC instead. Isn't it a composite volume of the underlying equities? What would it mean if a volume analysis of ^IXIC indicated something different than QQQ?
Also, IMO, on a normal equity, the average per day would be more useful than total weekly volume. You wouldn't want any type of volume analysis to be affected by a 20% drop in volume because there were only 4 trading days in the week. I wonder if they adjust the average for half-day trading days? Probably not.
In any case, I don't have any easy solution to your problem. Just issues. Sorry. :(
The best method would probably be to retrieve the daily data and convert it into weekly data yourself.
On Wed, Nov 13, 2013 at 4:32 PM, tn mc <tnmc77@.
How do I get total weekly volume of QQQ. One that I get from yahoo appears to be an average volume per day during any given week. That means that one has to multiply it with 5 (or 4 if there is a holiday during the week) to get total weekly volume.
Thu Nov 21, 2013 8:45 pm (PST) . Posted by:
jsmetank74
Randy, I would like to get "% change" from whale wisdom. Do you think it's possible or does the URL problem affect all fields on this site?
http://whalewisdom.com/stock/mmm
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Can't get them from that site, sorry. They don't have "bookmarkable" URLs.
On Wed, Jun 5, 2013 at 2:26 PM, r r <student.umich1000@... mailto:student.umich1000@...> wrote:
Thank you for your reply. Can you please advise on what function I can use to download the 13F data? the website i plan on using is http://whalewisdom.com/ http://whalewisdom.com/. Thanks.
http://whalewisdom.
---In smf_addin@yahoogrou
Can't get them from that site, sorry. They don't have "bookmarkable&
On Wed, Jun 5, 2013 at 2:26 PM, r r <student.
Thank you for your reply. Can you please advise on what function I can use to download the 13F data? the website i plan on using is http://whalewisdom.
Thu Nov 21, 2013 9:19 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Easy-Peasy. That URL is fine:
=RCHGetTableCell("http://whalewisdom.com/stock/mmm",1,">Percent Change")
On Thu, Nov 21, 2013 at 9:45 PM, <jsmetank74@hotmail.com> wrote:
> Randy, I would like to get "% change" from whale wisdom. Do you think
> it's possible or does the URL problem affect all fields on this site?
>
> http://whalewisdom.com/stock/mmm
>
=RCHGetTableCell(
On Thu, Nov 21, 2013 at 9:45 PM, <jsmetank74@hotmail.
> Randy, I would like to get "% change" from whale wisdom. Do you think
> it's possible or does the URL problem affect all fields on this site?
>
> http://whalewisdom.
>
Thu Nov 21, 2013 9:39 pm (PST) . Posted by:
jsmetank74
You never cease to amaze me Randy. THANK YOU
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Easy-Peasy. That URL is fine:
=RCHGetTableCell("http://whalewisdom.com/stock/mmm http://whalewisdom.com/stock/mmm",1,">Percent Change")
On Thu, Nov 21, 2013 at 9:45 PM, <jsmetank74@... mailto:jsmetank74@...> wrote:
Randy, I would like to get "% change" from whale wisdom. Do you think it's possible or does the URL problem affect all fields on this site?
http://whalewisdom.com/stock/mmm http://whalewisdom.com/stock/mmm
---In smf_addin@yahoogrou
Easy-Peasy. That URL is fine:
=RCHGetTableCell(
On Thu, Nov 21, 2013 at 9:45 PM, <jsmetank74@
Randy, I would like to get "% change" from whale wisdom. Do you think it's possible or does the URL problem affect all fields on this site?
http://whalewisdom.
Thu Nov 21, 2013 9:17 pm (PST) . Posted by:
rick_pearson21
I have been trying to get company descriptions for many companies and I am finding many that just come thru as NA
most of them come thru fine, so it is clearly not my RCH version etc.
below is a list of some that come thru as NA
is there any other way to download company descriptions ?
maybe with tablecell etc ?
please help me ! somewhat urgent ! thanks to everyone !!
BHP HDB PEP CSCO SNP LFC AMX AMOV ITUB UBS DCM BBDO BBD GM TXN FDX PRU KMB PSX ASR CHU CM TEVA
most of them come thru fine, so it is clearly not my RCH version etc.
below is a list of some that come thru as NA
is there any other way to download company descriptions ?
maybe with tablecell etc ?
please help me ! somewhat urgent ! thanks to everyone !!
BHP HDB PEP CSCO SNP LFC AMX AMOV ITUB UBS DCM BBDO BBD GM TXN FDX PRU KMB PSX ASR CHU CM TEVA
Thu Nov 21, 2013 9:30 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
"NA" is what MSN is posting...at least for the two I looked at -- BHP and
PEP. Probably a temporary glitch.
Would a different source help? How about the business summary from Yahoo?
=smfGetTagContent(" http://finance.yahoo.com/q/pr?s=BHP ","p",1,">Business
Summary")
...or the company profile from MorningStar:
=smfstrExtr(smfGetTagContent("
http://quotes.morningstar.com/stock/c-company-profile?t=BHP
","div",1),"/>","~")
On Thu, Nov 21, 2013 at 10:04 PM, <rick.pearson@pearsoninvestment.com>wrote:
>
> I have been trying to get company descriptions for many companies and I am
> finding many that just come thru as NA
>
> most of them come thru fine, so it is clearly not my RCH version etc.
>
> below is a list of some that come thru as NA
>
> is there any other way to download company descriptions ?
>
> maybe with tablecell etc ?
>
> please help me ! somewhat urgent ! thanks to everyone !!
>
> BHP HDB PEP CSCO SNP LFC AMX AMOV ITUB UBS DCM BBDO BBD GM
> TXN FDX PRU KMB PSX ASR CHU CM TEVA
>
PEP. Probably a temporary glitch.
Would a different source help? How about the business summary from Yahoo?
=smfGetTagContent(
Summary"
...or the company profile from MorningStar:
=smfstrExtr(
http://quotes.
","
On Thu, Nov 21, 2013 at 10:04 PM, <rick.pearson@
>
> I have been trying to get company descriptions for many companies and I am
> finding many that just come thru as NA
>
> most of them come thru fine, so it is clearly not my RCH version etc.
>
> below is a list of some that come thru as NA
>
> is there any other way to download company descriptions ?
>
> maybe with tablecell etc ?
>
> please help me ! somewhat urgent ! thanks to everyone !!
>
> BHP HDB PEP CSCO SNP LFC AMX AMOV ITUB UBS DCM BBDO BBD GM
> TXN FDX PRU KMB PSX ASR CHU CM TEVA
>
Tidak ada komentar:
Posting Komentar