6 New Messages
Digest #2400
Messages
Wed Nov 14, 2012 11:53 am (PST) . Posted by:
"nuno.nogueira" nuno.nogueira
Hello,
I'm using RCHGetTableCell formula to capture data from Ft.com and Reuters.
Because ft.com doesn't have a URL for interim data, I must use Reuters.
However, I get an error when using the URL of Reuters. I have the following two cells:
=RCHGetTableCell("http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=IBM ";1;"Revenue")
Error
And
=RCHGetTableCell("http://markets.ft.com/research/Markets/Tearsheets/Financials?s=MRK:NYQ&subview=BalanceSheet ";1;"Total Assets")
105,128
What can be causing the problem? Any help please?
I'm using RCHGetTableCell formula to capture data from Ft.com and Reuters.
Because ft.com doesn't have a URL for interim data, I must use Reuters.
However, I get an error when using the URL of Reuters. I have the following two cells:
=RCHGetTableCell(
Error
And
=RCHGetTableCell(
105,128
What can be causing the problem? Any help please?
Wed Nov 14, 2012 12:48 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Are you logged in to Reuters using IE or the EXCEL Web Query dialog? Your
formula worked fine for me once I was logged in...
On Wed, Nov 14, 2012 at 12:53 PM, nuno.nogueira
<nuno.nogueira35@gmail.com >wrote:
> Hello,
>
> I'm using RCHGetTableCell formula to capture data from Ft.com and Reuters.
>
> Because ft.com doesn't have a URL for interim data, I must use Reuters.
>
> However, I get an error when using the URL of Reuters. I have the
> following two cells:
>
> =RCHGetTableCell("
> http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=IBM
> ";1;"Revenue")
>
> Error
>
> And
> =RCHGetTableCell("
> http://markets.ft.com/research/Markets/Tearsheets/Financials?s=MRK:NYQ&subview=BalanceSheet ";1;"Total
> Assets")
>
> 105,128
>
> What can be causing the problem? Any help please?
>
formula worked fine for me once I was logged in...
On Wed, Nov 14, 2012 at 12:53 PM, nuno.nogueira
<nuno.nogueira35@
> Hello,
>
> I'm using RCHGetTableCell formula to capture data from Ft.com and Reuters.
>
> Because ft.com doesn't have a URL for interim data, I must use Reuters.
>
> However, I get an error when using the URL of Reuters. I have the
> following two cells:
>
> =RCHGetTableCell(
> http://www.reuters.
> ";1;"Revenue"
>
> Error
>
> And
> =RCHGetTableCell(
> http://markets.
> Assets")
>
> 105,128
>
> What can be causing the problem? Any help please?
>
Wed Nov 14, 2012 3:55 pm (PST) . Posted by:
"Eric Stats" ehstats
Randy,
How do I retrieve an adjusted close for a stock on a specific day in excel?
For example, if I have GE in cell a2, 12/31/2007 in cell b2, and then I
want the price in c2.
On Tue, Nov 13, 2012 at 2:25 AM, Randy Harmelink <rharmelink@gmail.com >wrote:
> **
>
>
> Are you array-entering the formula over a range? Otherwise, I have no
> suggestions to make until you explain the symptoms of not working...
>
> At its simplest, all you need is something like:
>
> =RCHGetYahooHistory("MSFT")
>
> ...over a range of 7 columns and the number of rows of data you want.
>
> On Mon, Nov 12, 2012 at 4:42 PM, chad.touchberry <
> chad.touchberry@yahoo.com > wrote:
>
>> Really all I need to do what I want is for excel to pull the historic
>> data (date, open, high,low, close, avg vol, adj close) from a website like
>> http://ichart.finance.yahoo.com. Is this possible with the
>> =RCHGetYahooHistory function? I can't seem to get it to work.
>>
>
>
>
--
Eric Stats, CFA
801-552-6631
How do I retrieve an adjusted close for a stock on a specific day in excel?
For example, if I have GE in cell a2, 12/31/2007 in cell b2, and then I
want the price in c2.
On Tue, Nov 13, 2012 at 2:25 AM, Randy Harmelink <rharmelink@gmail.
> **
>
>
> Are you array-entering the formula over a range? Otherwise, I have no
> suggestions to make until you explain the symptoms of not working...
>
> At its simplest, all you need is something like:
>
> =RCHGetYahooHistory
>
> ...over a range of 7 columns and the number of rows of data you want.
>
> On Mon, Nov 12, 2012 at 4:42 PM, chad.touchberry <
> chad.touchberry@
>
>> Really all I need to do what I want is for excel to pull the historic
>> data (date, open, high,low, close, avg vol, adj close) from a website like
>> http://ichart.
>> =RCHGetYahooHistory function? I can't seem to get it to work.
>>
>
>
>
--
Eric Stats, CFA
801-552-6631
Wed Nov 14, 2012 6:03 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I would use the smfPricesByDates() function:
=smfPricesByDates(A2,B2)
It can do more than one date if you need it...
On Wed, Nov 14, 2012 at 4:55 PM, Eric Stats <ericstats@gmail.com > wrote:
>
> How do I retrieve an adjusted close for a stock on a specific day in
> excel? For example, if I have GE in cell a2, 12/31/2007 in cell b2, and
> then I want the price in c2.
>
=smfPricesByDates(
It can do more than one date if you need it...
On Wed, Nov 14, 2012 at 4:55 PM, Eric Stats <ericstats@gmail.
>
> How do I retrieve an adjusted close for a stock on a specific day in
> excel? For example, if I have GE in cell a2, 12/31/2007 in cell b2, and
> then I want the price in c2.
>
Wed Nov 14, 2012 4:38 pm (PST) . Posted by:
"nuno.nogueira" nuno.nogueira
Hello,
I've instaled the SMF addin and changed regional settings to US.
After doing it, my Excel crashes over and over again and I get a message from Excel asking me to disable SMF Addin.
Do I need to set up additional references or am I missing something?
Please help.
I've instaled the SMF addin and changed regional settings to US.
After doing it, my Excel crashes over and over again and I get a message from Excel asking me to disable SMF Addin.
Do I need to set up additional references or am I missing something?
Please help.
Wed Nov 14, 2012 6:07 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The only thing I can think of is that your add-in file is somehow
corrupted. Try deleting all of the files, downloading a fresh copy of the
ZIP file, and extracting all the files again.
Otherwise, an exact copy of the message you're getting may help.
On Wed, Nov 14, 2012 at 5:38 PM, nuno.nogueira <nuno.nogueira35@gmail.com >wrote:
>
> I've instaled the SMF addin and changed regional settings to US.
>
> After doing it, my Excel crashes over and over again and I get a message
> from Excel asking me to disable SMF Addin.
>
> Do I need to set up additional references or am I missing something?
>
> Please help.
>
corrupted. Try deleting all of the files, downloading a fresh copy of the
ZIP file, and extracting all the files again.
Otherwise, an exact copy of the message you're getting may help.
On Wed, Nov 14, 2012 at 5:38 PM, nuno.nogueira <nuno.nogueira35@
>
> I've instaled the SMF addin and changed regional settings to US.
>
> After doing it, my Excel crashes over and over again and I get a message
> from Excel asking me to disable SMF Addin.
>
> Do I need to set up additional references or am I missing something?
>
> Please help.
>
Tidak ada komentar:
Posting Komentar