8 New Messages
Digest #2746
Messages
Mon Aug 26, 2013 6:27 am (PDT) . Posted by:
"JCHyjun" JCHyjun
Folks,
I did not follow all messages, so sorry if following is old news.
I contacted ADVFN: they are changing data feed and new format will be available after (about) September 1, 2013.
J.C. H.
I did not follow all messages, so sorry if following is old news.
I contacted ADVFN: they are changing data feed and new format will be available after (about) September 1, 2013.
J.C. H.
Mon Aug 26, 2013 6:57 am (PDT) . Posted by:
"Russell M" rerussellson
I have been in contact with ADVFN as well...Sounds like Tuesday is the
day = Warren - a very helpful support specialist - provided this update
to me on August 23rd:
Sorry for the delay. Financials prototype is now available. Here's a
link to financials for IBM
http://www.advfn.com/common/ financial/NYSE/ibm- international-business-
machines-IBM/full-financials? pm=Q
<http://www.advfn.com/common/financial/NYSE/ibm-international-business-m\
achines-IBM/full-financials?pm=Q >
Our feed processor is still pulling data and updating all the companies.
It is expected by tuesday all the data will be available. For sections
like Income Statement or Balance Sheet, you can click "Full History
<http://www.advfn.com/common/financial/NYSE/ibm-international-business-m\
achines-IBM/full-financials?pm=Q&isfull=1 > " to see all the entries
available for that section.
At the top there is a symbol selector just above the company name. This
is so you can select financials for different companies.
Randy - Will the SMF have updated links to ADVFN or should we think
about sourcing similar data elsewhere?...and thanks for your great work
and help!
--- In smf_addin@yahoogroups.com , "JCHyjun" wrote:
>
> Folks,
> I did not follow all messages, so sorry if following is old news.
> I contacted ADVFN: they are changing data feed and new format will be
available after (about) September 1, 2013.
> J.C. H.
>
day = Warren - a very helpful support specialist - provided this update
to me on August 23rd:
Sorry for the delay. Financials prototype is now available. Here's a
link to financials for IBM
http://www.advfn.
machines-IBM/
<http://www.advfn.
achines-IBM/
Our feed processor is still pulling data and updating all the companies.
It is expected by tuesday all the data will be available. For sections
like Income Statement or Balance Sheet, you can click "Full History
<http://www.advfn.
achines-IBM/
available for that section.
At the top there is a symbol selector just above the company name. This
is so you can select financials for different companies.
Randy - Will the SMF have updated links to ADVFN or should we think
about sourcing similar data elsewhere?..
and help!
--- In smf_addin@yahoogrou
>
> Folks,
> I did not follow all messages, so sorry if following is old news.
> I contacted ADVFN: they are changing data feed and new format will be
available after (about) September 1, 2013.
> J.C. H.
>
Mon Aug 26, 2013 7:52 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It looks to me like a large number of line items are going to be going away
in the new prototype.
I'm not even sure I want to redefine the element numbers, because with a
new data provider, the new line item may not mean the same thing as the old
one.
I hate when they do things like this.
On Mon, Aug 26, 2013 at 6:57 AM, Russell M <ru88ell@gmail.com > wrote:
>
> I have been in contact with ADVFN as well...Sounds like Tuesday is the day
> = Warren - a very helpful support specialist - provided this update to me
> on August 23rd:
>
> *Sorry for the delay. Financials prototype is now **available. Here's a
> link to financials for IBM
>
> http://www.advfn.com/common/ financial/NYSE/ibm- international-business-
> machines-IBM/full-financials? pm=Q<http://www.advfn.com/common/financial/NYSE/ibm-international-business-machines-IBM/full-financials?pm=Q >
>
> Our feed processor is still pulling data and updating all the companies. It
> is expected by tuesday all the data will be available. For sections like
> Income Statement or Balance Sheet, you can click "Full History<http://www.advfn.com/common/financial/NYSE/ibm-international-business-machines-IBM/full-financials?pm=Q&isfull=1 >"
> to see all the entries available for that section.
>
> At the top there is a symbol selector just above the company name. This is
> so you can select financials for different companies.*
>
> Randy - Will the SMF have updated links to ADVFN or should we think about
> sourcing similar data elsewhere?...and thanks for your great work and help!
>
>
in the new prototype.
I'm not even sure I want to redefine the element numbers, because with a
new data provider, the new line item may not mean the same thing as the old
one.
I hate when they do things like this.
On Mon, Aug 26, 2013 at 6:57 AM, Russell M <ru88ell@gmail.
>
> I have been in contact with ADVFN as well...Sounds like Tuesday is the day
> = Warren - a very helpful support specialist - provided this update to me
> on August 23rd:
>
> *Sorry for the delay. Financials prototype is now **available. Here's a
> link to financials for IBM
>
> http://www.advfn.
> machines-IBM/
>
> Our feed processor is still pulling data and updating all the companies. It
> is expected by tuesday all the data will be available. For sections like
> Income Statement or Balance Sheet, you can click "Full History<http://www.advfn.
> to see all the entries available for that section.
>
> At the top there is a symbol selector just above the company name. This is
> so you can select financials for different companies.*
>
> Randy - Will the SMF have updated links to ADVFN or should we think about
> sourcing similar data elsewhere?..
>
>
Mon Aug 26, 2013 7:24 am (PDT) . Posted by:
"cs.holdings" cs.holdings
Makes sense. Thanks
--- In smf_addin@yahoogrou
>
> Please don't download that much data. If you need that much, get something
> like AAII's Stock Investor Pro. Overuse of the free data sources just gives
> them an excuse to change their web pages so something like the add-in can
> no longer work. The add-in is meant for ad hoc data retrieval, not for
> building databases. You should use a good screening tool to get down to a
> workable set of companies that you want more detailed data on.
>
> It won't do you any good to go above 999 rows anyway, since the add-in can
> only extract data from 1000 web pages in a session. Anything beyond the
> 1000 web pages will just return an error message.
>
> On Sun, Aug 25, 2013 at 6:12 PM, cs.holdings <pc_babe@
>
> >
> > If I wanted to exceed 999 on the number of rows to loop, in which module
> > can I find the code?
> >
>
Mon Aug 26, 2013 7:26 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Just expand the array to as many rows as you need. I have pulled price
history well past 999 rows.
Kermit
-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of cs.holdings
Sent: Sunday, August 25, 2013 9:13 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: write a similar loop
Hi Randy
If I wanted to exceed 999 on the number of rows to loop, in which module can
I find the code?
Thnx
--- In smf_addin@yahoogroups.com , "cs.holdings" <pc_babe@...> wrote:
>
> OMG ... beautiful. Thanks
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > Just use the smfUpdateDownloadTable process. See the LINKS area of
> > the group for more info.
> >
> > On Sat, Aug 24, 2013 at 7:09 PM, cs.holdings <pc_babe@> wrote:
> >
> > >
> > > Is there a way to run a similar loop for
=RCHGetElementNumber(A1:A3,5296)?
> > >
> > > 'Sub Test()
> > > ' Dim sItems As String
> > > ' Dim oCell As Range
> > > ' sItems = "D"
> > > ' For Each oCell In [B4:Z4]
> > > ' If oCell.Value2 = "" Then Exit For
> > > ' Range(oCell.Offset(1, 0), oCell.Offset(1350, 0)) =
> > > RCHGetYahooHistory(oCell.Value2, pResort:=1, pItems:=sItems,
> > > pDim1:=1350,
> > > pDim2:=1)
> > > ' sItems = "A"
> > > ' Next oCell
> > > ' End Sub
> > >
> >
>
------------------------------------
Yahoo! Groups Links
history well past 999 rows.
Kermit
-----Original Message-----
From: smf_addin@yahoogrou
Of cs.holdings
Sent: Sunday, August 25, 2013 9:13 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] Re: write a similar loop
Hi Randy
If I wanted to exceed 999 on the number of rows to loop, in which module can
I find the code?
Thnx
--- In smf_addin@yahoogrou
>
> OMG ... beautiful. Thanks
>
> --- In smf_addin@yahoogrou
> >
> > Just use the smfUpdateDownloadTa
> > the group for more info.
> >
> > On Sat, Aug 24, 2013 at 7:09 PM, cs.holdings <pc_babe@
> >
> > >
> > > Is there a way to run a similar loop for
=RCHGetElementNumbe
> > >
> > > 'Sub Test()
> > > ' Dim sItems As String
> > > ' Dim oCell As Range
> > > ' sItems = "D"
> > > ' For Each oCell In [B4:Z4]
> > > ' If oCell.Value2 = "" Then Exit For
> > > ' Range(oCell.
> > > RCHGetYahooHistory(
> > > pDim1:=1350,
> > > pDim2:=1)
> > > ' sItems = "A"
> > > ' Next oCell
> > > ' End Sub
> > >
> >
>
------------
Yahoo! Groups Links
Mon Aug 26, 2013 7:53 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
We're not talking about price history...
On Mon, Aug 26, 2013 at 7:26 AM, Kermit W. Prather
<kermitp@tampabay.rr.com >wrote:
> Just expand the array to as many rows as you need. I have pulled price
> history well past 999 rows.
>
>
On Mon, Aug 26, 2013 at 7:26 AM, Kermit W. Prather
<kermitp@tampabay.
> Just expand the array to as many rows as you need. I have pulled price
> history well past 999 rows.
>
>
Mon Aug 26, 2013 2:00 pm (PDT) . Posted by:
"Jovica Bozic" jovica.bozic
I've been using Advfn financials for a while, but recently noticed that data on the site is not up to date (e.g. AAPL 3rd Q financial data will be available soon, but on Advfn site last quarter for AAPL is 1st Q March/2013).
Does anyone know what's going on, is this permanent, 'cause all my calculations are based on their data?
Is there similar site that has detailed financials for more then 4 years?
Does anyone know what's going on, is this permanent, 'cause all my calculations are based on their data?
Is there similar site that has detailed financials for more then 4 years?
Tue Aug 27, 2013 12:31 am (PDT) . Posted by:
"Jo-Jo Smith" invective2
There is another thread about this issue. AdvFn is in the process of changing their site. It is supposed to be done soon, although I assume the current SMF Add-in won't work right with the new site.
If you need another site that has older data, you can try GuruFocus. They have ten trailing years of data.
--- In smf_addin@yahoogroups.com , "Jovica Bozic" <jovica.bozic@...> wrote:
>
> I've been using Advfn financials for a while, but recently noticed that data on the site is not up to date (e.g. AAPL 3rd Q financial data will be available soon, but on Advfn site last quarter for AAPL is 1st Q March/2013).
>
> Does anyone know what's going on, is this permanent, 'cause all my calculations are based on their data?
>
> Is there similar site that has detailed financials for more then 4 years?
>
If you need another site that has older data, you can try GuruFocus. They have ten trailing years of data.
--- In smf_addin@yahoogrou
>
> I've been using Advfn financials for a while, but recently noticed that data on the site is not up to date (e.g. AAPL 3rd Q financial data will be available soon, but on Advfn site last quarter for AAPL is 1st Q March/2013).
>
> Does anyone know what's going on, is this permanent, 'cause all my calculations are based on their data?
>
> Is there similar site that has detailed financials for more then 4 years?
>
Tidak ada komentar:
Posting Komentar