7 New Messages
Digest #2862
Messages
Sun Nov 17, 2013 4:00 am (PST) . Posted by:
holmberg_tommy
Hi Randy,
Thank you once again for all your help. Otherwise everything seem to be working but I have difficulties with one formula, hopefully you could say what is wrong in there.
Original one (that works)
=RCHGetTableCell("http://markets.ft.com/research/Markets/Tearsheets/Financials?s=CARL+B:CPH&subview=IncomeStatement";1;">Diluted eps excl. extra items")
And the other one that is otherwise same but company ticker code has been replaced by reference cell:
=RCHGetTableCell("http://markets.ft.com/research/Markets/Tearsheets/Financials?s=$F5&subview=IncomeStatement";1;">Diluted eps excl. extra items")
Reference cell (F5):
CARL+B:CPH
- Tommy
Thank you once again for all your help. Otherwise everything seem to be working but I have difficulties with one formula, hopefully you could say what is wrong in there.
Original one (that works)
=RCHGetTableCell(
And the other one that is otherwise same but company ticker code has been replaced by reference cell:
=RCHGetTableCell(
Reference cell (F5):
CARL+B:CPH
- Tommy
Sun Nov 17, 2013 7:12 am (PST) . Posted by:
"Randy Harmelink" rharmelink
You can't just put the cell address in the middle of the string. Then it's
just part of the string. You're trying to concatenate three separate
strings:
"http://markets.ft.com/research/Markets/Tearsheets/Financials?s="
$F5
"&subview=IncomeStatement"
So the formula would be something like:
=RCHGetTableCell("
http://markets.ft.com/research/Markets/Tearsheets/Financials?s=" & $F5 &
"&subview=IncomeStatement",1,">Diluted eps excl. extra items")
On Sun, Nov 17, 2013 at 5:00 AM, <holmberg_tommy@yahoo.com> wrote:
>
> Thank you once again for all your help. Otherwise everything seem to be
> working but I have difficulties with one formula, hopefully you could say
> what is wrong in there.
>
> Original one (that works)
>
> =RCHGetTableCell("
> http://markets.ft.com/research/Markets/Tearsheets/Financials?s=CARL+B:CPH&subview=IncomeStatement";1;">Diluted
> eps excl. extra items")
>
> And the other one that is otherwise same but company ticker code has been
> replaced by reference cell:
>
> =RCHGetTableCell("
> http://markets.ft.com/research/Markets/Tearsheets/Financials?s=$F5&subview=IncomeStatement";1;">Diluted
> eps excl. extra items")
>
> Reference cell (F5):
>
> CARL+B:CPH
>
>
just part of the string. You're trying to concatenate three separate
strings:
"http://markets.
$F5
"&subview=
So the formula would be something like:
=RCHGetTableCell(
http://markets.
"&subview=
On Sun, Nov 17, 2013 at 5:00 AM, <holmberg_tommy@
>
> Thank you once again for all your help. Otherwise everything seem to be
> working but I have difficulties with one formula, hopefully you could say
> what is wrong in there.
>
> Original one (that works)
>
> =RCHGetTableCell(
> http://markets.
> eps excl. extra items")
>
> And the other one that is otherwise same but company ticker code has been
> replaced by reference cell:
>
> =RCHGetTableCell(
> http://markets.
> eps excl. extra items")
>
> Reference cell (F5):
>
> CARL+B:CPH
>
>
Sun Nov 17, 2013 10:01 am (PST) . Posted by:
ronnyrode21
I'm trying to pull a chart from 4traders.com. I can pull the chart (Income statement Evolution) but the chart doesn't change when I enter a new symbol. Here is the code I am using.
=RCHCreateComment("http://www.4-traders.com/reuters_charts/5,2,360,280,"&B1&"/05680/2/EPS+Dividend.png""""",99,,,1)
I noticed after some research that the URL is using the full name of the company instead of a symbol (I think). Not sure if or how you can get around this. Any help would be appreciated as I have been working on this the last day or so.
Thanks.
=RCHCreateComment(
I noticed after some research that the URL is using the full name of the company instead of a symbol (I think). Not sure if or how you can get around this. Any help would be appreciated as I have been working on this the last day or so.
Thanks.
Sun Nov 17, 2013 12:12 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Try something like:
=RCHCreateComment("http://www.4-traders.com"&smfstrExtr(smfGetTagContent("
http://www.4-traders.com/
"&B1&"/financials/","td",-1,"Income+Statement+Evolution.png"),"src=""",""""),99,,,1)
On Sun, Nov 17, 2013 at 11:01 AM, <ronnyrode21@yahoo.com> wrote:
>
> I'm trying to pull a chart from 4traders.com. I can pull the chart
> (Income statement Evolution) but the chart doesn't change when I enter a
> new symbol. Here is the code I am using.
>
> =RCHCreateComment("http://www.4-traders.com/reuters_charts/5,2,360,280,
> "&B1&"/05680/2/EPS+Dividend.png""""",99,,,1)
>
> I noticed after some research that the URL is using the full name of the
> company instead of a symbol (I think). Not sure if or how you can get
> around this. Any help would be appreciated as I have been working on this
> the last day or so.
>
=RCHCreateComment(
http://www.4-
"&B1&"
On Sun, Nov 17, 2013 at 11:01 AM, <ronnyrode21@
>
> I'm trying to pull a chart from 4traders.com. I can pull the chart
> (Income statement Evolution) but the chart doesn't change when I enter a
> new symbol. Here is the code I am using.
>
> =RCHCreateComment(
> "&B1&"
>
> I noticed after some research that the URL is using the full name of the
> company instead of a symbol (I think). Not sure if or how you can get
> around this. Any help would be appreciated as I have been working on this
> the last day or so.
>
Sun Nov 17, 2013 2:20 pm (PST) . Posted by:
ronnyrode21
Hi Randy....thank you for your help.
I tried the statement you posted and received a "Value" error. Do you know why I may be receiving such? I'll keep on plugging away at it to see if I can solve it too but any help would be appreciated.
Thanks again.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Try something like:
=RCHCreateComment("http://www.4-traders.com http://www.4-traders.com"&smfstrExtr(smfGetTagContent("http://www.4-traders.com/ http://www.4-traders.com/"&B1&"/financials/","td",-1,"Income+Statement+Evolution.png"),"src=""",""""),99,,,1)
On Sun, Nov 17, 2013 at 11:01 AM, <ronnyrode21@... mailto:ronnyrode21@...> wrote:
I'm trying to pull a chart from 4traders.com http://4traders.com. I can pull the chart (Income statement Evolution) but the chart doesn't change when I enter a new symbol. Here is the code I am using.
=RCHCreateComment("http://www.4-traders.com/reuters_charts/5,2,360,280, http://www.4-traders.com/reuters_charts/5,2,360,280,"&B1&"/05680/2/EPS+Dividend.png""""",99,,,1)
I noticed after some research that the URL is using the full name of the company instead of a symbol (I think). Not sure if or how you can get around this. Any help would be appreciated as I have been working on this the last day or so.
I tried the statement you posted and received a "Value" error. Do you know why I may be receiving such? I'll keep on plugging away at it to see if I can solve it too but any help would be appreciated.
Thanks again.
---In smf_addin@yahoogrou
Try something like:
=RCHCreateComment(
On Sun, Nov 17, 2013 at 11:01 AM, <ronnyrode21@
I'm trying to pull a chart from 4traders.com http://4traders.
=RCHCreateComment(
I noticed after some research that the URL is using the full name of the company instead of a symbol (I think). Not sure if or how you can get around this. Any help would be appreciated as I have been working on this the last day or so.
Sun Nov 17, 2013 3:23 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I would suspect it has to do with what you have in cell B1. Since they
don't use ticker symbols, your value in cell B1 needs to be something like
"3M-CO-4836" instead of "MMM".
On Sun, Nov 17, 2013 at 3:20 PM, <ronnyrode21@yahoo.com> wrote:
> Hi Randy....thank you for your help.
>
> I tried the statement you posted and received a "Value" error. Do you know
> why I may be receiving such? I'll keep on plugging away at it to see if I
> can solve it too but any help would be appreciated.
>
don't use ticker symbols, your value in cell B1 needs to be something like
"3M-CO-
On Sun, Nov 17, 2013 at 3:20 PM, <ronnyrode21@
> Hi Randy....thank you for your help.
>
> I tried the statement you posted and received a "Value" error. Do you know
> why I may be receiving such? I'll keep on plugging away at it to see if I
> can solve it too but any help would be appreciated.
>
Sun Nov 17, 2013 7:31 pm (PST) . Posted by:
3cea442c9433ace1c8a1aaf206d43628
Randy (or anyone else?),
jivedata.com http://jivedata.com has a free API for financial data. Do you have any interest in adding that to your add-in? I created a quick Google Spreadsheet that uses their API:
https://drive.google.com/templates?view=public&authorId=13272659680645930268.
I'd do the same for Excel but I have zero Excel skills. If it helps, you should be able to view the source code of my Google Spreadsheet, which has 2 files (Tools > Script editor). The documentation for their API is on their website.
-Brandon
jivedata.com http://jivedata.
https://drive.
I'd do the same for Excel but I have zero Excel skills. If it helps, you should be able to view the source code of my Google Spreadsheet, which has 2 files (Tools > Script editor). The documentation for their API is on their website.
-Brandon
Tidak ada komentar:
Posting Komentar