9 New Messages
Digest #2578
Messages
Mon Apr 8, 2013 7:00 am (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy,
under this report
http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=MMM
if u look at total return % table
there are the 2008 2009 2010 2011 2012 YTD
however, the problem lies when for example when u rchgetcell of ''stock'', the code will be
=RCHGetTableCell("http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=MMM,0, ">Total Returns %","Stock")
in which it refers to ''stock'' as the secondary cell
but for the year, it just points to a blank space above ''stock''
what will be the solution for it
thanks
--- In smf_addin@yahoogroups.com , "weekeewawa" <weekeewawa@...> wrote:
>
> hello randy
>
> i can see from the source code that
>
> <li><a href="javascript:void(0);" onclick="javascript:loadCurrentValuation();" inited=false id="CurrentValuationTab" class="tabon">Current Valuation</a></li>
>
> appears
>
> however, i couldn't find
>
> http://financials.morningstar.com/valuation/current-valuation-list.action?&t=GOOG
>
> where is it actually located?
>
> theoretically if this methods works, all the other sections such as performance, shareholders, bonds for example, we could extract the table just like http://financials.morningstar.com/valuation/current-valuation-list.action?&t=GOOG?
>
>
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > There's no data within the source code of the web page to extract. What is
> > sent is just the structure of the web page. THEN, the data is dynamically
> > placed onto the web page. There's not an HTML table in the source code.
> >
> > For example, this is what the "Current Valuation" section looks like in the
> > source code of the web page:
> >
> > <li><a href="javascript:void(0);"
> > onclick="javascript:loadCurrentValuation();" inited=false
> > id="CurrentValuationTab" class="tabon">Current Valuation</a></li>
> >
> > So JavaScript is used to load the current valuation data. This is what the
> > JavaScript uses to load the data:
> >
> > http://financials.morningstar.com/valuation/current-valuation-list.action?&t=GOOG
> >
> > So, you COULD extract the data from that piece of the page layout. However,
> > since the entire content of that URL *is* a table, the RCHGetHTMLTable()
> > function won't work. You'd need to use RCHGetTableCell() to get each piece.
> >
> > On Sun, Apr 7, 2013 at 4:24 AM, weekeewawa <weekeewawa@> wrote:
> >
> > >
> > > here is another question.
> > >
> > > you were mentioning that morningstar is dynamically generated for the
> > >
> > >
> > > http://financials.morningstar.com/valuation/price-ratio.html?t=GOOG®ion=USA&culture=en-us
> > >
> > > however, i was wondering, what do u mean by dynamically generated and the
> > > difference between similar looking table cells that i saw over at yahoo
> > > finance or msn.
> > >
> > > could i use
> > >
> > > =RCHGetHTMLTable("
> > > http://financials.morningstar.com/valuation/price-ratio.html?t= "&A1,"®ion=USA&culture=en-us>Current
> > > Valulation",1,"",1)
> > >
> > > would it be the right direction to extract data from it?
> > >
> >
>
under this report
http://quicktake.
if u look at total return % table
there are the 2008 2009 2010 2011 2012 YTD
however, the problem lies when for example when u rchgetcell of ''stock&#
=RCHGetTableCell(
in which it refers to ''stock&#
but for the year, it just points to a blank space above ''stock&#
what will be the solution for it
thanks
--- In smf_addin@yahoogrou
>
> hello randy
>
> i can see from the source code that
>
> <li><
>
> appears
>
> however, i couldn't find
>
> http://financials.
>
> where is it actually located?
>
> theoretically if this methods works, all the other sections such as performance, shareholders, bonds for example, we could extract the table just like http://financials.
>
>
>
> --- In smf_addin@yahoogrou
> >
> > There's no data within the source code of the web page to extract. What is
> > sent is just the structure of the web page. THEN, the data is dynamically
> > placed onto the web page. There's not an HTML table in the source code.
> >
> > For example, this is what the "Current Valuation" section looks like in the
> > source code of the web page:
> >
> > <li><
> > onclick="
> > id="CurrentVal
> >
> > So JavaScript is used to load the current valuation data. This is what the
> > JavaScript uses to load the data:
> >
> > http://financials.
> >
> > So, you COULD extract the data from that piece of the page layout. However,
> > since the entire content of that URL *is* a table, the RCHGetHTMLTable(
> > function won't work. You'd need to use RCHGetTableCell(
> >
> > On Sun, Apr 7, 2013 at 4:24 AM, weekeewawa <weekeewawa@
> >
> > >
> > > here is another question.
> > >
> > > you were mentioning that morningstar is dynamically generated for the
> > >
> > >
> > > http://financials.
> > >
> > > however, i was wondering, what do u mean by dynamically generated and the
> > > difference between similar looking table cells that i saw over at yahoo
> > > finance or msn.
> > >
> > > could i use
> > >
> > > =RCHGetHTMLTable(
> > > http://financials.
> > > Valulation"
> > >
> > > would it be the right direction to extract data from it?
> > >
> >
>
Mon Apr 8, 2013 7:53 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try:
=RCHGetTableCell("
http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=MMM ",2,">Total
Returns %","<tr")
On Mon, Apr 8, 2013 at 7:00 AM, weekeewawa <weekeewawa@yahoo.com > wrote:
>
> under this report
>
> http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=MMM
>
> if u look at total return % table
>
> there are the 2008 2009 2010 2011 2012 YTD
>
> however, the problem lies when for example when u rchgetcell of ''stock'',
> the code will be
>
> =RCHGetTableCell("
> http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=MMM,0, ">Total
> Returns %","Stock")
>
> in which it refers to ''stock'' as the secondary cell
>
> but for the year, it just points to a blank space above ''stock''
>
> what will be the solution for it
>
=RCHGetTableCell(
http://quicktake.
Returns %","
On Mon, Apr 8, 2013 at 7:00 AM, weekeewawa <weekeewawa@yahoo.
>
> under this report
>
> http://quicktake.
>
> if u look at total return % table
>
> there are the 2008 2009 2010 2011 2012 YTD
>
> however, the problem lies when for example when u rchgetcell of ''stock&#
> the code will be
>
> =RCHGetTableCell(
> http://quicktake.
> Returns %","
>
> in which it refers to ''stock&#
>
> but for the year, it just points to a blank space above ''stock&#
>
> what will be the solution for it
>
Mon Apr 8, 2013 8:05 am (PDT) . Posted by:
"weekeewawa" weekeewawa
works perfectly as always!
thanks randy
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Try:
>
> =RCHGetTableCell("
> http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=MMM ",2,">Total
> Returns %","<tr")
>
> On Mon, Apr 8, 2013 at 7:00 AM, weekeewawa <weekeewawa@...> wrote:
>
> >
> > under this report
> >
> > http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=MMM
> >
> > if u look at total return % table
> >
> > there are the 2008 2009 2010 2011 2012 YTD
> >
> > however, the problem lies when for example when u rchgetcell of ''stock'',
> > the code will be
> >
> > =RCHGetTableCell("
> > http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=MMM,0, ">Total
> > Returns %","Stock")
> >
> > in which it refers to ''stock'' as the secondary cell
> >
> > but for the year, it just points to a blank space above ''stock''
> >
> > what will be the solution for it
> >
>
thanks randy
--- In smf_addin@yahoogrou
>
> Try:
>
> =RCHGetTableCell(
> http://quicktake.
> Returns %","
>
> On Mon, Apr 8, 2013 at 7:00 AM, weekeewawa <weekeewawa@
>
> >
> > under this report
> >
> > http://quicktake.
> >
> > if u look at total return % table
> >
> > there are the 2008 2009 2010 2011 2012 YTD
> >
> > however, the problem lies when for example when u rchgetcell of ''stock&#
> > the code will be
> >
> > =RCHGetTableCell(
> > http://quicktake.
> > Returns %","
> >
> > in which it refers to ''stock&#
> >
> > but for the year, it just points to a blank space above ''stock&#
> >
> > what will be the solution for it
> >
>
Mon Apr 8, 2013 10:08 pm (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy,
there are 2 questions i need to ask
1) for learning, what is the '<tr' means and for
2) over at
http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=mmm
under the section price/dividends/splits > 5 year history
i am able to get the first row, 5 Year History,Splits and dividends
and amount per share
however, the problem lies in the 2nd row and beyond
as you can see the second row shows
02-13-13 Cash Dividend 0.635000
all the way down to
02-18-09 cash dividend 0.510000
i tried using the code
=RCHGetTableCell("http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=MMM,1, ">5 Year History","<tr")
but it is able to only get the 2nd row but not thee 3rd and beyond
is there any solution for this problem
thanks
--- In smf_addin@yahoogroups.com , "weekeewawa" <weekeewawa@...> wrote:
>
> works perfectly as always!
>
> thanks randy
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > Try:
> >
> > =RCHGetTableCell("
> > http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=MMM ",2,">Total
> > Returns %","<tr")
> >
> > On Mon, Apr 8, 2013 at 7:00 AM, weekeewawa <weekeewawa@> wrote:
> >
> > >
> > > under this report
> > >
> > > http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=MMM
> > >
> > > if u look at total return % table
> > >
> > > there are the 2008 2009 2010 2011 2012 YTD
> > >
> > > however, the problem lies when for example when u rchgetcell of ''stock'',
> > > the code will be
> > >
> > > =RCHGetTableCell("
> > > http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=MMM,0, ">Total
> > > Returns %","Stock")
> > >
> > > in which it refers to ''stock'' as the secondary cell
> > >
> > > but for the year, it just points to a blank space above ''stock''
> > >
> > > what will be the solution for it
> > >
> >
>
there are 2 questions i need to ask
1) for learning, what is the '<tr&#
2) over at
http://quicktake.
under the section price/dividends/
i am able to get the first row, 5 Year History,Splits and dividends
and amount per share
however, the problem lies in the 2nd row and beyond
as you can see the second row shows
02-13-13 Cash Dividend 0.635000
all the way down to
02-18-09 cash dividend 0.510000
i tried using the code
=RCHGetTableCell(
but it is able to only get the 2nd row but not thee 3rd and beyond
is there any solution for this problem
thanks
--- In smf_addin@yahoogrou
>
> works perfectly as always!
>
> thanks randy
>
> --- In smf_addin@yahoogrou
> >
> > Try:
> >
> > =RCHGetTableCell(
> > http://quicktake.
> > Returns %","
> >
> > On Mon, Apr 8, 2013 at 7:00 AM, weekeewawa <weekeewawa@
> >
> > >
> > > under this report
> > >
> > > http://quicktake.
> > >
> > > if u look at total return % table
> > >
> > > there are the 2008 2009 2010 2011 2012 YTD
> > >
> > > however, the problem lies when for example when u rchgetcell of ''stock&#
> > > the code will be
> > >
> > > =RCHGetTableCell(
> > > http://quicktake.
> > > Returns %","
> > >
> > > in which it refers to ''stock&#
> > >
> > > but for the year, it just points to a blank space above ''stock&#
> > >
> > > what will be the solution for it
> > >
> >
>
Mon Apr 8, 2013 10:23 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
On Mon, Apr 8, 2013 at 10:08 PM, weekeewawa <weekeewawa@yahoo.com > wrote:
>
> there are 2 questions i need to ask
>
> 1) for learning, what is the '<tr' means and for
>
It was just a quick way to get to the next row of data. Another option
would have been to do this, which uses the "skip # of rows" parameter:
=RCHGetTableCell("
http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=MMM ",
2,">Total Returns %",,,,1)
2) over at
>
> http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=mmm
>
> under the section price/dividends/splits > 5 year history
>
> i am able to get the first row, 5 Year History,Splits and dividends
>
> and amount per share
>
> however, the problem lies in the 2nd row and beyond
>
> as you can see the second row shows
>
> 02-13-13 Cash Dividend 0.635000
>
> all the way down to
>
> 02-18-09 cash dividend 0.510000
>
> i tried using the code
>
> =RCHGetTableCell("
> http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=MMM,1, ">5
> Year History","<tr")
>
> but it is able to only get the 2nd row but not thee 3rd and beyond
>
> is there any solution for this problem
>
You can use that same "skip # of rows" parameter in the last formula. For
example:
=RCHGetTableCell("
http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=MMM ",1,">5
Year History",,,,1)
=RCHGetTableCell("
http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=MMM ",1,">5
Year History",,,,3)
>
> there are 2 questions i need to ask
>
> 1) for learning, what is the '<tr&#
>
It was just a quick way to get to the next row of data. Another option
would have been to do this, which uses the "skip # of rows" parameter:
=RCHGetTableCell(
http://quicktake.
2,">
2) over at
>
> http://quicktake.
>
> under the section price/dividends/
>
> i am able to get the first row, 5 Year History,Splits and dividends
>
> and amount per share
>
> however, the problem lies in the 2nd row and beyond
>
> as you can see the second row shows
>
> 02-13-13 Cash Dividend 0.635000
>
> all the way down to
>
> 02-18-09 cash dividend 0.510000
>
> i tried using the code
>
> =RCHGetTableCell(
> http://quicktake.
> Year History"
>
> but it is able to only get the 2nd row but not thee 3rd and beyond
>
> is there any solution for this problem
>
You can use that same "skip # of rows" parameter in the last formula. For
example:
=RCHGetTableCell(
http://quicktake.
Year History"
=RCHGetTableCell(
http://quicktake.
Year History"
Tue Apr 9, 2013 1:07 am (PDT) . Posted by:
"weekeewawa" weekeewawa
and it brings me to another point
as you can see the code
=RCHGetTableCell("http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=&A2,1, ">Annual Earnings Estimates",,,,1)
i am trying to extract the row consisting 12-12, 12-13 along with the row consisting $ and growth%
but it justs give me errrors after errors
any advice on this issue?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> On Mon, Apr 8, 2013 at 10:08 PM, weekeewawa <weekeewawa@...> wrote:
>
> >
> > there are 2 questions i need to ask
> >
> > 1) for learning, what is the '<tr' means and for
> >
>
> It was just a quick way to get to the next row of data. Another option
> would have been to do this, which uses the "skip # of rows" parameter:
>
> =RCHGetTableCell("
> http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=MMM ",
> 2,">Total Returns %",,,,1)
>
> 2) over at
> >
> > http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=mmm
> >
> > under the section price/dividends/splits > 5 year history
> >
> > i am able to get the first row, 5 Year History,Splits and dividends
> >
> > and amount per share
> >
> > however, the problem lies in the 2nd row and beyond
> >
> > as you can see the second row shows
> >
> > 02-13-13 Cash Dividend 0.635000
> >
> > all the way down to
> >
> > 02-18-09 cash dividend 0.510000
> >
> > i tried using the code
> >
> > =RCHGetTableCell("
> > http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=MMM,1, ">5
> > Year History","<tr")
> >
> > but it is able to only get the 2nd row but not thee 3rd and beyond
> >
> > is there any solution for this problem
> >
>
> You can use that same "skip # of rows" parameter in the last formula. For
> example:
>
> =RCHGetTableCell("
> http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=MMM ",1,">5
> Year History",,,,1)
> =RCHGetTableCell("
> http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=MMM ",1,">5
> Year History",,,,3)
>
as you can see the code
=RCHGetTableCell(
i am trying to extract the row consisting 12-12, 12-13 along with the row consisting $ and growth%
but it justs give me errrors after errors
any advice on this issue?
--- In smf_addin@yahoogrou
>
> On Mon, Apr 8, 2013 at 10:08 PM, weekeewawa <weekeewawa@
>
> >
> > there are 2 questions i need to ask
> >
> > 1) for learning, what is the '<tr&#
> >
>
> It was just a quick way to get to the next row of data. Another option
> would have been to do this, which uses the "skip # of rows" parameter:
>
> =RCHGetTableCell(
> http://quicktake.
> 2,">
>
> 2) over at
> >
> > http://quicktake.
> >
> > under the section price/dividends/
> >
> > i am able to get the first row, 5 Year History,Splits and dividends
> >
> > and amount per share
> >
> > however, the problem lies in the 2nd row and beyond
> >
> > as you can see the second row shows
> >
> > 02-13-13 Cash Dividend 0.635000
> >
> > all the way down to
> >
> > 02-18-09 cash dividend 0.510000
> >
> > i tried using the code
> >
> > =RCHGetTableCell(
> > http://quicktake.
> > Year History"
> >
> > but it is able to only get the 2nd row but not thee 3rd and beyond
> >
> > is there any solution for this problem
> >
>
> You can use that same "skip # of rows" parameter in the last formula. For
> example:
>
> =RCHGetTableCell(
> http://quicktake.
> Year History"
> =RCHGetTableCell(
> http://quicktake.
> Year History"
>
Tue Apr 9, 2013 1:54 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
That formula can't be what you are using.
You do need to look at the source code of the web page to see how things
are coded. You would find out your search term is *not* what is in the
source code. And that a table is coded within a table.
Also, there is an issue with MorningStar web pages -- the default of
RCHGetTableCell() is that the "end of the page" is the "</body" HTML tag,
which is used when you need to skip rows. However, MorningStar doesn't code
that tag, so you'll get errors using the default. You need something like
this to account for that HTML coding error:
=RCHGetTableCell("
http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=MMM ",
2,"Earnings Estimates","<table",,,1,"</table")
I'd suggest you play with those parameters on the "By Table Cell" worksheet
of the smfGetTagContent-Quick-Webpage-Examination.xls template.
On Tue, Apr 9, 2013 at 1:07 AM, weekeewawa <weekeewawa@yahoo.com > wrote:
> and it brings me to another point
>
> as you can see the code
>
> =RCHGetTableCell("
> http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=&A2,1, ">Annual
> Earnings Estimates",,,,1)
>
> i am trying to extract the row consisting 12-12, 12-13 along with the row
> consisting $ and growth%
>
> but it justs give me errrors after errors
>
> any advice on this issue?
>
You do need to look at the source code of the web page to see how things
are coded. You would find out your search term is *not* what is in the
source code. And that a table is coded within a table.
Also, there is an issue with MorningStar web pages -- the default of
RCHGetTableCell(
which is used when you need to skip rows. However, MorningStar doesn't code
that tag, so you'll get errors using the default. You need something like
this to account for that HTML coding error:
=RCHGetTableCell(
http://quicktake.
2,"Earnings Estimates"
I'd suggest you play with those parameters on the "By Table Cell" worksheet
of the smfGetTagContent-
On Tue, Apr 9, 2013 at 1:07 AM, weekeewawa <weekeewawa@yahoo.
> and it brings me to another point
>
> as you can see the code
>
> =RCHGetTableCell(
> http://quicktake.
> Earnings Estimates"
>
> i am trying to extract the row consisting 12-12, 12-13 along with the row
> consisting $ and growth%
>
> but it justs give me errrors after errors
>
> any advice on this issue?
>
Tue Apr 9, 2013 12:26 am (PDT) . Posted by:
"R" venkat1926
I regularly use smf addin for downloading some Indian stocks-current prices. I have added the yahoo parameter d1 for date. I fibd recentlly the dates are NOT current. for e.g. the dates of some stocks is 18 macrch 2013. Is this ereror due to yahoo finance or in my change of code. the relevant code in the macro amended by me is
'==================================Sub test()
j = 1
'url = "http://quote.yahoo.com/d/quotes.csv?s= " & S & "&f=ohl1c1p2pvd1t1g&e=.csv"
url = "http://quote.yahoo.com/d/quotes.csv?s= " & S & "&f=l1p2ohgvd1t1&;e=.csv"
' With ActiveWorkbook.Worksheets("Data").QueryTables.Add( _
Connection:="URL;" & url, Destination:=rg.Offset(j - 1,
With ActiveWorkbook.ActiveSheet.QueryTables.Add( _
Connection:="URL;" & url, Destination:=Range("B2"))
.BackgroundQuery = False
.RefreshPeriod = 0
.TablesOnlyFromHTML = False
.RefreshStyle = xlOverwriteCells
.Refresh BackgroundQuery:=False
.SaveData = True
End With
'============================
for test purpose i am giving a few stock symbols(some give correct date and some wrong date)
AXISBANK.NS
BAJAJAUT.BO
BHARATFOR.NS
my OS windows 7 and aexcel 2007 (comptability mode)
'=======
j = 1
'url = "http://quote.
url = "http://quote.
' With ActiveWorkbook.
Connection:=
With ActiveWorkbook.
Connection:=
.BackgroundQuery = False
.RefreshPeriod = 0
.TablesOnlyFromHTML = False
.RefreshStyle = xlOverwriteCells
.Refresh BackgroundQuery:
.SaveData = True
End With
'=======
for test purpose i am giving a few stock symbols(some give correct date and some wrong date)
AXISBANK.NS
BAJAJAUT.BO
BHARATFOR.NS
my OS windows 7 and aexcel 2007 (comptability mode)
Tue Apr 9, 2013 1:38 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I get 4/9/2013 for all three ticker symbols you listed. Even with the URL
you are using.
But your code has nothing to do with the add-in...
On Tue, Apr 9, 2013 at 12:26 AM, R <venkat1926@yahoo.com > wrote:
> I regularly use smf addin for downloading some Indian stocks-current
> prices. I have added the yahoo parameter d1 for date. I fibd recentlly the
> dates are NOT current. for e.g. the dates of some stocks is 18 macrch 2013.
> Is this ereror due to yahoo finance or in my change of code. the relevant
> code in the macro amended by me is
>
>
> '==================================Sub test()
>
> j = 1
> 'url = "http://quote.yahoo.com/d/quotes.csv?s= " & S &
> "&f=ohl1c1p2pvd1t1g&e=.csv"
> url = "http://quote.yahoo.com/d/quotes.csv?s= " & S &
> "&f=l1p2ohgvd1t1&;e=.csv"
>
> ' With ActiveWorkbook.Worksheets("Data").QueryTables.Add( _
> Connection:="URL;" & url, Destination:=rg.Offset(j - 1,
> With ActiveWorkbook.ActiveSheet.QueryTables.Add( _
> Connection:="URL;" & url, Destination:=Range("B2"))
>
>
> .BackgroundQuery = False
> .RefreshPeriod = 0
> .TablesOnlyFromHTML = False
> .RefreshStyle = xlOverwriteCells
> .Refresh BackgroundQuery:=False
> .SaveData = True
> End With
>
>
> '============================
> for test purpose i am giving a few stock symbols(some give correct date
> and some wrong date)
>
> AXISBANK.NS
> BAJAJAUT.BO
> BHARATFOR.NS
>
> my OS windows 7 and aexcel 2007 (comptability mode)
>
you are using.
But your code has nothing to do with the add-in...
On Tue, Apr 9, 2013 at 12:26 AM, R <venkat1926@yahoo.
> I regularly use smf addin for downloading some Indian stocks-current
> prices. I have added the yahoo parameter d1 for date. I fibd recentlly the
> dates are NOT current. for e.g. the dates of some stocks is 18 macrch 2013.
> Is this ereror due to yahoo finance or in my change of code. the relevant
> code in the macro amended by me is
>
>
> '=======
>
> j = 1
> 'url = "http://quote.
> "&f=
> url = "http://quote.
> "&f=
>
> ' With ActiveWorkbook.
> Connection:=
> With ActiveWorkbook.
> Connection:=
>
>
> .BackgroundQuery = False
> .RefreshPeriod = 0
> .TablesOnlyFromHTML = False
> .RefreshStyle = xlOverwriteCells
> .Refresh BackgroundQuery:
> .SaveData = True
> End With
>
>
> '=======
> for test purpose i am giving a few stock symbols(some give correct date
> and some wrong date)
>
> AXISBANK.NS
> BAJAJAUT.BO
> BHARATFOR.NS
>
> my OS windows 7 and aexcel 2007 (comptability mode)
>
Tidak ada komentar:
Posting Komentar