7 New Messages
Digest #2882
Messages
Mon Dec 2, 2013 8:11 am (PST) . Posted by:
jovica.bozic
Data is completely messed up. As I've posted earlier on ADVFN their data is unusable...at the moment
http://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/24655
I am using some1s version that is uploaded here, only difference is that mine is with different function :
=RCHGetHTMLTable(AnnURL,"Income Statement Page",-1,"Period Ending",1)
=RCHGetHTMLTable(AnnURL,"Balance Sheet Page",-1,"Period Ending",5)
=RCHGetHTMLTable(AnnURL,"Cash Flow Page",-1,"Net Income",3)
Quartersare completely messed up and unusable..
AnnURL is based on link, stock-exchange, ticker and full name of a company, all that (whole table) is already uploaded here (ADVFN database crawler.xlsm http://f1.grp.yahoofs.com/v1/YLCcUrC6EHjOFBkUGM5GZvP-KLh4gidJIrjBPIwWrujLehGfQBD_aQ7qepLnhDttDvZNtgBQpEJLQyJlsj6eoK6aUpuos5oDGg/Uploads%20by%20forum%20members/ADVFN%20database%20crawler.xlsm)
---In smf_addin@yahoogroups.com, <friedman_steve@...> wrote:
jovica.bozic.....
I wondered the same thing about using RCHGetHTMLTable, but I couldn't quite get mine to work. Could you upload or share your speedier version?
And great work to both of you. Thanks.
---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:
Great work. Thank you.
Why not use RCHGetHTMLTable with index/match function? Data retrieval time is much faster?
Didn't have time to finish complete workbook, but with 10yr financial + 10 quarters and with Income statement
completed (index/match) it takes only 4 seconds to retrieve data.
---In smf_addin@yahoogroups.com, <scasty@...> wrote:
John, thanks for creating that spreadsheet. Any clue why NASDAQ:ATVI is not working with your spreadsheet? Can't figure it out. I did notice one thing though-- ATVI is not part of your webcrawler spreadsheet.
---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:
I was impressed with yweinstock's work but found that ADVFN had changed their structure again, making the URLs not work. I took his spreadsheet and updated it to work with the ADVFN's new structure. I left the URL in one cell so that if they change it again, it will be easy to update. The resulting spr
dmatu2000's discovery of the "company-" placeholder was a big help, but it doesn't work to pages with 10 years of financial data. The site redirects you to the page with the company that only shows 5 years of data. The only way that I could figure out to work around that is to use a lookup table in Excel that lists the ADVFN URL "company name" for each ticker symbol. So you enter the ticker, the table populates the URL company name and exchange, then sends the fully formed URL to ADVFN.com. I populated it with about the top 3000 companies.
The resulting spreadsheet is uploaded to the "Upload by Forum Members" directory. I hope that you find it helpful.
--- In smf_addin@yahoogroups.com, <david_matuszak@...> wrote:
I was up late last night and made some progress
The info that bushpilote provided helped. However, I am unable to retrieve anything prior to 2012 for the financial statements. And I am unable to retrieve anything prior to 2009 for the ratios.
Replying to what bushpilote said here: "In ADVFN's beta version access to a company's financial data requires both the company name (the name they have in their database) and ticker along with the exchange ticker symbol."
After poking around, I've been able to get this path to work:
http://www.advfn.com/common/financial/"&Exchange&"/company-"&Ticker&"/full-financials?isfull=1&bsfull=1&cffull=1
Meaning the company name is not required as long as there is a placeholder.
--- In smf_addin@yahoogroups.com, <david_matuszak@...> wrote:
yweinstock your work is superb.
Did you have any luck with bushpilote's suggestions? I've been trying to get it to work but still having issues.
--- In smf_addin@yahoogroups.com, <david_matuszak@...> wrote:
Does anyone have an update on ADVFN? Are they still working on their layout?
--- In smf_addin@yahoogroups.com, <bushpilote@...> wrote:
yweinstock your great work on the new ADVFN financial template is not all for not. The reason for the errors is that in both the annual and quartely data the url's are incorrect.
To pull in the ANNUAL data for microsoft replace in the RCHGetTableCell formula "http://www.advfn.com/common/financial/"&Exchange&"/"&TickerADVFN&"/financials?btn=annual_reports&mode=company_data&isfull=1&bsfull=1&cffull=1&effull=1&vrfull=1&grfull=1&fhfull=1&prfull=1" with "
"http://www.advfn.com/common/financial/NASDAQ/microsoft-MSFT/full-financials?isfull=1&bsfull=1&cffull=1"
and for the QUARTELY data replace "http://www.advfn.com/exchanges/"&Exchange&"/"&Ticker&"/financials?btn=annual_reports&mode=company_data&isfull=1&bsfull=1&cffull=1&effull=1&vrfull=1&grfull=1&fhfull=1&prfull=1&pm=Q"
with "http://www.advfn.com/common/financial/NASDAQ/microsoft-MSFT/full-financials?isfull=1&bsfull=1&cffull=1&pm=Q"
.....leave the remaining content of the RCHGetTableCell formula as is in both cases.
Replacing "microsoft-MSFT" with "intel-INTC" will get you Intel's financials. For IBM's financials you replace NASDAQ with NYSE and "microsoft-MSFT" with "ibm-international-business-machines-IBM".
In ADVFN's beta version access to a company's financial data requires both the company name (the name they have in their database) and ticker along with the exchange ticker symbol. It remains to be seen if the need to use the company's name will be the new norm once they go live with their redesigned website.
Hope this helps.
--- In smf_addin@yahoogroups.com, <yweinsto@...> wrote:
Yeah.... Looks like I spoke too soon.
The spreadsheet returns errors now as the site reverted to the old structure. Perhaps we caught a glimpse of an unintended early release. Guess it's back to the waiting game..
--- In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Exactly. They don't seem to have their act together at all.
Makes me have second thoughts about the quality of the data!
On Wed, Sep 11, 2013 at 10:36 AM, <petekoch@... https://mail.google.com/mail/?view=cm&fs=1&tf=1&to=petekoch@...> wrote:
It appears that AdvFN is going to be day-to-day for a while. Consider any changes you make to be temporary.
http://groups.
I am using some1s version that is uploaded here, only difference is that mine is with different function :
=RCHGetHTMLTable(
=RCHGetHTMLTable(
=RCHGetHTMLTable(
Quartersare completely messed up and unusable..
AnnURL is based on link, stock-exchange, ticker and full name of a company, all that (whole table) is already uploaded here (ADVFN database crawler.xlsm http://f1.grp.
---In smf_addin@yahoogrou
jovica.bozic.
I wondered the same thing about using RCHGetHTMLTable, but I couldn't quite get mine to work. Could you upload or share your speedier version?
And great work to both of you. Thanks.
---In smf_addin@yahoogrou
Great work. Thank you.
Why not use RCHGetHTMLTable with index/match function? Data retrieval time is much faster?
Didn't have time to finish complete workbook, but with 10yr financial + 10 quarters and with Income statement
completed (index/match) it takes only 4 seconds to retrieve data.
---In smf_addin@yahoogrou
John, thanks for creating that spreadsheet. Any clue why NASDAQ:ATVI is not working with your spreadsheet? Can't figure it out. I did notice one thing though-- ATVI is not part of your webcrawler spreadsheet.
---In smf_addin@yahoogrou
I was impressed with yweinstock&#
dmatu2000'
The resulting spreadsheet is uploaded to the "Upload by Forum Members" directory. I hope that you find it helpful.
--- In smf_addin@yahoogrou
I was up late last night and made some progress
The info that bushpilote provided helped. However, I am unable to retrieve anything prior to 2012 for the financial statements. And I am unable to retrieve anything prior to 2009 for the ratios.
Replying to what bushpilote said here: "In ADVFN's beta version access to a company'
After poking around, I've been able to get this path to work:
http://www.advfn.
Meaning the company name is not required as long as there is a placeholder.
--- In smf_addin@yahoogrou
yweinstock your work is superb.
Did you have any luck with bushpilote&#
--- In smf_addin@yahoogrou
Does anyone have an update on ADVFN? Are they still working on their layout?
--- In smf_addin@yahoogrou
yweinstock your great work on the new ADVFN financial template is not all for not. The reason for the errors is that in both the annual and quartely data the url's are incorrect.
To pull in the ANNUAL data for microsoft replace in the RCHGetTableCell formula "http://www.advfn.
"http://www.advfn.
and for the QUARTELY data replace "http://www.advfn.
with "http://www.advfn.
.....leave the remaining content of the RCHGetTableCell formula as is in both cases.
Replacing "microsoft-
In ADVFN's beta version access to a company'
Hope this helps.
--- In smf_addin@yahoogrou
Yeah.... Looks like I spoke too soon.
The spreadsheet returns errors now as the site reverted to the old structure. Perhaps we caught a glimpse of an unintended early release. Guess it's back to the waiting game..
--- In smf_addin@yahoogrou
Exactly. They don't seem to have their act together at all.
Makes me have second thoughts about the quality of the data!
On Wed, Sep 11, 2013 at 10:36 AM, <petekoch@
It appears that AdvFN is going to be day-to-day for a while. Consider any changes you make to be temporary.
Mon Dec 2, 2013 8:52 am (PST) . Posted by:
"flangeneral" flangeneral
Hi all,
Currently I am using the following to report last price for CADUSD which works fine:
=RCHGetYahooQuotes("CADUSD=X", "l1", ,NOW())
I am trying to come up with the previous close. I tried switching "l1" with "p" but that did not work (returned N/A, whereas the Yahoo website reports the correct number).
Any suggestions?
Currently I am using the following to report last price for CADUSD which works fine:
=RCHGetYahooQuotes(
I am trying to come up with the previous close. I tried switching "l1" with "p" but that did not work (returned N/A, whereas the Yahoo website reports the correct number).
Any suggestions?
Mon Dec 2, 2013 9:33 am (PST) . Posted by:
"Randy Harmelink" rharmelink
If you're getting NA, then that is what Yahoo is posting on the CSV feed. I
think your only option would be to extract it from the web page (much
slower process if you need a lot of them).
On Mon, Dec 2, 2013 at 9:51 AM, flangeneral <jefff@rogers.com> wrote:
>
> Currently I am using the following to report last price for CADUSD which
> works fine:
>
> =RCHGetYahooQuotes("CADUSD=X", "l1", ,NOW())
>
> I am trying to come up with the previous close. I tried switching "l1"
> with "p" but that did not work (returned N/A, whereas the Yahoo website
> reports the correct number).
>
> Any suggestions?
>
think your only option would be to extract it from the web page (much
slower process if you need a lot of them).
On Mon, Dec 2, 2013 at 9:51 AM, flangeneral <jefff@rogers.
>
> Currently I am using the following to report last price for CADUSD which
> works fine:
>
> =RCHGetYahooQuotes(
>
> I am trying to come up with the previous close. I tried switching "l1"
> with "p" but that did not work (returned N/A, whereas the Yahoo website
> reports the correct number).
>
> Any suggestions?
>
Mon Dec 2, 2013 11:03 am (PST) . Posted by:
"flangeneral" flangeneral
So, if I understand correctly, the CSV feed is different from the number reported on the webpage?
I only have the one number to extract, so process time should not be an issue.
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> If you're getting NA, then that is what Yahoo is posting on the CSV feed. I
> think your only option would be to extract it from the web page (much
> slower process if you need a lot of them).
>
> On Mon, Dec 2, 2013 at 9:51 AM, flangeneral <jefff@...> wrote:
>
> >
> > Currently I am using the following to report last price for CADUSD which
> > works fine:
> >
> > =RCHGetYahooQuotes("CADUSD=X", "l1", ,NOW())
> >
> > I am trying to come up with the previous close. I tried switching "l1"
> > with "p" but that did not work (returned N/A, whereas the Yahoo website
> > reports the correct number).
> >
> > Any suggestions?
> >
>
I only have the one number to extract, so process time should not be an issue.
--- In smf_addin@yahoogrou
>
> If you're getting NA, then that is what Yahoo is posting on the CSV feed. I
> think your only option would be to extract it from the web page (much
> slower process if you need a lot of them).
>
> On Mon, Dec 2, 2013 at 9:51 AM, flangeneral <jefff@..
>
> >
> > Currently I am using the following to report last price for CADUSD which
> > works fine:
> >
> > =RCHGetYahooQuotes(
> >
> > I am trying to come up with the previous close. I tried switching "l1"
> > with "p" but that did not work (returned N/A, whereas the Yahoo website
> > reports the correct number).
> >
> > Any suggestions?
> >
>
Mon Dec 2, 2013 11:23 am (PST) . Posted by:
"Daniel Russell" udelfb92
I recently posted a UDF in the "Uploads by forum Members" titled FX
Function.xlsm
I know this isn't an SMF Add-In but it is the only way I could integrate
historical FX quotes into my portfolio tracking tools since I hedge and
trade FX quite frequently.
The function uses the convention =fxhistorical(Pair Quote, date in Excel
Date Time format)
An example would be =fxhistorical(EURUSD, "12/2/2013") and it should pull a
quote around 1.353793.
Hope this is helpful!
Danny
~OsoCapitalResearch.Com
Function.xlsm
I know this isn't an SMF Add-In but it is the only way I could integrate
historical FX quotes into my portfolio tracking tools since I hedge and
trade FX quite frequently.
The function uses the convention =fxhistorical(
Date Time format)
An example would be =fxhistorical(
quote around 1.353793.
Hope this is helpful!
Danny
~OsoCapitalResearch
Mon Dec 2, 2013 11:46 am (PST) . Posted by:
"flangeneral" flangeneral
Thanks Randy and Danny for your assitance. I resolved it with :
=RCHGetTableCell(
--- In smf_addin@yahoogrou
>
> So, if I understand correctly, the CSV feed is different from the number reported on the webpage?
>
> I only have the one number to extract, so process time should not be an issue.
>
> --- In smf_addin@yahoogrou
> >
> > If you're getting NA, then that is what Yahoo is posting on the CSV feed. I
> > think your only option would be to extract it from the web page (much
> > slower process if you need a lot of them).
> >
> > On Mon, Dec 2, 2013 at 9:51 AM, flangeneral <jefff@> wrote:
> >
> > >
> > > Currently I am using the following to report last price for CADUSD which
> > > works fine:
> > >
> > > =RCHGetYahooQuotes(
> > >
> > > I am trying to come up with the previous close. I tried switching "l1"
> > > with "p" but that did not work (returned N/A, whereas the Yahoo website
> > > reports the correct number).
> > >
> > > Any suggestions?
> > >
> >
>
Mon Dec 2, 2013 3:12 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The CSV file that Yahoo provides sometimes has NA values where the web
pages have actual values. Not sure why.
On Mon, Dec 2, 2013 at 12:03 PM, flangeneral <jefff@rogers.com> wrote:
> So, if I understand correctly, the CSV feed is different from the number
> reported on the webpage?
>
pages have actual values. Not sure why.
On Mon, Dec 2, 2013 at 12:03 PM, flangeneral <jefff@rogers.
> So, if I understand correctly, the CSV feed is different from the number
> reported on the webpage?
>
Tidak ada komentar:
Posting Komentar