5 New Messages
Digest #2640
Messages
Sun Jun 2, 2013 9:57 am (PDT) . Posted by:
"ssztaba" ssztaba
When we last left our hapless Excel programmer (me), I was wondering why my workbook which was working a day earlier was no longer getting smfGetOptionQuotes, and our trusty, patient, wizard (you) were asking "I assume you're refreshing your quotes with smfForceRecalculation"....
Well, the answer to that query was that while the Internet Options was set to get a fresh copy every time, I was NOT using the smfForceRecalculation -- but that still left me the question as to how the workbook was working very well the prior day since there was no smfForceRecalculation being done that earlier day either.
Well, the solution came in the following manner: I opened the workbook one morning around 9:30am (Eastern) and I got the "N/A" messages where the option quotes should be. But, of course those "N/A" messages were in fact what Yahoo was displaying at that time since no option pricing was yet being displayed.
Before beginning to work on adding the smfForceRecalculation code (although still unable to figure out how the workbook worked previously without it) I made a copy of the workbook -- in case I really messed things up. I was then interrupted and went away for about 1/2 hour or so.
When I returned around 10:00 am, instead of starting to work on the copy of the workbook, I inadvertendly opened the original version -- which was identical with the copy -- and was surprised to discover that the workbook was working -- that is, option quotes were being retrieved, and very quickly, with just an F9 calculate.
I was mystified, and then I switched over to the copy of the workbook which I had made at 9:30, and which at 9:30 displayed only "N/A" messages. Now, at 10:00 this copy still gave "N/A" messages, and the F9 keys did nothing -- that is, this workbook continued to show "N/A" throughout the day in place of option prices.
So, what I had were two identical workbooks, where the only difference between whether they worked or not in getting option prices was the time of day when they were opened. If opened earlier than 9:50 the workbook would display only, and forever, the "N/A" messages. If opened after 9:50 the workbook obtained correct option prices. Close the workbook displaying the "N/A" messages and re-open immediately (after 9:50) and it worked properly and obtained options prices.
And NEITHER of these workbooks had the smfForceRecalculation code. If I add the smfForceRecalculation code, the workbook slows down excessively -- needing more than a minute to get about 60 options quotes. If I do NOT have the smfForceRecalculation code in the workbook, and open it after 9:50 then option prices are obtained, and obtained very fast, taking no more than 1 or 2 seconds to get 100+ stock prices and 60 options prices!
I don't understand this, not that I need to understand it, since I have a preferable work-around -- open the workbook after 9:50 (I can't get pricing before that anyways), and without the smfForceRecalculation I get the stock and option prices very quickly with just an F9 command.
Not knowing the innards of the Add-in, what I suspect is happening is that once the smfGetOptionQuotes gets the "N/A" messages, some kind of a flag is set within the Add-in which prevents the Add-in from later getting option quotes. But if the Add-in never gets the "N/A" messages, then option quotes are obtained quickly without the need for the smfForceRecalculation.
Just thought I'd pass this along.
Best wishes,
Stan Sztaba
-----------------------
Randy: "If you're getting "N/A", then that would be what the add-in found on Yahoo. The add-in wouldn't create such a value....
...I assume you're refreshing your quotes with smfForceRecalculation? Maybe you need to set your Internet Options to make sure you get a fresh copy of the web page every time? Otherwise, you could be getting a cached copy of the web page from IE's temporary Internet files..."
Stan: "I'm using smfGetOptionQuotes, and my formulas were working last friday, but all
day today I've been getting 'N/A' error messages"
Well, the answer to that query was that while the Internet Options was set to get a fresh copy every time, I was NOT using the smfForceRecalculati
Well, the solution came in the following manner: I opened the workbook one morning around 9:30am (Eastern) and I got the "N/A" messages where the option quotes should be. But, of course those "N/A" messages were in fact what Yahoo was displaying at that time since no option pricing was yet being displayed.
Before beginning to work on adding the smfForceRecalculati
When I returned around 10:00 am, instead of starting to work on the copy of the workbook, I inadvertendly opened the original version -- which was identical with the copy -- and was surprised to discover that the workbook was working -- that is, option quotes were being retrieved, and very quickly, with just an F9 calculate.
I was mystified, and then I switched over to the copy of the workbook which I had made at 9:30, and which at 9:30 displayed only "N/A" messages. Now, at 10:00 this copy still gave "N/A" messages, and the F9 keys did nothing -- that is, this workbook continued to show "N/A" throughout the day in place of option prices.
So, what I had were two identical workbooks, where the only difference between whether they worked or not in getting option prices was the time of day when they were opened. If opened earlier than 9:50 the workbook would display only, and forever, the "N/A" messages. If opened after 9:50 the workbook obtained correct option prices. Close the workbook displaying the "N/A" messages and re-open immediately (after 9:50) and it worked properly and obtained options prices.
And NEITHER of these workbooks had the smfForceRecalculati
I don't understand this, not that I need to understand it, since I have a preferable work-around -- open the workbook after 9:50 (I can't get pricing before that anyways), and without the smfForceRecalculati
Not knowing the innards of the Add-in, what I suspect is happening is that once the smfGetOptionQuotes gets the "N/A" messages, some kind of a flag is set within the Add-in which prevents the Add-in from later getting option quotes. But if the Add-in never gets the "N/A" messages, then option quotes are obtained quickly without the need for the smfForceRecalculati
Just thought I'd pass this along.
Best wishes,
Stan Sztaba
------------
Randy: "If you're getting "N/A"
...I assume you're refreshing your quotes with smfForceRecalculati
Stan: "I'
day today I've been getting 'N/A' error messages"
Sun Jun 2, 2013 2:37 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
F9 CANNOT update smfGetOptionQuotes() prices. It's literally impossible for
it to do so.
The fact that F9 was getting your option quotes very quickly proves it.
Because if you are getting a lot of option quotes, it needs to retrieve web
pages for that data. Getting the data quickly means you are extracting data
from older, saved copies of the web pages. You need the
smfForceRecalculation to purge those saved web pages and get the new ones.
And getting new ones will take time, as each is retrieved from the Internet.
RCHGetYahooQuotes() can be set to update without smfForceRecalculation,
because it gets its data from a file instead of from Web pages.
It sounds like you may have opened up two instance of EXCEL, instead of two
workbooks within the same instance of EXCEL.
On Sun, Jun 2, 2013 at 9:57 AM, ssztaba <ssjurik@optonline.net > wrote:
> When we last left our hapless Excel programmer (me), I was wondering why
> my workbook which was working a day earlier was no longer getting
> smfGetOptionQuotes, and our trusty, patient, wizard (you) were asking "I
> assume you're refreshing your quotes with smfForceRecalculation"....
>
> Well, the answer to that query was that while the Internet Options was set
> to get a fresh copy every time, I was NOT using the smfForceRecalculation
> -- but that still left me the question as to how the workbook was working
> very well the prior day since there was no smfForceRecalculation being done
> that earlier day either.
>
> Well, the solution came in the following manner: I opened the workbook
> one morning around 9:30am (Eastern) and I got the "N/A" messages where the
> option quotes should be. But, of course those "N/A" messages were in fact
> what Yahoo was displaying at that time since no option pricing was yet
> being displayed.
>
> Before beginning to work on adding the smfForceRecalculation code
> (although still unable to figure out how the workbook worked previously
> without it) I made a copy of the workbook -- in case I really messed
> things up. I was then interrupted and went away for about 1/2 hour or so.
>
> When I returned around 10:00 am, instead of starting to work on the copy
> of the workbook, I inadvertendly opened the original version -- which was
> identical with the copy -- and was surprised to discover that the workbook
> was working -- that is, option quotes were being retrieved, and very
> quickly, with just an F9 calculate.
>
> I was mystified, and then I switched over to the copy of the workbook
> which I had made at 9:30, and which at 9:30 displayed only "N/A" messages.
> Now, at 10:00 this copy still gave "N/A" messages, and the F9 keys did
> nothing -- that is, this workbook continued to show "N/A" throughout the
> day in place of option prices.
>
> So, what I had were two identical workbooks, where the only difference
> between whether they worked or not in getting option prices was the time of
> day when they were opened. If opened earlier than 9:50 the workbook would
> display only, and forever, the "N/A" messages. If opened after 9:50 the
> workbook obtained correct option prices. Close the workbook displaying
> the "N/A" messages and re-open immediately (after 9:50) and it worked
> properly and obtained options prices.
>
> And NEITHER of these workbooks had the smfForceRecalculation code. If I
> add the smfForceRecalculation code, the workbook slows down excessively --
> needing more than a minute to get about 60 options quotes. If I do NOT
> have the smfForceRecalculation code in the workbook, and open it after 9:50
> then option prices are obtained, and obtained very fast, taking no more
> than 1 or 2 seconds to get 100+ stock prices and 60 options prices!
>
> I don't understand this, not that I need to understand it, since I have a
> preferable work-around -- open the workbook after 9:50 (I can't get pricing
> before that anyways), and without the smfForceRecalculation I get the stock
> and option prices very quickly with just an F9 command.
>
> Not knowing the innards of the Add-in, what I suspect is happening is that
> once the smfGetOptionQuotes gets the "N/A" messages, some kind of a flag is
> set within the Add-in which prevents the Add-in from later getting option
> quotes. But if the Add-in never gets the "N/A" messages, then option
> quotes are obtained quickly without the need for the smfForceRecalculation.
>
> Just thought I'd pass this along.
>
it to do so.
The fact that F9 was getting your option quotes very quickly proves it.
Because if you are getting a lot of option quotes, it needs to retrieve web
pages for that data. Getting the data quickly means you are extracting data
from older, saved copies of the web pages. You need the
smfForceRecalculati
And getting new ones will take time, as each is retrieved from the Internet.
RCHGetYahooQuotes(
because it gets its data from a file instead of from Web pages.
It sounds like you may have opened up two instance of EXCEL, instead of two
workbooks within the same instance of EXCEL.
On Sun, Jun 2, 2013 at 9:57 AM, ssztaba <ssjurik@optonline.
> When we last left our hapless Excel programmer (me), I was wondering why
> my workbook which was working a day earlier was no longer getting
> smfGetOptionQuotes, and our trusty, patient, wizard (you) were asking "I
> assume you're refreshing your quotes with smfForceRecalculati
>
> Well, the answer to that query was that while the Internet Options was set
> to get a fresh copy every time, I was NOT using the smfForceRecalculati
> -- but that still left me the question as to how the workbook was working
> very well the prior day since there was no smfForceRecalculati
> that earlier day either.
>
> Well, the solution came in the following manner: I opened the workbook
> one morning around 9:30am (Eastern) and I got the "N/A" messages where the
> option quotes should be. But, of course those "N/A" messages were in fact
> what Yahoo was displaying at that time since no option pricing was yet
> being displayed.
>
> Before beginning to work on adding the smfForceRecalculati
> (although still unable to figure out how the workbook worked previously
> without it) I made a copy of the workbook -- in case I really messed
> things up. I was then interrupted and went away for about 1/2 hour or so.
>
> When I returned around 10:00 am, instead of starting to work on the copy
> of the workbook, I inadvertendly opened the original version -- which was
> identical with the copy -- and was surprised to discover that the workbook
> was working -- that is, option quotes were being retrieved, and very
> quickly, with just an F9 calculate.
>
> I was mystified, and then I switched over to the copy of the workbook
> which I had made at 9:30, and which at 9:30 displayed only "N/A" messages.
> Now, at 10:00 this copy still gave "N/A" messages, and the F9 keys did
> nothing -- that is, this workbook continued to show "N/A" throughout the
> day in place of option prices.
>
> So, what I had were two identical workbooks, where the only difference
> between whether they worked or not in getting option prices was the time of
> day when they were opened. If opened earlier than 9:50 the workbook would
> display only, and forever, the "N/A" messages. If opened after 9:50 the
> workbook obtained correct option prices. Close the workbook displaying
> the "N/A" messages and re-open immediately (after 9:50) and it worked
> properly and obtained options prices.
>
> And NEITHER of these workbooks had the smfForceRecalculati
> add the smfForceRecalculati
> needing more than a minute to get about 60 options quotes. If I do NOT
> have the smfForceRecalculati
> then option prices are obtained, and obtained very fast, taking no more
> than 1 or 2 seconds to get 100+ stock prices and 60 options prices!
>
> I don't understand this, not that I need to understand it, since I have a
> preferable work-around -- open the workbook after 9:50 (I can't get pricing
> before that anyways), and without the smfForceRecalculati
> and option prices very quickly with just an F9 command.
>
> Not knowing the innards of the Add-in, what I suspect is happening is that
> once the smfGetOptionQuotes gets the "N/A" messages, some kind of a flag is
> set within the Add-in which prevents the Add-in from later getting option
> quotes. But if the Add-in never gets the "N/A" messages, then option
> quotes are obtained quickly without the need for the smfForceRecalculati
>
> Just thought I'd pass this along.
>
Sun Jun 2, 2013 4:59 pm (PDT) . Posted by:
"ssztaba" ssztaba
From my workbook which I've just opened I've checked 9 options prices (both Bid and Ask) on 3 different securities. All come from cells with the smfGetOptionsQuotes formulas and match exactly the prices I find by going directly to the Yahoo pages.
Tomorrow I will try to do a F9 update every hour, and then try to verify (or not) the results by checking with Yahoo directly.
I'll let you know what I find.
Thanks
Stan
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> F9 CANNOT update smfGetOptionQuotes() prices. It's literally impossible for
> it to do so.
>
> The fact that F9 was getting your option quotes very quickly proves it.
> Because if you are getting a lot of option quotes, it needs to retrieve web
> pages for that data. Getting the data quickly means you are extracting data
> from older, saved copies of the web pages. You need the
> smfForceRecalculation to purge those saved web pages and get the new ones.
> And getting new ones will take time, as each is retrieved from the Internet.
>
> RCHGetYahooQuotes() can be set to update without smfForceRecalculation,
> because it gets its data from a file instead of from Web pages.
>
> It sounds like you may have opened up two instance of EXCEL, instead of two
> workbooks within the same instance of EXCEL.
>
> On Sun, Jun 2, 2013 at 9:57 AM, ssztaba <ssjurik@...> wrote:
>
> > When we last left our hapless Excel programmer (me), I was wondering why
> > my workbook which was working a day earlier was no longer getting
> > smfGetOptionQuotes, and our trusty, patient, wizard (you) were asking "I
> > assume you're refreshing your quotes with smfForceRecalculation"....
> >
> > Well, the answer to that query was that while the Internet Options was set
> > to get a fresh copy every time, I was NOT using the smfForceRecalculation
> > -- but that still left me the question as to how the workbook was working
> > very well the prior day since there was no smfForceRecalculation being done
> > that earlier day either.
> >
> > Well, the solution came in the following manner: I opened the workbook
> > one morning around 9:30am (Eastern) and I got the "N/A" messages where the
> > option quotes should be. But, of course those "N/A" messages were in fact
> > what Yahoo was displaying at that time since no option pricing was yet
> > being displayed.
> >
> > Before beginning to work on adding the smfForceRecalculation code
> > (although still unable to figure out how the workbook worked previously
> > without it) I made a copy of the workbook -- in case I really messed
> > things up. I was then interrupted and went away for about 1/2 hour or so.
> >
> > When I returned around 10:00 am, instead of starting to work on the copy
> > of the workbook, I inadvertendly opened the original version -- which was
> > identical with the copy -- and was surprised to discover that the workbook
> > was working -- that is, option quotes were being retrieved, and very
> > quickly, with just an F9 calculate.
> >
> > I was mystified, and then I switched over to the copy of the workbook
> > which I had made at 9:30, and which at 9:30 displayed only "N/A" messages.
> > Now, at 10:00 this copy still gave "N/A" messages, and the F9 keys did
> > nothing -- that is, this workbook continued to show "N/A" throughout the
> > day in place of option prices.
> >
> > So, what I had were two identical workbooks, where the only difference
> > between whether they worked or not in getting option prices was the time of
> > day when they were opened. If opened earlier than 9:50 the workbook would
> > display only, and forever, the "N/A" messages. If opened after 9:50 the
> > workbook obtained correct option prices. Close the workbook displaying
> > the "N/A" messages and re-open immediately (after 9:50) and it worked
> > properly and obtained options prices.
> >
> > And NEITHER of these workbooks had the smfForceRecalculation code. If I
> > add the smfForceRecalculation code, the workbook slows down excessively --
> > needing more than a minute to get about 60 options quotes. If I do NOT
> > have the smfForceRecalculation code in the workbook, and open it after 9:50
> > then option prices are obtained, and obtained very fast, taking no more
> > than 1 or 2 seconds to get 100+ stock prices and 60 options prices!
> >
> > I don't understand this, not that I need to understand it, since I have a
> > preferable work-around -- open the workbook after 9:50 (I can't get pricing
> > before that anyways), and without the smfForceRecalculation I get the stock
> > and option prices very quickly with just an F9 command.
> >
> > Not knowing the innards of the Add-in, what I suspect is happening is that
> > once the smfGetOptionQuotes gets the "N/A" messages, some kind of a flag is
> > set within the Add-in which prevents the Add-in from later getting option
> > quotes. But if the Add-in never gets the "N/A" messages, then option
> > quotes are obtained quickly without the need for the smfForceRecalculation.
> >
> > Just thought I'd pass this along.
> >
>
Tomorrow I will try to do a F9 update every hour, and then try to verify (or not) the results by checking with Yahoo directly.
I'll let you know what I find.
Thanks
Stan
--- In smf_addin@yahoogrou
>
> F9 CANNOT update smfGetOptionQuotes(
> it to do so.
>
> The fact that F9 was getting your option quotes very quickly proves it.
> Because if you are getting a lot of option quotes, it needs to retrieve web
> pages for that data. Getting the data quickly means you are extracting data
> from older, saved copies of the web pages. You need the
> smfForceRecalculati
> And getting new ones will take time, as each is retrieved from the Internet.
>
> RCHGetYahooQuotes(
> because it gets its data from a file instead of from Web pages.
>
> It sounds like you may have opened up two instance of EXCEL, instead of two
> workbooks within the same instance of EXCEL.
>
> On Sun, Jun 2, 2013 at 9:57 AM, ssztaba <ssjurik@
>
> > When we last left our hapless Excel programmer (me), I was wondering why
> > my workbook which was working a day earlier was no longer getting
> > smfGetOptionQuotes, and our trusty, patient, wizard (you) were asking "I
> > assume you're refreshing your quotes with smfForceRecalculati
> >
> > Well, the answer to that query was that while the Internet Options was set
> > to get a fresh copy every time, I was NOT using the smfForceRecalculati
> > -- but that still left me the question as to how the workbook was working
> > very well the prior day since there was no smfForceRecalculati
> > that earlier day either.
> >
> > Well, the solution came in the following manner: I opened the workbook
> > one morning around 9:30am (Eastern) and I got the "N/A" messages where the
> > option quotes should be. But, of course those "N/A" messages were in fact
> > what Yahoo was displaying at that time since no option pricing was yet
> > being displayed.
> >
> > Before beginning to work on adding the smfForceRecalculati
> > (although still unable to figure out how the workbook worked previously
> > without it) I made a copy of the workbook -- in case I really messed
> > things up. I was then interrupted and went away for about 1/2 hour or so.
> >
> > When I returned around 10:00 am, instead of starting to work on the copy
> > of the workbook, I inadvertendly opened the original version -- which was
> > identical with the copy -- and was surprised to discover that the workbook
> > was working -- that is, option quotes were being retrieved, and very
> > quickly, with just an F9 calculate.
> >
> > I was mystified, and then I switched over to the copy of the workbook
> > which I had made at 9:30, and which at 9:30 displayed only "N/A" messages.
> > Now, at 10:00 this copy still gave "N/A" messages, and the F9 keys did
> > nothing -- that is, this workbook continued to show "N/A" throughout the
> > day in place of option prices.
> >
> > So, what I had were two identical workbooks, where the only difference
> > between whether they worked or not in getting option prices was the time of
> > day when they were opened. If opened earlier than 9:50 the workbook would
> > display only, and forever, the "N/A" messages. If opened after 9:50 the
> > workbook obtained correct option prices. Close the workbook displaying
> > the "N/A" messages and re-open immediately (after 9:50) and it worked
> > properly and obtained options prices.
> >
> > And NEITHER of these workbooks had the smfForceRecalculati
> > add the smfForceRecalculati
> > needing more than a minute to get about 60 options quotes. If I do NOT
> > have the smfForceRecalculati
> > then option prices are obtained, and obtained very fast, taking no more
> > than 1 or 2 seconds to get 100+ stock prices and 60 options prices!
> >
> > I don't understand this, not that I need to understand it, since I have a
> > preferable work-around -- open the workbook after 9:50 (I can't get pricing
> > before that anyways), and without the smfForceRecalculati
> > and option prices very quickly with just an F9 command.
> >
> > Not knowing the innards of the Add-in, what I suspect is happening is that
> > once the smfGetOptionQuotes gets the "N/A" messages, some kind of a flag is
> > set within the Add-in which prevents the Add-in from later getting option
> > quotes. But if the Add-in never gets the "N/A" messages, then option
> > quotes are obtained quickly without the need for the smfForceRecalculati
> >
> > Just thought I'd pass this along.
> >
>
Sun Jun 2, 2013 9:20 pm (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy,
similar WSJ question
as u can see from
http://online.wsj.com/mdc/public/page/2_3024-EuropeanStocks_London.html?mod=topnav_2_3024
how do i extract the datas from the page?
namely from all the companies and the datas of
Volume High Low Close Net Chg % Chg 52 Week High 52 Week Low
thanks
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I would use:
>
> =RCHGetTableCell("http://quotes.wsj.com/
> "&A1&"/financials/annual/income-statement",0,">Depreciation")
> =RCHGetTableCell("http://quotes.wsj.com/
> "&A1&"/financials/annual/income-statement",
> 0,">Depreciation",">Depreciation")
>
> ...depending on which line item I wanted:
>
> Depreciation & Amortization Expense
> Depreciation
>
> You could also use the whole label for each (bracketed by ">" and "<", as
> coded on the web page):
>
> =RCHGetTableCell("http://quotes.wsj.com/
> "&A1&"/financials/annual/income-statement",
> 0,">Depreciation & Amortization Expense<")
> =RCHGetTableCell("http://quotes.wsj.com/
> "&A1&"/financials/annual/income-statement",0,">Depreciation<")
>
> On Thu, May 30, 2013 at 8:54 AM, weekeewawa <weekeewawa@...> wrote:
>
> > hello randy.
> > I GOT IT! so the best is actually to follow exactly what they showed on
> > the page source
> >
> > for example the one shows ''depreciation<'' so i just use it
> >
> > so i suppose,
> >
> > this will be the best source code to use then?
> >
> > =RCHGetTableCell("http://quotes.wsj.com/
> > "&A1&"/financials/annual/income-statement",0,">Depreciation")
> >
> > for the 2 or more search strings, i should actually avoid it?
> >
>
similar WSJ question
as u can see from
http://online.
how do i extract the datas from the page?
namely from all the companies and the datas of
Volume High Low Close Net Chg % Chg 52 Week High 52 Week Low
thanks
--- In smf_addin@yahoogrou
>
> I would use:
>
> =RCHGetTableCell(
> "&A1&"
> =RCHGetTableCell(
> "&A1&"
> 0,">
>
> ...depending on which line item I wanted:
>
> Depreciation & Amortization Expense
> Depreciation
>
> You could also use the whole label for each (bracketed by ">" and "<"
> coded on the web page):
>
> =RCHGetTableCell(
> "&A1&"
> 0,">
> =RCHGetTableCell(
> "&A1&"
>
> On Thu, May 30, 2013 at 8:54 AM, weekeewawa <weekeewawa@
>
> > hello randy.
> > I GOT IT! so the best is actually to follow exactly what they showed on
> > the page source
> >
> > for example the one shows ''depreciat
> >
> > so i suppose,
> >
> > this will be the best source code to use then?
> >
> > =RCHGetTableCell(
> > "&A1&"
> >
> > for the 2 or more search strings, i should actually avoid it?
> >
>
Mon Jun 3, 2013 12:58 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try:
=RCHGetHTMLTable("
http://online.wsj.com/mdc/public/page/2_3024-EuropeanStocks_London.html ",
">London Stock Exchange",3,"Local Currency",-1)
On Sun, Jun 2, 2013 at 9:20 PM, weekeewawa <weekeewawa@yahoo.com > wrote:
>
> similar WSJ question
>
> as u can see from
>
>
> http://online.wsj.com/mdc/public/page/2_3024-EuropeanStocks_London.html?mod=topnav_2_3024
>
>
> how do i extract the datas from the page?
>
> namely from all the companies and the datas of
>
> Volume High Low Close Net Chg % Chg 52 Week High 52 Week Low
>
>
=RCHGetHTMLTable(
http://online.
">London Stock Exchange"
On Sun, Jun 2, 2013 at 9:20 PM, weekeewawa <weekeewawa@yahoo.
>
> similar WSJ question
>
> as u can see from
>
>
> http://online.
>
>
> how do i extract the datas from the page?
>
> namely from all the companies and the datas of
>
> Volume High Low Close Net Chg % Chg 52 Week High 52 Week Low
>
>
Tidak ada komentar:
Posting Komentar