7 Messages
Digest #3044
Messages
Wed Apr 16, 2014 2:42 am (PDT) . Posted by:
tatchong
Good day all, I would like to extract data from Financial Times, specifically the Interim Data. For instance on http://markets.ft.com/research/Markets/Tearsheets/Financials?s=KO:NYQ&subview=BalanceSheet http://markets.ft.com/research/Markets/Tearsheets/Financials?s=KO:NYQ&subview=BalanceSheet.
There is "Annual data" and "Interim data" on the webpage. However, looking at the page source, only the "Annual data" information is available. I can't seem to find the source of "Interim data".
Would appreciate any help on this.
Thank you very much.
Regards,
TC
There is "Annual data" and "Interim data" on the webpage. However, looking at the page source, only the "Annual data" information is available. I can't seem to find the source of "Interim data".
Would appreciate any help on this.
Thank you very much.
Regards,
TC
Wed Apr 16, 2014 2:12 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sorry, but I don't see a way to get a URL that gets directly to the Interim
data.
On Wed, Apr 16, 2014 at 1:35 AM, <tatchong@yahoo.com.sg> wrote:
> I would like to extract data from Financial Times, specifically the
> Interim Data. For instance on
> http://markets.ft.com/research/Markets/Tearsheets/Financials?s=KO:NYQ&subview=BalanceSheet
> .
> There is "Annual data" and "Interim data" on the webpage. However, looking
> at the page source, only the "Annual data" information is available. I
> can't seem to find the source of "Interim data".
> Would appreciate any help on this.
>
>
data.
On Wed, Apr 16, 2014 at 1:35 AM, <tatchong@yahoo.com.sg> wrote:
> I would like to extract data from Financial Times, specifically the
> Interim Data. For instance on
> http://markets.ft.com/research/Markets/Tearsheets/Financials?s=KO:NYQ&subview=BalanceSheet
> .
> There is "Annual data" and "Interim data" on the webpage. However, looking
> at the page source, only the "Annual data" information is available. I
> can't seem to find the source of "Interim data".
> Would appreciate any help on this.
>
>
Wed Apr 16, 2014 5:38 am (PDT) . Posted by:
spanish_biker79
I see, thanks for letting me know Andy.
If anyone has it laying around and could email me a copy at some point (mickael28@hotmail.com), that'd be really helpful to help me starting...
Many thanks,
M
If anyone has it laying around and could email me a copy at some point (mickael28@hotmail.com), that'd be really helpful to help me starting...
Many thanks,
M
Wed Apr 16, 2014 2:08 pm (PDT) . Posted by:
lazycritic
This seems like an obvious question, but I didn't see it answered in the tips and tried to do some searching to no avail. How can I get this thing to NOT recalculate so often? I'm getting serious delays, both when I start up and when I switch worksheets. I don't expect most of this data to change very often so it really doesn't need to keep refreshing.
Thanks for the wonderful tool!
Thanks for the wonderful tool!
Wed Apr 16, 2014 2:16 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The method depends entirely on what kinds of data you're getting and how.
Two common methods:
If you're using a lot of individual RCHGetYahooQuotes() functions, you can
combine them into a group by array-entering the function over a range. That
would allow you to get multiple data items on up to 200 ticker symbols,
with a single Internet access.
If you're pulling data from several web pages on a number of stocks, you
can look at using the smfUpdateDownloadTable macro (see "Tips and FAQs" for
more info). It fills cells with values, so then the only "recalculation" is
when you rerun the macro.
On Wed, Apr 16, 2014 at 10:06 AM, <lazycritic@gmail.com> wrote:
>
> This seems like an obvious question, but I didn't see it answered in the
> tips and tried to do some searching to no avail. How can I get this thing
> to NOT recalculate so often? I'm getting serious delays, both when I start
> up and when I switch worksheets. I don't expect most of this data to change
> very often so it really doesn't need to keep refreshing.
>
Two common methods:
If you're using a lot of individual RCHGetYahooQuotes() functions, you can
combine them into a group by array-entering the function over a range. That
would allow you to get multiple data items on up to 200 ticker symbols,
with a single Internet access.
If you're pulling data from several web pages on a number of stocks, you
can look at using the smfUpdateDownloadTable macro (see "Tips and FAQs" for
more info). It fills cells with values, so then the only "recalculation" is
when you rerun the macro.
On Wed, Apr 16, 2014 at 10:06 AM, <lazycritic@gmail.com> wrote:
>
> This seems like an obvious question, but I didn't see it answered in the
> tips and tried to do some searching to no avail. How can I get this thing
> to NOT recalculate so often? I'm getting serious delays, both when I start
> up and when I switch worksheets. I don't expect most of this data to change
> very often so it really doesn't need to keep refreshing.
>
Wed Apr 16, 2014 3:26 pm (PDT) . Posted by:
"Kermit W. Prather" kermitpra
One of the thing I did for workbooks that are using a lot of individual RCHGetYahooQuotes() functions is create a macro to
Set calculations to automatic or manual. I then created a button in the instruction worksheet and assign the macro to it.
Each time you click the button it runs the macro a reverses the setting.
You don't really need the macro as you can do it from the formula ribbon and select auto or manual.
Personally, I find this better for me. I can set the workbook to manual before I close it and then turn it to auto once I am ready to update.
The macro is very simple.
Sub TurnCalculationOnAndOff()
Select Case Application.Calculation
Case xlCalculationManual
Application.Calculation = xlCalculationAutomatic
MsgBox ("Calculation is set to AUTOMATIC")
Case xlCalculationAutomatic
Application.Calculation = xlCalculationManual
MsgBox ("Calculation is set to MANUAL")
Case xlCalculationSemiautomatic
MsgBox ("Calculation is set to semiautomatic. No change will take place")
End Select
End Sub
I placed this at the top of the instruction worksheet
This workbook has a lot of calculations which may get updated unnecessarily while you are making changes. You can control the setting of calculations to Automatic or manual by clicking the button below. You can also use "F9" to force a recalculation. You can check and change current setting by clicking on the Calculation Options button on the "formula" ribbon.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Wednesday, April 16, 2014 5:16 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Not calculating all the time
The method depends entirely on what kinds of data you're getting and how. Two common methods:
If you're using a lot of individual RCHGetYahooQuotes() functions, you can combine them into a group by array-entering the function over a range. That would allow you to get multiple data items on up to 200 ticker symbols, with a single Internet access.
If you're pulling data from several web pages on a number of stocks, you can look at using the smfUpdateDownloadTable macro (see "Tips and FAQs" for more info). It fills cells with values, so then the only "recalculation" is when you rerun the macro.
On Wed, Apr 16, 2014 at 10:06 AM, <lazycritic@gmail.com> wrote:
This seems like an obvious question, but I didn't see it answered in the tips and tried to do some searching to no avail. How can I get this thing to NOT recalculate so often? I'm getting serious delays, both when I start up and when I switch worksheets. I don't expect most of this data to change very often so it really doesn't need to keep refreshing.
Set calculations to automatic or manual. I then created a button in the instruction worksheet and assign the macro to it.
Each time you click the button it runs the macro a reverses the setting.
You don't really need the macro as you can do it from the formula ribbon and select auto or manual.
Personally, I find this better for me. I can set the workbook to manual before I close it and then turn it to auto once I am ready to update.
The macro is very simple.
Sub TurnCalculationOnAndOff()
Select Case Application.Calculation
Case xlCalculationManual
Application.Calculation = xlCalculationAutomatic
MsgBox ("Calculation is set to AUTOMATIC")
Case xlCalculationAutomatic
Application.Calculation = xlCalculationManual
MsgBox ("Calculation is set to MANUAL")
Case xlCalculationSemiautomatic
MsgBox ("Calculation is set to semiautomatic. No change will take place")
End Select
End Sub
I placed this at the top of the instruction worksheet
This workbook has a lot of calculations which may get updated unnecessarily while you are making changes. You can control the setting of calculations to Automatic or manual by clicking the button below. You can also use "F9" to force a recalculation. You can check and change current setting by clicking on the Calculation Options button on the "formula" ribbon.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Wednesday, April 16, 2014 5:16 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Not calculating all the time
The method depends entirely on what kinds of data you're getting and how. Two common methods:
If you're using a lot of individual RCHGetYahooQuotes() functions, you can combine them into a group by array-entering the function over a range. That would allow you to get multiple data items on up to 200 ticker symbols, with a single Internet access.
If you're pulling data from several web pages on a number of stocks, you can look at using the smfUpdateDownloadTable macro (see "Tips and FAQs" for more info). It fills cells with values, so then the only "recalculation" is when you rerun the macro.
On Wed, Apr 16, 2014 at 10:06 AM, <lazycritic@gmail.com> wrote:
This seems like an obvious question, but I didn't see it answered in the tips and tried to do some searching to no avail. How can I get this thing to NOT recalculate so often? I'm getting serious delays, both when I start up and when I switch worksheets. I don't expect most of this data to change very often so it really doesn't need to keep refreshing.
Wed Apr 16, 2014 2:08 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Looks like it's because Yahoo has no historical data for it today...so, no
quotes, no need for currency type.
On Wed, Apr 16, 2014 at 12:44 AM, <lawrence.leesh@gmail.com> wrote:
>
> Are you get a blank cell from this formula? I tried on two of my computers
> and it is still blank.
>
>
quotes, no need for currency type.
On Wed, Apr 16, 2014 at 12:44 AM, <lawrence.leesh@gmail.com> wrote:
>
> Are you get a blank cell from this formula? I tried on two of my computers
> and it is still blank.
>
>
Tidak ada komentar:
Posting Komentar