8 New Messages
Digest #2747
Messages
Tue Aug 27, 2013 6:57 am (PDT) . Posted by:
mlawson3
If you need to delegate any of the re-work for ADVFN, toss some
my way. If not...well, good luck and thanks for the work.
~ML
--- In smf_addin@yahoogrou
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@
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.
international-
<http://www.advfn.
iness-machines-
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.
iness-machines-
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?..
your great work and help!
Tue Aug 27, 2013 2:03 pm (PDT) . Posted by:
"codyklein" codyklein
The ADVFN site isn't even working right if you try and go back to get annual data starting in 2003 or so it takes you to the wrong page, it kicks you back to the summary page.
Tue Aug 27, 2013 2:07 pm (PDT) . Posted by:
"mutantcar" mutantcar
Hi Randy,
I'm having a problem with the High/Low returned being incorrect eg. NBU.L (LSE:AIM) for 27/Aug/2013. Both showing as 65, when Open was 72.5, Close 73.8.
Looking at the Yahoo quote page, they're showing the Day's range as 65-65, so I assume that's the same problem. I see similar problems for many other quotes.
Any idea how I report this to Yahoo? Any way I can fix it, or could you suggest another source to be more accurate?
Thanks,
Huw.
I'm having a problem with the High/Low returned being incorrect eg. NBU.L (LSE:AIM) for 27/Aug/2013. Both showing as 65, when Open was 72.5, Close 73.8.
Looking at the Yahoo quote page, they're showing the Day's range as 65-65, so I assume that's the same problem. I see similar problems for many other quotes.
Any idea how I report this to Yahoo? Any way I can fix it, or could you suggest another source to be more accurate?
Thanks,
Huw.
Tue Aug 27, 2013 6:35 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You can report it to Yahoo via the "Send Feedback" link towards the bottom
of the page.
No clue on a more reliable source. I think you'll find all of the free
services, and even the paid services, are fraught with errors of one type
or another.
On Tue, Aug 27, 2013 at 2:07 PM, mutantcar <mutant.car@virgin.net > wrote:
>
> I'm having a problem with the High/Low returned being incorrect eg. NBU.L
> (LSE:AIM) for 27/Aug/2013. Both showing as 65, when Open was 72.5, Close
> 73.8.
>
> Looking at the Yahoo quote page, they're showing the Day's range as 65-65,
> so I assume that's the same problem. I see similar problems for many other
> quotes.
>
> Any idea how I report this to Yahoo? Any way I can fix it, or could you
> suggest another source to be more accurate?
>
of the page.
No clue on a more reliable source. I think you'll find all of the free
services, and even the paid services, are fraught with errors of one type
or another.
On Tue, Aug 27, 2013 at 2:07 PM, mutantcar <mutant.car@virgin.
>
> I'm having a problem with the High/Low returned being incorrect eg. NBU.L
> (LSE:AIM) for 27/Aug/2013. Both showing as 65, when Open was 72.5, Close
> 73.8.
>
> Looking at the Yahoo quote page, they're showing the Day's range as 65-65,
> so I assume that's the same problem. I see similar problems for many other
> quotes.
>
> Any idea how I report this to Yahoo? Any way I can fix it, or could you
> suggest another source to be more accurate?
>
Tue Aug 27, 2013 11:41 pm (PDT) . Posted by:
"mutantcar" mutantcar
Oh I see. Thanks:-(
I've since noticed though, that the 'Historical Data' Yahoo link seems correct. For this instance at least.
In the dark days before I discovered smf-addin, I had a macro to download this data. I assume I can collect this using smf-addin though? Is there an easy way to switch RCHGetYahooQuotes to the High/Low shown on the Historical Data, or do I need to use another function for this?
Thanks again!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> You can report it to Yahoo via the "Send Feedback" link towards the bottom
> of the page.
>
> No clue on a more reliable source. I think you'll find all of the free
> services, and even the paid services, are fraught with errors of one type
> or another.
>
> On Tue, Aug 27, 2013 at 2:07 PM, mutantcar <mutant.car@...> wrote:
>
> >
> > I'm having a problem with the High/Low returned being incorrect eg. NBU.L
> > (LSE:AIM) for 27/Aug/2013. Both showing as 65, when Open was 72.5, Close
> > 73.8.
> >
> > Looking at the Yahoo quote page, they're showing the Day's range as 65-65,
> > so I assume that's the same problem. I see similar problems for many other
> > quotes.
> >
> > Any idea how I report this to Yahoo? Any way I can fix it, or could you
> > suggest another source to be more accurate?
> >
>
I've since noticed though, that the 'Historical Data' Yahoo link seems correct. For this instance at least.
In the dark days before I discovered smf-addin, I had a macro to download this data. I assume I can collect this using smf-addin though? Is there an easy way to switch RCHGetYahooQuotes to the High/Low shown on the Historical Data, or do I need to use another function for this?
Thanks again!
--- In smf_addin@yahoogrou
>
> You can report it to Yahoo via the "Send Feedback" link towards the bottom
> of the page.
>
> No clue on a more reliable source. I think you'll find all of the free
> services, and even the paid services, are fraught with errors of one type
> or another.
>
> On Tue, Aug 27, 2013 at 2:07 PM, mutantcar <mutant.car@
>
> >
> > I'm having a problem with the High/Low returned being incorrect eg. NBU.L
> > (LSE:AIM) for 27/Aug/2013. Both showing as 65, when Open was 72.5, Close
> > 73.8.
> >
> > Looking at the Yahoo quote page, they're showing the Day's range as 65-65,
> > so I assume that's the same problem. I see similar problems for many other
> > quotes.
> >
> > Any idea how I report this to Yahoo? Any way I can fix it, or could you
> > suggest another source to be more accurate?
> >
>
Wed Aug 28, 2013 12:11 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
RCHGetYahooQuotes() cannot be redirected to anything else, since it uses a
CSV file provided by Yahoo. The function is really only a little bit more
than a CSV parser. It's not even aware of what the individual fields are.
You can pick up the high-low from other sources using other functions.
Either RCHGetYahooHistory() or RCHGetTableCell() would work for the
high-low from the historical quotes CSV feed or web page.
On Tue, Aug 27, 2013 at 11:41 PM, mutantcar <mutant.car@virgin.net > wrote:
> Oh I see. Thanks:-(
>
> I've since noticed though, that the 'Historical Data' Yahoo link seems
> correct. For this instance at least.
>
> In the dark days before I discovered smf-addin, I had a macro to download
> this data. I assume I can collect this using smf-addin though? Is there an
> easy way to switch RCHGetYahooQuotes to the High/Low shown on the
> Historical Data, or do I need to use another function for this?
>
>
>
CSV file provided by Yahoo. The function is really only a little bit more
than a CSV parser. It's not even aware of what the individual fields are.
You can pick up the high-low from other sources using other functions.
Either RCHGetYahooHistory(
high-low from the historical quotes CSV feed or web page.
On Tue, Aug 27, 2013 at 11:41 PM, mutantcar <mutant.car@virgin.
> Oh I see. Thanks:-(
>
> I've since noticed though, that the 'Historical Data' Yahoo link seems
> correct. For this instance at least.
>
> In the dark days before I discovered smf-addin, I had a macro to download
> this data. I assume I can collect this using smf-addin though? Is there an
> easy way to switch RCHGetYahooQuotes to the High/Low shown on the
> Historical Data, or do I need to use another function for this?
>
>
>
Tue Aug 27, 2013 7:34 pm (PDT) . Posted by:
"Jo-Jo Smith" invective2
I decided that after leaching for years, I would try to contribute something, so I decided to update smfGetADVFNElement(), which is the function I use most of all.
I was able to reverse engineer the new AdvFn prototype (they already have it exposed, but I don't think you can navigate to it with the front panel controls). The new addresses are a little trickier than the old ones, as the company name and exchange are included, and it isn't always obvious what they decided to name the company, which makes grabbing the data arrays kind of wacky. The exchange addition is actually an improvement, although it complicates things a little. I already got around it
I'm not much of a VB developer (I usually work with embedded C/C++), so there are still several things I need to figure out (like proper XML parsing), which would probably be a lot easier for someone who actually knows VB, but I have the bulk of it done. I can use the function and it usually returns the proper data, but I haven't tested it too much. I only just started working on it.
I'm not sure how far you guys have gotten with the new AdvFn stuff, or if my code will even be usable (since I don't really know VB), but I thought I would offer anyway. I don't know the procedure for submitting code, so I'll just paste a sample here (I hope that's OK). Let me know if you are interested in more. The important part of what I changed is as follows:
sURL = "http://www.advfn.com/p.php?pid=ss&s= " + pTicker
sCompanyList = smfGetWebPage(sURL, pUseIE, 0)
tempArray() = Split(sCompanyList, """n"":""")
sCompanyList = tempArray(1)
tempArray() = Split(sCompanyList, """")
sCompanyName = tempArray(0)
'From inspection I think there will always be 17 elements, and we want the last one, but mgaic numbers should probably not be used.
sExchange = tempArray(16)
'It appears that the new AdvFN queries are case sensitive. Company name must be all lower case.
sCompanyName = LCase(sCompanyName)
'It appears that the new AdvFN queries are case sensitive. ticker must be all upper case.
pTicker = UCase(pTicker)
sCompanyRequest = sCompanyName + " " + pTicker
sCompanyRequest = CleanTheString(sCompanyRequest)
sCompanyRequest = Replace(sCompanyRequest, " ", "-")
'The following won't return the full set of historical data unless we know the exact data location already.
'If we know the user just wants newer data, chop off the part after the "?", and the string returned will be much smaller.
sURL = "http://www.advfn.com/common/financial/ " + sExchange + "/" + sCompanyRequest + "/full-financials?isfull=1&bsfull=1&cffull=1"
Most of the rest is parsing the data returned, which any VB developer can probably do better than I. Hopefully I can figure out how to improve the second query. And hopefully AdvFn doesn't change their prototype around too much before officially releasing it into the wild.
~Jo-Jo
I was able to reverse engineer the new AdvFn prototype (they already have it exposed, but I don't think you can navigate to it with the front panel controls). The new addresses are a little trickier than the old ones, as the company name and exchange are included, and it isn't always obvious what they decided to name the company, which makes grabbing the data arrays kind of wacky. The exchange addition is actually an improvement, although it complicates things a little. I already got around it
I'm not much of a VB developer (I usually work with embedded C/C++), so there are still several things I need to figure out (like proper XML parsing), which would probably be a lot easier for someone who actually knows VB, but I have the bulk of it done. I can use the function and it usually returns the proper data, but I haven't tested it too much. I only just started working on it.
I'm not sure how far you guys have gotten with the new AdvFn stuff, or if my code will even be usable (since I don't really know VB), but I thought I would offer anyway. I don't know the procedure for submitting code, so I'll just paste a sample here (I hope that's OK). Let me know if you are interested in more. The important part of what I changed is as follows:
sURL = "http://www.advfn.
sCompanyList = smfGetWebPage(
tempArray() = Split(sCompanyList, ""
sCompanyList = tempArray(1)
tempArray() = Split(sCompanyList, ""
sCompanyName = tempArray(0)
'From inspection I think there will always be 17 elements, and we want the last one, but mgaic numbers should probably not be used.
sExchange = tempArray(16)
'It appears that the new AdvFN queries are case sensitive. Company name must be all lower case.
sCompanyName = LCase(sCompanyName)
'It appears that the new AdvFN queries are case sensitive. ticker must be all upper case.
pTicker = UCase(pTicker)
sCompanyRequest = sCompanyName + " " + pTicker
sCompanyRequest = CleanTheString(
sCompanyRequest = Replace(sCompanyReq
'The following won't return the full set of historical data unless we know the exact data location already.
'If we know the user just wants newer data, chop off the part after the "?"
sURL = "http://www.advfn.
Most of the rest is parsing the data returned, which any VB developer can probably do better than I. Hopefully I can figure out how to improve the second query. And hopefully AdvFn doesn't change their prototype around too much before officially releasing it into the wild.
~Jo-Jo
Tue Aug 27, 2013 11:51 pm (PDT) . Posted by:
"Jovica Bozic" jovica.bozic
Thank you.
--- In smf_addin@yahoogroups.com , "Jo-Jo Smith" <invective2@...> wrote:
>
> 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?
> >
>
--- In smf_addin@yahoogrou
>
> 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@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