15 New Messages
Digest #2852
Messages
Mon Nov 11, 2013 5:46 am (PST) . Posted by:
"cgrain" cgrain76
ADVFN has been updating for the past month or so. None of the old functions and/or web queries will work. It also appears that they are still updating, as only some of the new queries work.
C. Grain
,
C. Grain
,
Mon Nov 11, 2013 7:22 am (PST) . Posted by:
"Randy Harmelink" rharmelink
See: http://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/24009
On Mon, Nov 11, 2013 at 6:41 AM, cgrain <cgrain@rcn.com> wrote:
>
> ADVFN has been updating for the past month or so. None of the old
> functions and/or web queries will work. It also appears that they are
> still updating, as only some of the new queries work.
>
On Mon, Nov 11, 2013 at 6:41 AM, cgrain <cgrain@rcn.com> wrote:
>
> ADVFN has been updating for the past month or so. None of the old
> functions and/or web queries will work. It also appears that they are
> still updating, as only some of the new queries work.
>
Mon Nov 11, 2013 5:47 am (PST) . Posted by:
holmberg_tommy
I'm not able to give you the URL address but as an example I would like to have Carlsberg's lates price in Excel ( http://www.reuters.com/finance/stocks/overview?symbol=CARLb.CO http://www.reuters.com/finance/stocks/overview?symbol=CARLb.CO ).
So how can I have it there?
- Tommy
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Sample URL?
On Sun, Nov 10, 2013 at 2:41 AM, <holmberg_tommy@... mailto:holmberg_tommy@...> wrote:
Is there any way to have last price from Reuters? Table covers only the case with MSN and it's not able to get Swedish stock information.
So how can I have it there?
- Tommy
---In smf_addin@yahoogrou
Sample URL?
On Sun, Nov 10, 2013 at 2:41 AM, <holmberg_
Is there any way to have last price from Reuters? Table covers only the case with MSN and it's not able to get Swedish stock information.
Mon Nov 11, 2013 7:24 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Try:
=smfConvertData(smfGetTagContent("
http://www.reuters.com/finance/stocks/overview?symbol=CARLb.CO
","span",2,"sectionQuoteDetail"))
On Mon, Nov 11, 2013 at 6:47 AM, <holmberg_tommy@yahoo.com> wrote:
> I'm not able to give you the URL address but as an example I would like
> to have Carlsberg's lates price in Excel (
> http://www.reuters.com/finance/stocks/overview?symbol=CARLb.CO ).
>
> So how can I have it there?
>
=smfConvertData(
http://www.reuters.
","
On Mon, Nov 11, 2013 at 6:47 AM, <holmberg_tommy@
> I'm not able to give you the URL address but as an example I would like
> to have Carlsberg'
> http://www.reuters.
>
> So how can I have it there?
>
Mon Nov 11, 2013 10:16 am (PST) . Posted by:
holmberg_tommy
Hi Randy,
Thanks for your help. This worked very well.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Try:
=smfConvertData(smfGetTagContent("http://www.reuters.com/finance/stocks/overview?symbol=CARLb.CO http://www.reuters.com/finance/stocks/overview?symbol=CARLb.CO","span",2,"sectionQuoteDetail"))
On Mon, Nov 11, 2013 at 6:47 AM, <holmberg_tommy@... mailto:holmberg_tommy@...> wrote:
I'm not able to give you the URL address but as an example I would like to have Carlsberg's lates price in Excel ( http://www.reuters.com/finance/stocks/overview?symbol=CARLb.CO http://www.reuters.com/finance/stocks/overview?symbol=CARLb.CO ).
So how can I have it there?
Thanks for your help. This worked very well.
---In smf_addin@yahoogrou
Try:
=smfConvertData(
On Mon, Nov 11, 2013 at 6:47 AM, <holmberg_
I'm not able to give you the URL address but as an example I would like to have Carlsberg'
So how can I have it there?
Mon Nov 11, 2013 8:24 am (PST) . Posted by:
ronnyrode21
Hi everyone..I've been working on trying to pull this chart:
http://www.zacks.com/stock/chart/CNO/eps
from zacks..I tried using the RCHCreateComment but kept getting a Value error. I was able to pull a chart from stockcharts.com with another URL but couldnt get the chart from zacks to work. Any advice would be appreciated.
Thanks.
http://www.zacks.
from zacks..I tried using the RCHCreateComment but kept getting a Value error. I was able to pull a chart from stockcharts.
Thanks.
Mon Nov 11, 2013 8:27 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I had no problems:
=RCHCreateComment("http://nt8.zacks.com/ZComIcaCharts/PNG/cno_eps.png",99)
Remember, you need the URL of the *image*, not the *web page*. Any given
web page could have hundreds of images on it.
On Mon, Nov 11, 2013 at 9:24 AM, <ronnyrode21@yahoo.com> wrote:
>
> Hi everyone..I've been working on trying to pull this chart:
>
> http://www.zacks.com/stock/chart/CNO/eps
>
> from zacks..I tried using the RCHCreateComment but kept getting a Value
> error. I was able to pull a chart from stockcharts.com with another URL
> but couldnt get the chart from zacks to work. Any advice would be
> appreciated.
>
=RCHCreateComment(
Remember, you need the URL of the *image*, not the *web page*. Any given
web page could have hundreds of images on it.
On Mon, Nov 11, 2013 at 9:24 AM, <ronnyrode21@
>
> Hi everyone..I&#
>
> http://www.zacks.
>
> from zacks..I tried using the RCHCreateComment but kept getting a Value
> error. I was able to pull a chart from stockcharts.
> but couldnt get the chart from zacks to work. Any advice would be
> appreciated.
>
Mon Nov 11, 2013 8:57 am (PST) . Posted by:
lawrence.leesh
Hi Randy
When you mouse over 2014 of http://investing.businessweek.com/research/stocks/earnings/earnings.asp?ticker=MXP:LN
you will see high, low and consensus estimates. Is there a way to extract the info into excel?
thanks
LL
When you mouse over 2014 of http://investing.
you will see high, low and consensus estimates. Is there a way to extract the info into excel?
thanks
LL
Mon Nov 11, 2013 9:27 am (PST) . Posted by:
"Randy Harmelink" rharmelink
See:
http://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/13927
On Mon, Nov 11, 2013 at 8:23 AM, <lawrence.leesh@yahoo.com> wrote:
>
> When you mouse over 2014 of
> http://investing.businessweek.com/research/stocks/earnings/earnings.asp?ticker=MXP:LN
> you will see high, low and consensus estimates. Is there a way to extract
> the info into excel?
>
>
http://groups.
On Mon, Nov 11, 2013 at 8:23 AM, <lawrence.leesh@
>
> When you mouse over 2014 of
> http://investing.
> you will see high, low and consensus estimates. Is there a way to extract
> the info into excel?
>
>
Mon Nov 11, 2013 9:23 am (PST) . Posted by:
jonbeyer_39
Randy
I note that SmfPricesByDates() returns the adjusted price for a past date. Is there another SMF function that returns the unadjusted closing price for a past date?
Thanks. Jon
I note that SmfPricesByDates(
Thanks. Jon
Mon Nov 11, 2013 9:28 am (PST) . Posted by:
"Randy Harmelink" rharmelink
You'd need to use RCHGetYahooHistory().
On Mon, Nov 11, 2013 at 10:23 AM, <jonbeyer@earthlink.net> wrote:
>
> I note that SmfPricesByDates() returns the adjusted price for a past date.
> Is there another SMF function that returns the unadjusted closing price
> for a past date?
>
On Mon, Nov 11, 2013 at 10:23 AM, <jonbeyer@earthlink.
>
> I note that SmfPricesByDates(
> Is there another SMF function that returns the unadjusted closing price
> for a past date?
>
Mon Nov 11, 2013 9:59 am (PST) . Posted by:
cash.floh
hi randy,
i try to grab text from the following website:
http://www.teletrader.com/Professional/stocks/profile/tts-831838 http://www.teletrader.com/Professional/stocks/profile/tts-831838
Concrete the text from "Unternehmensportrait" on top of the page
I tried this:
=RCHGetHTMLTable("http://www.teletrader.com/Professional/stocks/profile/tts-831838"; "Unternehmensportrait";1;"";1)
and this:
=smfGetTagContent("http://www.teletrader.com/Professional/stocks/profile/tts-831838";"Unternehmensportrait";1;"")
But it doesn't work ...
Do you can help me?
Thanx and regards
cf
i try to grab text from the following website:
http://www.teletrad
Concrete the text from "Unternehmensp
I tried this:
=RCHGetHTMLTable(
and this:
=smfGetTagContent(
But it doesn't work ...
Do you can help me?
Thanx and regards
cf
Mon Nov 11, 2013 10:08 am (PST) . Posted by:
dabutler89
Thanks, that worked.
I don't think I exited out of excel before running the new add-in.
Also I had not done the internet explorer fix.
Thanks a lot!
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
I just uploaded an updated copy of that template. It was retrieving the line items labels using the old AdvFN URL structure. So those URLs needed to be changed.
However, that shouldn't affect the "Number of Periods" cell. If you're getting "Error" there, you'll still have a problem.
When you updated to 2013.10.17, did you exit EXCEL first? Add-ins are loaded at EXCEL start-up, so changing the XLA file while in EXCEL won't update the add-in until EXCEL is restarted.
You shouldn't be changing the paths in the cells, you should be removing them altogether. I usually just run the smfFixLinks macro that is within the add-in.
Be sure you have the Internet Options settings fix, described in an item in the LINKS area of the group.
If you're in another region, where AdvFN redirects you to a different domain prefix, you'll need to add an smf-AdvFN-prefix.txt file in the add-in folder, with that prefix as the only thing in the file (e.g a 2-byte "uk" value). Otherwise, the add-in defaults to the "www" domain prefix.
On Sun, Nov 10, 2013 at 10:24 PM, <dabutler89@... mailto:dabutler89@...> wrote:
I can't seem to get this file to work properly: "smfGetAdvFNElement-Template- All-Line-Items.xls" It is the template used to dump the ADVFN data.
This is what I have done so far ( I know there has been an issue with ADVFN, my impression is that with the new add-in everything was up and running)
I am running windows 7 (x64), Excel 2013
I updated my add-in to the 10.17
changed the path of the cells to my element-definition file
What else should I be doing? The number of periods cell is coming up with "Error".
Let me know and thank you for this amazing plug-in; It's working with GuruFocus data and the add-in is a life saver.
I don't think I exited out of excel before running the new add-in.
Also I had not done the internet explorer fix.
Thanks a lot!
---In smf_addin@yahoogrou
I just uploaded an updated copy of that template. It was retrieving the line items labels using the old AdvFN URL structure. So those URLs needed to be changed.
However, that shouldn'
When you updated to 2013.10.17, did you exit EXCEL first? Add-ins are loaded at EXCEL start-up, so changing the XLA file while in EXCEL won't update the add-in until EXCEL is restarted.
You shouldn'
Be sure you have the Internet Options settings fix, described in an item in the LINKS area of the group.
If you're in another region, where AdvFN redirects you to a different domain prefix, you'll need to add an smf-AdvFN-prefix.
On Sun, Nov 10, 2013 at 10:24 PM, <dabutler89@
I can't seem to get this file to work properly: "smfGetAdvFNEl
This is what I have done so far ( I know there has been an issue with ADVFN, my impression is that with the new add-in everything was up and running)
I am running windows 7 (x64), Excel 2013
I updated my add-in to the 10.17
changed the path of the cells to my element-definition file
What else should I be doing? The number of periods cell is coming up with "Error"
Let me know and thank you for this amazing plug-in; It's working with GuruFocus data and the add-in is a life saver.
Mon Nov 11, 2013 2:43 pm (PST) . Posted by:
"Kermit W. Prather" kermitpra
I am trying to retrieve the unadjusted closing price on a given date.
It is returning nothing. I have tried many difference methods to get the
unadjusted price.
The reason I need the unadjusted price on the purchase date is in order to
calculate the total returns including stock splits and dividends since
purchase..
Row
1
Cell E1 contains formula
=
IF(C5>
0,RCHGetYahooHistory(C5,YEAR(E5),MONTH(E5),DAY(E5),YEAR(E5),MONTH(E5),DAY(E5
),"d","c",0,0,0)," ")
2
Cell E2 contains formula
=
RCHGetYahooHistory(C5,YEAR(E5),MONTH(E5),DAY(E5),YEAR(E5),MONTH(E5),DAY(E5),
"d","c",0,0,0)
3
Column
4
C
E
5
AGNC
6/29/2008
6
Thanks,
Kermit
It is returning nothing. I have tried many difference methods to get the
unadjusted price.
The reason I need the unadjusted price on the purchase date is in order to
calculate the total returns including stock splits and dividends since
purchase..
Row
1
Cell E1 contains formula
=
IF(C5>
0,RCHGetYahooHistor
),"d"
2
Cell E2 contains formula
=
RCHGetYahooHistory(
"d"
3
Column
4
C
E
5
AGNC
6/29/2008
6
Thanks,
Kermit
Mon Nov 11, 2013 3:22 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Comparing adjusted prices *would* give you total return. That's the main
point of using them -- so that everything is relative to each other.
In any case, your formulas don't work because 6/29/2008 was not a trading
day, so there is no data to retrieve.
smfPricesByDates() fills forward for non-trading days, so you don't need to
know which days were trading days or not.
On Mon, Nov 11, 2013 at 3:42 PM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:
>
> I am trying to retrieve the unadjusted closing price on a given date.
>
> It is returning nothing. I have tried many difference methods to get the
> unadjusted price.
>
> The reason I need the unadjusted price on the purchase date is in order to
> calculate the total returns including stock splits and dividends since
> purchase..
>
>
>
> Row
>
> 1
>
> Cell E1 contains formula
>
> =
>
> IF(C5>
> 0,RCHGetYahooHistory(C5,YEAR(E5),MONTH(E5),DAY(E5),YEAR(E5),MONTH(E5),DAY(E5),"d","c",0,0,0),"
> ")
>
>
>
> 2
>
> Cell E2 contains formula
>
> =
>
>
> RCHGetYahooHistory(C5,YEAR(E5),MONTH(E5),DAY(E5),YEAR(E5),MONTH(E5),DAY(E5),"d","c",0,0,0)
>
>
>
>
>
> 3
>
> Column
>
>
>
>
>
> 4
>
> C
>
> E
>
>
>
>
>
> 5
>
> AGNC
>
> 6/29/2008
>
>
>
>
>
> 6
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
point of using them -- so that everything is relative to each other.
In any case, your formulas don't work because 6/29/2008 was not a trading
day, so there is no data to retrieve.
smfPricesByDates(
know which days were trading days or not.
On Mon, Nov 11, 2013 at 3:42 PM, Kermit W. Prather
<kermitp@tampabay.
>
> I am trying to retrieve the unadjusted closing price on a given date.
>
> It is returning nothing. I have tried many difference methods to get the
> unadjusted price.
>
> The reason I need the unadjusted price on the purchase date is in order to
> calculate the total returns including stock splits and dividends since
> purchase..
>
>
>
> Row
>
> 1
>
> Cell E1 contains formula
>
> =
>
> IF(C5>
> 0,RCHGetYahooHistor
> ")
>
>
>
> 2
>
> Cell E2 contains formula
>
> =
>
>
> RCHGetYahooHistory(
>
>
>
>
>
> 3
>
> Column
>
>
>
>
>
> 4
>
> C
>
> E
>
>
>
>
>
> 5
>
> AGNC
>
> 6/29/2008
>
>
>
>
>
> 6
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
Tidak ada komentar:
Posting Komentar