12 New Messages
Digest #2695
Messages
Mon Jul 15, 2013 2:02 am (PDT) . Posted by:
"sri yanto" sri.yanto
SMFupdatedownload table
when you use this smf, i recomend not to break the consecutive row that randy has made,
it's will make your link won't update..
maybe it's sound silly for whom have ever occur this condition dan have solve it.
thank you after all
when you use this smf, i recomend not to break the consecutive row that randy has made,
it's will make your link won't update..
maybe it's sound silly for whom have ever occur this condition dan have solve it.
thank you after all
Mon Jul 15, 2013 2:18 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Just means you aren't logged in with IE. The add-in uses EXCEL/Microsoft
libraries for accessing the Internet, so uses the same engine as IE. So you
need to create the security cookies in IE by either logging in via the
EXCEL Web Query dialog (preferred) or with IE.
On Mon, Jul 15, 2013 at 12:31 AM, Lawrence <lawrence.leesh@gmail.com > wrote:
> Thanks Randy. This worked. Only problem is that advfn offers 5 years of
> data if you sign in and only 3 years if you don't. When you put formulae in
> excel, it won't retrieve the additional two years.
>
libraries for accessing the Internet, so uses the same engine as IE. So you
need to create the security cookies in IE by either logging in via the
EXCEL Web Query dialog (preferred) or with IE.
On Mon, Jul 15, 2013 at 12:31 AM, Lawrence <lawrence.leesh@
> Thanks Randy. This worked. Only problem is that advfn offers 5 years of
> data if you sign in and only 3 years if you don't. When you put formulae in
> excel, it won't retrieve the additional two years.
>
Mon Jul 15, 2013 1:55 pm (PDT) . Posted by:
"José Azevedo" jma_resende
Hi!
Randy have all most the link to extract information in Morningstar
But in this page, that I want:
http://financials.morningstar.com/cash-flow/cf.html?t=MSFT®ion=USA&culture=en-us
it is difficult.
But, there are the same information in Ft.com and I try this:
=RCHGetTableCell("
http://markets.ft.com/research/Markets/Tearsheets/Financials?s=MSFT:NSQ&subview=CashFlow&period=q ";1;"Net
income")
And if I put the number before "Net income"1, 2 or 3 i get the information,
but if I put 4 or 5, I get a ERROR.
And error other information in that page... with some numbers..
Some help?
thanks
Randy have all most the link to extract information in Morningstar
But in this page, that I want:
http://financials.
it is difficult.
But, there are the same information in Ft.com and I try this:
=RCHGetTableCell(
http://markets.
income"
And if I put the number before "Net income"
but if I put 4 or 5, I get a ERROR.
And error other information in that page... with some numbers..
Some help?
thanks
Mon Jul 15, 2013 2:43 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You'll need to create an IE security cookie in order to get the 5 years
from FT.
That means logging in using either IE or the EXCEL Web Query dialog
(preferred). Logging in with something like FireFox or Chrome won't help,
because EXCEL is a Microsoft product and uses the some communications
protocols as IE.
You won't be able to extract data from that MorningStar page, because it's
dynamically generated. The best you can do is pull in the file from the
EXPORT option on the page. See:
http://finance.groups.yahoo.com/group/smf_addin/message/19776
On Mon, Jul 15, 2013 at 1:55 PM, José Azevedo <jmazevedo@gmail.com > wrote:
>
> Randy have all most the link to extract information in Morningstar
> But in this page, that I want:
>
> http://financials.morningstar.com/cash-flow/cf.html?t=MSFT®ion=USA&culture=en-us
> it is difficult.
>
> But, there are the same information in Ft.com and I try this:
> =RCHGetTableCell("
> http://markets.ft.com/research/Markets/Tearsheets/Financials?s=MSFT:NSQ&subview=CashFlow&period=q ";1;"Net
> income")
>
> And if I put the number before "Net income"1, 2 or 3 i get the
> information, but if I put 4 or 5, I get a ERROR.
> And error other information in that page... with some numbers..
>
>
from FT.
That means logging in using either IE or the EXCEL Web Query dialog
(preferred). Logging in with something like FireFox or Chrome won't help,
because EXCEL is a Microsoft product and uses the some communications
protocols as IE.
You won't be able to extract data from that MorningStar page, because it's
dynamically generated. The best you can do is pull in the file from the
EXPORT option on the page. See:
http://finance.
On Mon, Jul 15, 2013 at 1:55 PM, José Azevedo <jmazevedo@gmail.
>
> Randy have all most the link to extract information in Morningstar
> But in this page, that I want:
>
> http://financials.
> it is difficult.
>
> But, there are the same information in Ft.com and I try this:
> =RCHGetTableCell(
> http://markets.
> income"
>
> And if I put the number before "Net income"
> information, but if I put 4 or 5, I get a ERROR.
> And error other information in that page... with some numbers..
>
>
Mon Jul 15, 2013 5:30 am (PDT) . Posted by:
"boo1712" boo1712
Hi guys,
With reference to an online excel file "http://www.spindices.com/documents/additional-material/sp-500-eps-est.xlsx ".
Any of you guys know how can I get a cell value or range of values from the online excel file with something like ["http://www.spindices.com/documents/additional-material/sp-500-eps-est.xlsx "]sheet1!A1?
Is there some functions in SMF that can do that?
Thanks for reading my post.
Terry
With reference to an online excel file "http://www.spindice
Any of you guys know how can I get a cell value or range of values from the online excel file with something like ["http://www.spindice
Is there some functions in SMF that can do that?
Thanks for reading my post.
Terry
Mon Jul 15, 2013 7:29 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
You can try this. I just did not it worked but it assumes the file name does
not change
Open the spreadsheet online
Open a new excel spreadsheet
Select/copy the columns you want
Do paste special into the cells in your new spreadsheet
That worked for me. Man there is a ton of information in that spreadsheet.
Be sure to let us know if this works for you.
Kermit
-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of boo1712
Sent: Monday, July 15, 2013 8:30 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Get data from online excel file
Hi guys,
With reference to an online excel file
"http://www.spindices.com/documents/additional-material/sp-500-eps-est.xlsx "
.
Any of you guys know how can I get a cell value or range of values from the
online excel file with something like
["http://www.spindices.com/documents/additional-material/sp-500-eps-est.xlsx
"]sheet1!A1?
Is there some functions in SMF that can do that?
Thanks for reading my post.
Terry
------------------------------------
Yahoo! Groups Links
not change
Open the spreadsheet online
Open a new excel spreadsheet
Select/copy the columns you want
Do paste special into the cells in your new spreadsheet
That worked for me. Man there is a ton of information in that spreadsheet.
Be sure to let us know if this works for you.
Kermit
-----Original Message-----
From: smf_addin@yahoogrou
Of boo1712
Sent: Monday, July 15, 2013 8:30 AM
To: smf_addin@yahoogrou
Subject: [smf_addin] Get data from online excel file
Hi guys,
With reference to an online excel file
"http://www.spindice
.
Any of you guys know how can I get a cell value or range of values from the
online excel file with something like
["http://www.spindice
"]sheet1!
Is there some functions in SMF that can do that?
Thanks for reading my post.
Terry
------------
Yahoo! Groups Links
Mon Jul 15, 2013 8:36 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Just a normal EXCEL process -- it would be something like:
='
http://www.spindices.com/documents/additional-material/ [sp-500-eps-est.xlsx]ESTIMATES&PEs'!A1
So, really, four components:
1. Location
2. File name
3. Sheet name
4. Cell reference
You can even do an array-entered formula and grab a range:
='
http://www.spindices.com/documents/additional-material/ [sp-500-eps-est.xlsx]ESTIMATES&PEs'!A1:B2
...although empty cells do get copied as a zero numeric value.
On Mon, Jul 15, 2013 at 5:30 AM, boo1712 <boo1712@yahoo.co.uk > wrote:
>
> With reference to an online excel file "
> http://www.spindices.com/documents/additional-material/sp-500-eps-est.xlsx
> ".
>
> Any of you guys know how can I get a cell value or range of values from
> the online excel file with something like ["
> http://www.spindices.com/documents/additional-material/sp-500-eps-est.xlsx
> "]sheet1!A1?
>
> Is there some functions in SMF that can do that?
>
='
http://www.spindice
So, really, four components:
1. Location
2. File name
3. Sheet name
4. Cell reference
You can even do an array-entered formula and grab a range:
='
http://www.spindice
...although empty cells do get copied as a zero numeric value.
On Mon, Jul 15, 2013 at 5:30 AM, boo1712 <boo1712@yahoo.
>
> With reference to an online excel file "
> http://www.spindice
> ".
>
> Any of you guys know how can I get a cell value or range of values from
> the online excel file with something like ["
> http://www.spindice
> "]sheet1!
>
> Is there some functions in SMF that can do that?
>
Mon Jul 15, 2013 8:57 am (PDT) . Posted by:
"boo1712" boo1712
Marvelous.
Thanks Randy.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Just a normal EXCEL process -- it would be something like:
>
> ='
> http://www.spindices.com/documents/additional-material/ [sp-500-eps-est.xlsx]ESTIMATES&PEs'!A1
>
> So, really, four components:
>
> 1. Location
> 2. File name
> 3. Sheet name
> 4. Cell reference
>
> You can even do an array-entered formula and grab a range:
>
> ='
> http://www.spindices.com/documents/additional-material/ [sp-500-eps-est.xlsx]ESTIMATES&PEs'!A1:B2
>
> ...although empty cells do get copied as a zero numeric value.
> On Mon, Jul 15, 2013 at 5:30 AM, boo1712 <boo1712@...> wrote:
>
> >
> > With reference to an online excel file "
> > http://www.spindices.com/documents/additional-material/sp-500-eps-est.xlsx
> > ".
> >
> > Any of you guys know how can I get a cell value or range of values from
> > the online excel file with something like ["
> > http://www.spindices.com/documents/additional-material/sp-500-eps-est.xlsx
> > "]sheet1!A1?
> >
> > Is there some functions in SMF that can do that?
> >
>
Thanks Randy.
--- In smf_addin@yahoogrou
>
> Just a normal EXCEL process -- it would be something like:
>
> ='
> http://www.spindice
>
> So, really, four components:
>
> 1. Location
> 2. File name
> 3. Sheet name
> 4. Cell reference
>
> You can even do an array-entered formula and grab a range:
>
> ='
> http://www.spindice
>
> ...although empty cells do get copied as a zero numeric value.
> On Mon, Jul 15, 2013 at 5:30 AM, boo1712 <boo1712@
>
> >
> > With reference to an online excel file "
> > http://www.spindice
> > ".
> >
> > Any of you guys know how can I get a cell value or range of values from
> > the online excel file with something like ["
> > http://www.spindice
> > "]sheet1!
> >
> > Is there some functions in SMF that can do that?
> >
>
Mon Jul 15, 2013 9:03 am (PDT) . Posted by:
"boo1712" boo1712
=IF('http://www.spindice
Using a if function as above can remove the "0"
--- In smf_addin@yahoogrou
>
> Just a normal EXCEL process -- it would be something like:
>
> ='
> http://www.spindice
>
> So, really, four components:
>
> 1. Location
> 2. File name
> 3. Sheet name
> 4. Cell reference
>
> You can even do an array-entered formula and grab a range:
>
> ='
> http://www.spindice
>
> ...although empty cells do get copied as a zero numeric value.
> On Mon, Jul 15, 2013 at 5:30 AM, boo1712 <boo1712@
>
> >
> > With reference to an online excel file "
> > http://www.spindice
> > ".
> >
> > Any of you guys know how can I get a cell value or range of values from
> > the online excel file with something like ["
> > http://www.spindice
> > "]sheet1!
> >
> > Is there some functions in SMF that can do that?
> >
>
Mon Jul 15, 2013 4:29 pm (PDT) . Posted by:
"Thomas" tg.bruin
Want to retrieve closing prices for first trading day of the year for a range of ticker symbols.
Why am I getting this result: Invalid Period Requested:C
To this formula: =RCHGetYahooHistory(w12,2013,1,2,2013,1,2,"C",0,0,0)
where w12 contains tickcer symbol "BHI"
Have tried editing formula to use actual ticker instead of cell reference, but this does not change the result.
Why am I getting this result: Invalid Period Requested:C
To this formula: =RCHGetYahooHistory
where w12 contains tickcer symbol "BHI"
Have tried editing formula to use actual ticker instead of cell reference, but this does not change the result.
Mon Jul 15, 2013 4:41 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You're passing the "C" as a PERIOD, not an ITEM. Try either:
=RCHGetYahooHistory(W12,2013,1,2,2013,1,2,,"C",0,0,0)
=RCHGetYahooHistory("BHI",2013,1,2,2013,1,2,"d","C",0,0,0)
Hmmm. Normally, someone would want the last trading date of the prior year,
if you're doing some type of year computation. Otherwise, you miss the
trading of the first day of the year.
And if you're doing a total return computation of some type (i.e. YTD
return), you'd want to use adjusted prices. Typically, I'd use the
smfPricesByDates() function for that, because it can also get data for
multiple specified dates in one Internet access -- without needing to know
if it was actually a trading date or not (gets the price from the last
trading day up to the specified dates).
On Mon, Jul 15, 2013 at 4:29 PM, Thomas <thos.bruin@gmail.com > wrote:
> Want to retrieve closing prices for first trading day of the year for a
> range of ticker symbols.
>
> Why am I getting this result: Invalid Period Requested:C
>
> To this formula: =RCHGetYahooHistory(w12,2013,1,2,2013,1,2,"C",0,0,0)
>
> where w12 contains tickcer symbol "BHI"
>
> Have tried editing formula to use actual ticker instead of cell reference,
> but this does not change the result.
>
=RCHGetYahooHistory
=RCHGetYahooHistory
Hmmm. Normally, someone would want the last trading date of the prior year,
if you're doing some type of year computation. Otherwise, you miss the
trading of the first day of the year.
And if you're doing a total return computation of some type (i.e. YTD
return), you'd want to use adjusted prices. Typically, I'd use the
smfPricesByDates(
multiple specified dates in one Internet access -- without needing to know
if it was actually a trading date or not (gets the price from the last
trading day up to the specified dates).
On Mon, Jul 15, 2013 at 4:29 PM, Thomas <thos.bruin@gmail.
> Want to retrieve closing prices for first trading day of the year for a
> range of ticker symbols.
>
> Why am I getting this result: Invalid Period Requested:C
>
> To this formula: =RCHGetYahooHistory
>
> where w12 contains tickcer symbol "BHI"
>
> Have tried editing formula to use actual ticker instead of cell reference,
> but this does not change the result.
>
Mon Jul 15, 2013 6:59 pm (PDT) . Posted by:
"Tom Bruin" tg.bruin
Thank you Randy. =smfGetPricesByDates works much better
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Monday, July 15, 2013 6:41 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] error using RCHGetYahooHistory
You're passing the "C" as a PERIOD, not an ITEM. Try either:
=RCHGetYahooHistory(W12,2013,1,2,2013,1,2,,"C",0,0,0)
=RCHGetYahooHistory("BHI",2013,1,2,2013,1,2,"d","C",0,0,0)
Hmmm. Normally, someone would want the last trading date of the prior year, if you're doing some type of year computation. Otherwise, you miss the trading of the first day of the year.
And if you're doing a total return computation of some type (i.e. YTD return), you'd want to use adjusted prices. Typically, I'd use the smfPricesByDates() function for that, because it can also get data for multiple specified dates in one Internet access -- without needing to know if it was actually a trading date or not (gets the price from the last trading day up to the specified dates).
On Mon, Jul 15, 2013 at 4:29 PM, Thomas <thos.bruin@gmail.com > wrote:
Want to retrieve closing prices for first trading day of the year for a range of ticker symbols.
Why am I getting this result: Invalid Period Requested:C
To this formula: =RCHGetYahooHistory(w12,2013,1,2,2013,1,2,"C",0,0,0)
where w12 contains tickcer symbol "BHI"
Have tried editing formula to use actual ticker instead of cell reference, but this does not change the result.
From: smf_addin@yahoogrou
Sent: Monday, July 15, 2013 6:41 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] error using RCHGetYahooHistory
You're passing the "C" as a PERIOD, not an ITEM. Try either:
=RCHGetYahooHistory
=RCHGetYahooHistory
Hmmm. Normally, someone would want the last trading date of the prior year, if you're doing some type of year computation. Otherwise, you miss the trading of the first day of the year.
And if you're doing a total return computation of some type (i.e. YTD return), you'd want to use adjusted prices. Typically, I'd use the smfPricesByDates(
On Mon, Jul 15, 2013 at 4:29 PM, Thomas <thos.bruin@gmail.
Want to retrieve closing prices for first trading day of the year for a range of ticker symbols.
Why am I getting this result: Invalid Period Requested:C
To this formula: =RCHGetYahooHistory
where w12 contains tickcer symbol "BHI"
Have tried editing formula to use actual ticker instead of cell reference, but this does not change the result.
Tidak ada komentar:
Posting Komentar