11 New Messages
Digest #2447
2b
Re: Problem getting data from either Advfn and/or element numbers >4 by "Randy Harmelink" rharmelink
Messages
Wed Dec 26, 2012 7:23 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
For dividend history use this link - http://www.earnings.com/company.asp?client=cb <http://www.earnings.com/company.asp?client=cb&ticker=ainv > &ticker=ainv
Change the ticker symbol to fit your needs
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Tuesday, December 25, 2012 1:54 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Data Sources and How to Extract
For (1), I think those are proprietary. I don't know of a source from which I could extract them.
For (2), there are two items that discuss it in the LINKS area of the group.
For (3), check out the RCHGetYahooHistory() function. But it only has ex-dividend dates.
On Tue, Dec 25, 2012 at 11:33 AM, rjemery7 <rjemery@gmail.com > wrote:
1) For a given symbol, from where and how can I include from Standard & Poor's their:
a) GICS Sector and Sub-Industry information
b) Beta
c) STARS, Credit and Quality Ratings
d) Qualitative Risk Assessment
e) Relative Strength Rank
f) Fair Value Rank
g) Fair Value Calculation
h) etc.
in my spreadsheets using RCH or SMF functions?
2) How can I extract information from http://finviz.com/quote.ashx?t= [SYMBOL] <http://finviz.com/quote.ashx?t=%5bSYMBOL%5d >
3) From where and how can I get recent dividend history (for example, last 16 quarters with date paid)? Some equities, like Realty Income (O), pay a monthly dividend, which is yet a different case.
Change the ticker symbol to fit your needs
From: smf_addin@yahoogrou
Sent: Tuesday, December 25, 2012 1:54 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Data Sources and How to Extract
For (1), I think those are proprietary. I don't know of a source from which I could extract them.
For (2), there are two items that discuss it in the LINKS area of the group.
For (3), check out the RCHGetYahooHistory(
On Tue, Dec 25, 2012 at 11:33 AM, rjemery7 <rjemery@gmail.
1) For a given symbol, from where and how can I include from Standard & Poor's their:
a) GICS Sector and Sub-Industry information
b) Beta
c) STARS, Credit and Quality Ratings
d) Qualitative Risk Assessment
e) Relative Strength Rank
f) Fair Value Rank
g) Fair Value Calculation
h) etc.
in my spreadsheets using RCH or SMF functions?
2) How can I extract information from http://finviz.
3) From where and how can I get recent dividend history (for example, last 16 quarters with date paid)? Some equities, like Realty Income (O), pay a monthly dividend, which is yet a different case.
Wed Dec 26, 2012 7:29 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
Randy, I'd be interested in the Netflix template. If you don't mind uploading it.
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Tuesday, December 25, 2012 8:44 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: Data Sources and How to Extract
Just take a look at the "Source" column of the EXCEL file distributed with the add-in. The primary websites most people use have elements defined.
But, really, there are too many to list -- and it depends so much on what use you put the data to. I even use the add-in to access sites like NetFlix and IMDB.
On Tue, Dec 25, 2012 at 6:26 PM, rjemery7 <rjemery@gmail.com > wrote:
Do you have a list of websites from which useful stock and/or economic data can be extracted using your functions?
Kermit
From: smf_addin@yahoogrou
Sent: Tuesday, December 25, 2012 8:44 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Re: Data Sources and How to Extract
Just take a look at the "Source" column of the EXCEL file distributed with the add-in. The primary websites most people use have elements defined.
But, really, there are too many to list -- and it depends so much on what use you put the data to. I even use the add-in to access sites like NetFlix and IMDB.
On Tue, Dec 25, 2012 at 6:26 PM, rjemery7 <rjemery@gmail.
Do you have a list of websites from which useful stock and/or economic data can be extracted using your functions?
Wed Dec 26, 2012 8:45 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I'm not sure just what you're looking for from NetFlix. My workbooks are
pretty specialized, and sometimes are built on the fly for the specific
information I'm after, but I do use the following formulas to get info on
individual movies:
- Genre:
=SUBSTITUTE(smfGetTagContent("http://dvd.netflix.com/Movie/ "&$B6,"a",1,"Genres:"),"
Movies","")
- Rating:
=IFERROR(0+smfStrExtr("|"&smfGetTagContent("http://dvd.netflix.com/Movie/ "&$B6,"span",1,"ratings:"),"|","
star"),3)
- Duration:
=smfGetTagContent("http://dvd.netflix.com/Movie/
"&$B6,"span",-1,"class=""duration""")
- Year:
=VALUE(smfGetTagContent("http://dvd.netflix.com/Movie/
"&$B6,"span",-1,"class=""year"""))
- Title:
=smfStrExtr(smfGetTagContent("http://dvd.netflix.com/Movie/ "&$B6,"title",1)&"|",":
","|")
- Synopsis:
=smfGetTagContent("http://dvd.netflix.com/Movie/
"&$B6,"p",-1,"class=""synopsis")
...where $B6 contains the movie numeric ID (e.g. 70120085). I used these to
add entries to an "offline" queue I keep. You do need to log in to your
account with the EXCEL Web Query process (preferred) or IE, from this URL:
- http://www.netflix.com
If you log in using their DVD or streaming web site, the functions may not
work. I've had sporadic results.
On Wed, Dec 26, 2012 at 8:29 AM, Kermit W. Prather
<kermitp@tampabay.rr.com >wrote:
>
> Randy, I'd be interested in the Netflix template. If you don't mind
> uploading it.****
>
> ** **
>
> Kermit
>
pretty specialized, and sometimes are built on the fly for the specific
information I'm after, but I do use the following formulas to get info on
individual movies:
- Genre:
=SUBSTITUTE(
Movies","")
- Rating:
=IFERROR(0+smfStrEx
star"),3)
- Duration:
=smfGetTagContent(
"&$B6,"span"
- Year:
=VALUE(smfGetTagCon
"&$B6,"span"
- Title:
=smfStrExtr(
","|")
- Synopsis:
=smfGetTagContent(
"&$B6,"p",-1,
...where $B6 contains the movie numeric ID (e.g. 70120085). I used these to
add entries to an "offline" queue I keep. You do need to log in to your
account with the EXCEL Web Query process (preferred) or IE, from this URL:
- http://www.netflix.
If you log in using their DVD or streaming web site, the functions may not
work. I've had sporadic results.
On Wed, Dec 26, 2012 at 8:29 AM, Kermit W. Prather
<kermitp@tampabay.
>
> Randy, I'd be interested in the Netflix template. If you don't mind
> uploading it.****
>
> ** **
>
> Kermit
>
Wed Dec 26, 2012 8:46 am (PST) . Posted by:
"jsawyermib" jsawyermib
Hi, I am a new user of the add-in, but I can only retrieve data up to element number c. 4660 - ie not from Advfn.
I am using the add-in "RCH_Stock_Market_Functions-2.1.2012.07.12" which I have down downloaded from the "Works-in-Progress" directory of this forum and which I assume is the latest version. The add-in is saved in my "c:/Program Files/SMF Add-In/", as recommended and I am running excel 2010.
Functions such as "smfGetADVFNElement(x...)" are not working, but the add-in works when I use functions such as "RCHGetElementNumber(Ticker,25)" [MSN data on last price] on Element numbers up to around 4660 [ie including MSN, Yahoo and GOOGLE), but not on the higher element numbers that include AdvFN and MorningStar.
If the data is coming in OK for the lower element numbers, I assume that I have loaded the add-in correctly, but perhaps I am using an old version.
Anyone got any ideas or solution so that I can access AdvFN?
JS
I am using the add-in "RCH_Stock_Market_
Functions such as "smfGetADVFNElement
If the data is coming in OK for the lower element numbers, I assume that I have loaded the add-in correctly, but perhaps I am using an old version.
Anyone got any ideas or solution so that I can access AdvFN?
JS
Wed Dec 26, 2012 8:55 am (PST) . Posted by:
"Randy Harmelink" rharmelink
See the LINKS area for the group for a possible AdvFN fix. Otherwise, if
you go to www.advfn.com with your browser and get redirected to another
site, there may be other changes that are necessary, because AdvFN is
redirecting your queries -- usually based on where your IP address is
located, to your country's version of AdvFN.
You should use the RCHGetYahooQuotes() function to get quotes instead of
element #25. Since their latest restructure, MSN is populating "Last Price"
with the previous day's closing price instead of the last traded price.
Morningstar is a website that does some "first visit of the day"
redirection (for advertising and such), so you do need to visit the site
manually with the EXCEL Web Query dialog (preferred) or with IE before
using the add-in each day, to create a cookie that says they don't need to
do that. Also, there have been a few recent updates to element definitions
for MorningStar. Also, they are converting a lot of their web pages to
dynamic display of data, so the data is no longer contained in the source
code of the web page, which is where the add-in extracts the data from.
On Wed, Dec 26, 2012 at 9:32 AM, jsawyermib <jsawyermib@yahoo.com > wrote:
> Hi, I am a new user of the add-in, but I can only retrieve data up to
> element number c. 4660 - ie not from Advfn.
>
> I am using the add-in "RCH_Stock_Market_Functions-2.1.2012.07.12" which I
> have down downloaded from the "Works-in-Progress" directory of this forum
> and which I assume is the latest version. The add-in is saved in my
> "c:/Program Files/SMF Add-In/", as recommended and I am running excel 2010.
>
> Functions such as "smfGetADVFNElement(x...)" are not working, but the
> add-in works when I use functions such as "RCHGetElementNumber(Ticker,25)"
> [MSN data on last price] on Element numbers up to around 4660 [ie including
> MSN, Yahoo and GOOGLE), but not on the higher element numbers that include
> AdvFN and MorningStar.
>
> If the data is coming in OK for the lower element numbers, I assume that I
> have loaded the add-in correctly, but perhaps I am using an old version.
>
> Anyone got any ideas or solution so that I can access AdvFN?
>
you go to www.advfn.com with your browser and get redirected to another
site, there may be other changes that are necessary, because AdvFN is
redirecting your queries -- usually based on where your IP address is
located, to your country's version of AdvFN.
You should use the RCHGetYahooQuotes(
element #25. Since their latest restructure, MSN is populating "Last Price"
with the previous day's closing price instead of the last traded price.
Morningstar is a website that does some "first visit of the day"
redirection (for advertising and such), so you do need to visit the site
manually with the EXCEL Web Query dialog (preferred) or with IE before
using the add-in each day, to create a cookie that says they don't need to
do that. Also, there have been a few recent updates to element definitions
for MorningStar. Also, they are converting a lot of their web pages to
dynamic display of data, so the data is no longer contained in the source
code of the web page, which is where the add-in extracts the data from.
On Wed, Dec 26, 2012 at 9:32 AM, jsawyermib <jsawyermib@yahoo.
> Hi, I am a new user of the add-in, but I can only retrieve data up to
> element number c. 4660 - ie not from Advfn.
>
> I am using the add-in "RCH_Stock_Market_
> have down downloaded from the "Works-in-Progress" directory of this forum
> and which I assume is the latest version. The add-in is saved in my
> "c:/Program Files/SMF Add-In/", as recommended and I am running excel 2010.
>
> Functions such as "smfGetADVFNElement
> add-in works when I use functions such as "RCHGetElementNumbe
> [MSN data on last price] on Element numbers up to around 4660 [ie including
> MSN, Yahoo and GOOGLE), but not on the higher element numbers that include
> AdvFN and MorningStar.
>
> If the data is coming in OK for the lower element numbers, I assume that I
> have loaded the add-in correctly, but perhaps I am using an old version.
>
> Anyone got any ideas or solution so that I can access AdvFN?
>
Wed Dec 26, 2012 12:05 pm (PST) . Posted by:
"jsawyermib" jsawyermib
Randy, thanks for the the speedy response and directing me to a previous reply (from Laveys on 16 June 2010). The solution was to go into Internet Explorer, then Tools, Internet Options, Security, Custom Level button. There one should find "Access data sources across Domains" and change the option to "enable" and then save changes. Works great now.
I'd just like to say how impressed I am with your work and forum. It is a major step in helping to democratize equity data analysis which has for too long been the preserve of the big banks and those that can stump up $15-20k per access for a professional data subscription. - Well done and keep up the good work.
JS
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> See the LINKS area for the group for a possible AdvFN fix. Otherwise, if
> you go to www.advfn.com with your browser and get redirected to another
> site, there may be other changes that are necessary, because AdvFN is
> redirecting your queries -- usually based on where your IP address is
> located, to your country's version of AdvFN.
>
> You should use the RCHGetYahooQuotes() function to get quotes instead of
> element #25. Since their latest restructure, MSN is populating "Last Price"
> with the previous day's closing price instead of the last traded price.
>
> Morningstar is a website that does some "first visit of the day"
> redirection (for advertising and such), so you do need to visit the site
> manually with the EXCEL Web Query dialog (preferred) or with IE before
> using the add-in each day, to create a cookie that says they don't need to
> do that. Also, there have been a few recent updates to element definitions
> for MorningStar. Also, they are converting a lot of their web pages to
> dynamic display of data, so the data is no longer contained in the source
> code of the web page, which is where the add-in extracts the data from.
>
> On Wed, Dec 26, 2012 at 9:32 AM, jsawyermib <jsawyermib@...> wrote:
>
> > Hi, I am a new user of the add-in, but I can only retrieve data up to
> > element number c. 4660 - ie not from Advfn.
> >
> > I am using the add-in "RCH_Stock_Market_Functions-2.1.2012.07.12" which I
> > have down downloaded from the "Works-in-Progress" directory of this forum
> > and which I assume is the latest version. The add-in is saved in my
> > "c:/Program Files/SMF Add-In/", as recommended and I am running excel 2010.
> >
> > Functions such as "smfGetADVFNElement(x...)" are not working, but the
> > add-in works when I use functions such as "RCHGetElementNumber(Ticker,25)"
> > [MSN data on last price] on Element numbers up to around 4660 [ie including
> > MSN, Yahoo and GOOGLE), but not on the higher element numbers that include
> > AdvFN and MorningStar.
> >
> > If the data is coming in OK for the lower element numbers, I assume that I
> > have loaded the add-in correctly, but perhaps I am using an old version.
> >
> > Anyone got any ideas or solution so that I can access AdvFN?
> >
>
I'd just like to say how impressed I am with your work and forum. It is a major step in helping to democratize equity data analysis which has for too long been the preserve of the big banks and those that can stump up $15-20k per access for a professional data subscription. - Well done and keep up the good work.
JS
--- In smf_addin@yahoogrou
>
> See the LINKS area for the group for a possible AdvFN fix. Otherwise, if
> you go to www.advfn.com with your browser and get redirected to another
> site, there may be other changes that are necessary, because AdvFN is
> redirecting your queries -- usually based on where your IP address is
> located, to your country's version of AdvFN.
>
> You should use the RCHGetYahooQuotes(
> element #25. Since their latest restructure, MSN is populating "Last Price"
> with the previous day's closing price instead of the last traded price.
>
> Morningstar is a website that does some "first visit of the day"
> redirection (for advertising and such), so you do need to visit the site
> manually with the EXCEL Web Query dialog (preferred) or with IE before
> using the add-in each day, to create a cookie that says they don't need to
> do that. Also, there have been a few recent updates to element definitions
> for MorningStar. Also, they are converting a lot of their web pages to
> dynamic display of data, so the data is no longer contained in the source
> code of the web page, which is where the add-in extracts the data from.
>
> On Wed, Dec 26, 2012 at 9:32 AM, jsawyermib <jsawyermib@
>
> > Hi, I am a new user of the add-in, but I can only retrieve data up to
> > element number c. 4660 - ie not from Advfn.
> >
> > I am using the add-in "RCH_Stock_Market_
> > have down downloaded from the "Works-in-Progress" directory of this forum
> > and which I assume is the latest version. The add-in is saved in my
> > "c:/Program Files/SMF Add-In/", as recommended and I am running excel 2010.
> >
> > Functions such as "smfGetADVFNElement
> > add-in works when I use functions such as "RCHGetElementNumbe
> > [MSN data on last price] on Element numbers up to around 4660 [ie including
> > MSN, Yahoo and GOOGLE), but not on the higher element numbers that include
> > AdvFN and MorningStar.
> >
> > If the data is coming in OK for the lower element numbers, I assume that I
> > have loaded the add-in correctly, but perhaps I am using an old version.
> >
> > Anyone got any ideas or solution so that I can access AdvFN?
> >
>
Wed Dec 26, 2012 1:37 pm (PST) . Posted by:
"zaigrith" zaigrith
I'm using the yahoo query in an array like this =RCHGetYahooQuotes(A2:A34,"l1",,NOW())" But I get 0 for stocks coming from the .mc extension such (as ABG.MC and GAM.MC). Does anyone know how to work around this problem? Thanks for all your support!
Wed Dec 26, 2012 2:00 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Until Yahoo fixes their data feed, you can get it web page by web page with:
=smfConvertData(smfGetTagContent("http://finance.yahoo.com/q?s=ABG.MC
","span",-1,"yfs_l84"))
...although I think the search string changes depending on whether it's
before, during, or after a market close...
On Wed, Dec 26, 2012 at 2:37 PM, zaigrith <adam.schoenwald@gmail.com > wrote:
> I'm using the yahoo query in an array like this
> =RCHGetYahooQuotes(A2:A34,"l1",,NOW())" But I get 0 for stocks coming from
> the .mc extension such (as ABG.MC and GAM.MC). Does anyone know how to
> work around this problem? Thanks for all your support!
>
=smfConvertData(
","span",-1,
...although I think the search string changes depending on whether it's
before, during, or after a market close...
On Wed, Dec 26, 2012 at 2:37 PM, zaigrith <adam.schoenwald@
> I'm using the yahoo query in an array like this
> =RCHGetYahooQuotes(
> the .mc extension such (as ABG.MC and GAM.MC). Does anyone know how to
> work around this problem? Thanks for all your support!
>
Wed Dec 26, 2012 1:55 pm (PST) . Posted by:
"jeroen.michiels@ymail.com" jeroen.michiels@ymail.com
Dear all,
in addition to managing my capital efficiently I also like to manage my time in the most optimal way, I therefore have a small question concerning the data gathering that uses the AdvFN plugin before starting my own extensive search.
In contrary to most posts concerning this subject I am able to get the data in Excel, however I encounter some issues with the . or , separator causing some of the data to not be easily manipulative.
I think this is caused by an Excel (or Windows language) issue, I am European based and I think the separators are messing up the numbers.
For instance:
Turnover: 156,508.0 translates as 156.51 (Billion)
Acquisitions: -350.0 translates as -3,500.00 (Million)
Which means that when I subtract acquisitions from turnover (I know, the example is poorly chosen) I arrive at 2,843.49 instead of 155650000000. (155.65 billion)
Going into the Excel options ==> Advanced ==> Separators I changed the following
Decimal Separator: .
Thousands Separator: ,
Unfortunately sometimes easy solutions are too easy, and the above quick fix was definitely too easy as is does not work.
It's strange though, when I now type in a number it shows up as 155,000,000.00 using the correct seperators.
Anyone who knows how I can fix this?
I am running Windows 7, Excel 2007 and am grabbing my data from AdvFN (http://www.advfn.com/fr/p.php?pid=financials&btn=start_date&qkbtn=&qksymbol=NASDAQ%3AAAPL&mode=annual_reports&symbol=NASDAQ%3AAAPL&start_date=19 )
Thanks in advance,
good investing!
in addition to managing my capital efficiently I also like to manage my time in the most optimal way, I therefore have a small question concerning the data gathering that uses the AdvFN plugin before starting my own extensive search.
In contrary to most posts concerning this subject I am able to get the data in Excel, however I encounter some issues with the . or , separator causing some of the data to not be easily manipulative.
I think this is caused by an Excel (or Windows language) issue, I am European based and I think the separators are messing up the numbers.
For instance:
Turnover: 156,508.0 translates as 156.51 (Billion)
Acquisitions: -350.0 translates as -3,500.00 (Million)
Which means that when I subtract acquisitions from turnover (I know, the example is poorly chosen) I arrive at 2,843.49 instead of 155650000000. (155.65 billion)
Going into the Excel options ==> Advanced ==> Separators I changed the following
Decimal Separator: .
Thousands Separator: ,
Unfortunately sometimes easy solutions are too easy, and the above quick fix was definitely too easy as is does not work.
It's strange though, when I now type in a number it shows up as 155,000,000.
Anyone who knows how I can fix this?
I am running Windows 7, Excel 2007 and am grabbing my data from AdvFN (http://www.advfn.
Thanks in advance,
good investing!
Wed Dec 26, 2012 2:05 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The add-in was built assuming U.S. Regional settings of the operating
system. That determines how VBA handles data conversions. I don't think the
EXCEL setting affects how VBA operates.
Unfortunately, I'm just sharing something I wrote for my own use, so I
can't support all the permutations of systems and applications software
that might occur. I'm hesitant to add changes for something that I can't
test very well.
On Wed, Dec 26, 2012 at 1:28 PM, jeroen.michiels@ymail.com <
jeroen.michiels@ymail.com > wrote:
> Dear all,
>
> in addition to managing my capital efficiently I also like to manage my
> time in the most optimal way, I therefore have a small question concerning
> the data gathering that uses the AdvFN plugin before starting my own
> extensive search.
>
> In contrary to most posts concerning this subject I am able to get the
> data in Excel, however I encounter some issues with the . or , separator
> causing some of the data to not be easily manipulative.
>
> I think this is caused by an Excel (or Windows language) issue, I am
> European based and I think the separators are messing up the numbers.
>
> For instance:
> Turnover: 156,508.0 translates as 156.51 (Billion)
> Acquisitions: -350.0 translates as -3,500.00 (Million)
>
> Which means that when I subtract acquisitions from turnover (I know, the
> example is poorly chosen) I arrive at 2,843.49 instead of 155650000000.
> (155.65 billion)
>
> Going into the Excel options ==> Advanced ==> Separators I changed the
> following
> Decimal Separator: .
> Thousands Separator: ,
>
> Unfortunately sometimes easy solutions are too easy, and the above quick
> fix was definitely too easy as is does not work.
>
> It's strange though, when I now type in a number it shows up as
> 155,000,000.00 using the correct seperators.
>
> Anyone who knows how I can fix this?
>
> I am running Windows 7, Excel 2007 and am grabbing my data from AdvFN (
> http://www.advfn.com/fr/p.php?pid=financials&btn=start_date&qkbtn=&qksymbol=NASDAQ%3AAAPL&mode=annual_reports&symbol=NASDAQ%3AAAPL&start_date=19
> )
>
system. That determines how VBA handles data conversions. I don't think the
EXCEL setting affects how VBA operates.
Unfortunately, I'm just sharing something I wrote for my own use, so I
can't support all the permutations of systems and applications software
that might occur. I'm hesitant to add changes for something that I can't
test very well.
On Wed, Dec 26, 2012 at 1:28 PM, jeroen.michiels@
jeroen.michiels@
> Dear all,
>
> in addition to managing my capital efficiently I also like to manage my
> time in the most optimal way, I therefore have a small question concerning
> the data gathering that uses the AdvFN plugin before starting my own
> extensive search.
>
> In contrary to most posts concerning this subject I am able to get the
> data in Excel, however I encounter some issues with the . or , separator
> causing some of the data to not be easily manipulative.
>
> I think this is caused by an Excel (or Windows language) issue, I am
> European based and I think the separators are messing up the numbers.
>
> For instance:
> Turnover: 156,508.0 translates as 156.51 (Billion)
> Acquisitions: -350.0 translates as -3,500.00 (Million)
>
> Which means that when I subtract acquisitions from turnover (I know, the
> example is poorly chosen) I arrive at 2,843.49 instead of 155650000000.
> (155.65 billion)
>
> Going into the Excel options ==> Advanced ==> Separators I changed the
> following
> Decimal Separator: .
> Thousands Separator: ,
>
> Unfortunately sometimes easy solutions are too easy, and the above quick
> fix was definitely too easy as is does not work.
>
> It's strange though, when I now type in a number it shows up as
> 155,000,000.
>
> Anyone who knows how I can fix this?
>
> I am running Windows 7, Excel 2007 and am grabbing my data from AdvFN (
> http://www.advfn.
> )
>
Wed Dec 26, 2012 11:28 pm (PST) . Posted by:
"Patrick" patrickvb
Hi Jereoen,
I've the same problem. There is some change in ADVFN,
the place of the national AdvFNPrefix change for the foreigner.
I've adapt the code in the Visual Basic module
smfGetADVFNElement.
FROM
sURL ="http://" <http://> sAdvFNPrefix
".advfn.com/p.php?pid=financials" "=" sTicker sLabel1
INTO
sURL ="http://www.advfn.com/ <http://www.advfn.com/ >
fr/p.php?pid=financials" "=" sTicker sLabel1
Patrick.
--- In smf_addin@yahoogroups.com , "jeroen.michiels@..." wrote:
>
> Dear all,
>
> in addition to managing my capital efficiently I also like to manage
my time in the most optimal way, I therefore have a small question
concerning the data gathering that uses the AdvFN plugin before starting
my own extensive search.
>
> In contrary to most posts concerning this subject I am able to get the
data in Excel, however I encounter some issues with the . or , separator
causing some of the data to not be easily manipulative.
>
> I think this is caused by an Excel (or Windows language) issue, I am
European based and I think the separators are messing up the numbers.
>
> For instance:
> Turnover: 156,508.0 translates as 156.51 (Billion)
> Acquisitions: -350.0 translates as -3,500.00 (Million)
>
> Which means that when I subtract acquisitions from turnover (I know,
the example is poorly chosen) I arrive at 2,843.49 instead of
155650000000. (155.65 billion)
>
> Going into the Excel options ==> Advanced ==> Separators I changed the
following
> Decimal Separator: .
> Thousands Separator: ,
>
> Unfortunately sometimes easy solutions are too easy, and the above
quick fix was definitely too easy as is does not work.
>
> It's strange though, when I now type in a number it shows up as
155,000,000.00 using the correct seperators.
>
> Anyone who knows how I can fix this?
>
> I am running Windows 7, Excel 2007 and am grabbing my data from AdvFN
(http://www.advfn.com/fr/p.php?pid=financials=start_date==NASDAQ%3AAAPL=\
annual_reports=NASDAQ%3AAAPL_date=19 )
>
> Thanks in advance,
>
> good investing!
>
I've the same problem. There is some change in ADVFN,
the place of the national AdvFNPrefix change for the foreigner.
I've adapt the code in the Visual Basic module
smfGetADVFNElement.
FROM
sURL ="http://" <http://> sAdvFNPrefix
".advfn.com/
INTO
sURL ="http://www.advfn.
fr/p.php?pid=
Patrick.
--- In smf_addin@yahoogrou
>
> Dear all,
>
> in addition to managing my capital efficiently I also like to manage
my time in the most optimal way, I therefore have a small question
concerning the data gathering that uses the AdvFN plugin before starting
my own extensive search.
>
> In contrary to most posts concerning this subject I am able to get the
data in Excel, however I encounter some issues with the . or , separator
causing some of the data to not be easily manipulative.
>
> I think this is caused by an Excel (or Windows language) issue, I am
European based and I think the separators are messing up the numbers.
>
> For instance:
> Turnover: 156,508.0 translates as 156.51 (Billion)
> Acquisitions: -350.0 translates as -3,500.00 (Million)
>
> Which means that when I subtract acquisitions from turnover (I know,
the example is poorly chosen) I arrive at 2,843.49 instead of
155650000000. (155.65 billion)
>
> Going into the Excel options ==> Advanced ==> Separators I changed the
following
> Decimal Separator: .
> Thousands Separator: ,
>
> Unfortunately sometimes easy solutions are too easy, and the above
quick fix was definitely too easy as is does not work.
>
> It's strange though, when I now type in a number it shows up as
155,000,000.
>
> Anyone who knows how I can fix this?
>
> I am running Windows 7, Excel 2007 and am grabbing my data from AdvFN
(http://www.advfn.
annual_reports=
>
> Thanks in advance,
>
> good investing!
>
Tidak ada komentar:
Posting Komentar