5 New Messages
Digest #2898
Messages
Wed Dec 18, 2013 7:12 am (PST) . Posted by:
philip_r_small
Hi Randy
Not sure if you can help with this as it is slightly off the SMF topic but I am trying to insert a copy of some spread sheet cells into a comment along the lines of the createcomment function you have which I use a lot. I have a small array (3x6) of cells that I wanted to display in a comment. I have found the "linked picture" function in Excel which allows me to create a linked picture and was wanting to paste it into a comment - the long winded way is to save it as a web page and then use createcomment but I was wondering if there was a way of just using "Picture 2" which is what Excel calls the copied cells instead of a URL?
No problem if this is too off-topic for you. Thanks
Not sure if you can help with this as it is slightly off the SMF topic but I am trying to insert a copy of some spread sheet cells into a comment along the lines of the createcomment function you have which I use a lot. I have a small array (3x6) of cells that I wanted to display in a comment. I have found the "linked picture" function in Excel which allows me to create a linked picture and was wanting to paste it into a comment - the long winded way is to save it as a web page and then use createcomment but I was wondering if there was a way of just using "Picture 2" which is what Excel calls the copied cells instead of a URL?
No problem if this is too off-topic for you. Thanks
Wed Dec 18, 2013 8:01 am (PST) . Posted by:
"Randy Harmelink" rharmelink
RCHCreateComment() won't do that, since it is inserting a file as the
background image of a comment.
You might be able to write your own little VBA routine to do it though.
Another possibility might be to load the 3x6 range of text into the comment
as text, if you can format it the way you want to see it --
RCHCreateComment() could do that. For example, an extremely simple version
that would pull in a 2x3 range:
=RCHCreateComment("",0,,,1,,,,smfJoin(C4:E4," ")&CHAR(10)&smfJoin(C5:E5,"
"))
On Wed, Dec 18, 2013 at 8:12 AM, <Philip_R_Small@hotmail.com> wrote:
> Not sure if you can help with this as it is slightly off the SMF topic but
> I am trying to insert a copy of some spread sheet cells into a comment
> along the lines of the createcomment function you have which I use a lot. I
> have a small array (3x6) of cells that I wanted to display in a comment. I
> have found the "linked picture" function in Excel which allows me to create
> a linked picture and was wanting to paste it into a comment - the long
> winded way is to save it as a web page and then use createcomment but I was
> wondering if there was a way of just using "Picture 2" which is what Excel
> calls the copied cells instead of a URL?
>
> No problem if this is too off-topic for you. Thanks
>
>
background image of a comment.
You might be able to write your own little VBA routine to do it though.
Another possibility might be to load the 3x6 range of text into the comment
as text, if you can format it the way you want to see it --
RCHCreateComment(
that would pull in a 2x3 range:
=RCHCreateComment(
"))
On Wed, Dec 18, 2013 at 8:12 AM, <Philip_R_Small@
> Not sure if you can help with this as it is slightly off the SMF topic but
> I am trying to insert a copy of some spread sheet cells into a comment
> along the lines of the createcomment function you have which I use a lot. I
> have a small array (3x6) of cells that I wanted to display in a comment. I
> have found the "linked picture" function in Excel which allows me to create
> a linked picture and was wanting to paste it into a comment - the long
> winded way is to save it as a web page and then use createcomment but I was
> wondering if there was a way of just using "Picture 2" which is what Excel
> calls the copied cells instead of a URL?
>
> No problem if this is too off-topic for you. Thanks
>
>
Wed Dec 18, 2013 7:53 am (PST) . Posted by:
"Randy Harmelink" rharmelink
This has been noted before on various companies. I don't know what to make
of AdvFN these days. I think they are spending time on the new display
format, so aren't interested (or don't have the time) to maintain things
properly in the current format.
On Tue, Dec 17, 2013 at 11:43 PM, <zefiro401k@yahoo.com> wrote:
>
> Hello everyone,
> I was doing a search and didn't seem like anyone brought this up. If you
> look at ADVFN's Quarterly Data starting from 2013 and on, it appears the
> data is coming out incorrectly from their website.
>
> For example, Compare the Quarterly Revenue Numbers from ADVFN with
> GuruFocus.
> AAPL: Revenue for June/13 on ADVFN is not the same as GuruFocus.
>
> BA: Revenue seems to be compounding with the previous quarter starting
> from June/13. GuruFocus is reporting the 3 month quarterly results.
>
> It doesn't seem like an Add-In issue more like ADVFN data is incorrect.
> Please let me know if you are also seeing the same problem. Thank you.
>
of AdvFN these days. I think they are spending time on the new display
format, so aren't interested (or don't have the time) to maintain things
properly in the current format.
On Tue, Dec 17, 2013 at 11:43 PM, <zefiro401k@yahoo.
>
> Hello everyone,
> I was doing a search and didn't seem like anyone brought this up. If you
> look at ADVFN's Quarterly Data starting from 2013 and on, it appears the
> data is coming out incorrectly from their website.
>
> For example, Compare the Quarterly Revenue Numbers from ADVFN with
> GuruFocus.
> AAPL: Revenue for June/13 on ADVFN is not the same as GuruFocus.
>
> BA: Revenue seems to be compounding with the previous quarter starting
> from June/13. GuruFocus is reporting the 3 month quarterly results.
>
> It doesn't seem like an Add-In issue more like ADVFN data is incorrect.
> Please let me know if you are also seeing the same problem. Thank you.
>
Wed Dec 18, 2013 8:24 am (PST) . Posted by:
"flangeneral" flangeneral
Thanks all for confirming that there is an issue, and not just me. A little more info, I am running Windows XP Professional (ugh) and Excel 2007. I believe it is/was a yahoo issue. Occasionally, the first cell in my array entered formula would return "Error" and the rest of the array entered cells would return blank. Having said this, today so far (knock on wood) seems to be back to normal.
--- In smf_addin@yahoogroups.com, <jeff.wortman@...> wrote:
>
> I have the same problem which started in the same timeframe. I am using Windows 7 Professional - 64 bit, and Excel 2010. Beyond my control there were new upgrades made to Excel this weekend which is when the problem go so bad that spreadsheets are unable to load approx. 150 data values from Yahoo. Also, about 10 days before that EXCEL was upgraded to Service Pack 2 - I can't say that it was slower at that point but it was not failing like it is now. Does this match with any software maintenance you have recently completed? I am think that I may try to get last weekend's changes backed out.
> Jeff
>
--- In smf_addin@yahoogrou
>
> I have the same problem which started in the same timeframe. I am using Windows 7 Professional - 64 bit, and Excel 2010. Beyond my control there were new upgrades made to Excel this weekend which is when the problem go so bad that spreadsheets are unable to load approx. 150 data values from Yahoo. Also, about 10 days before that EXCEL was upgraded to Service Pack 2 - I can't say that it was slower at that point but it was not failing like it is now. Does this match with any software maintenance you have recently completed? I am think that I may try to get last weekend'
> Jeff
>
Wed Dec 18, 2013 11:35 am (PST) . Posted by:
"PeteA" option2z
RE:
Has anyone else been having problems with getting quotes from Yahoo
recently? I have array entered =RCHGetYahooQuotes for about 35 tickers, and
up until last week it has been running fine, takes about 10 - 15 seconds to
return prices. However, last week it started to return prices very slowly.
It could take 5 minutes or more now. Sometimes it would return all blanks
for last price and previous price. Any ideas why?
I have a server-side app that pulls YAHOO quotes for users accessing via
browser: http://www.ttp-s.com/php/rsiRT.php
It has intermittent problems with YAHOO data the last few days, but mostly
works as it should (Note: it is NOT using Randy's SMF or excel, so it is
VERY LIKELY a YAHOO problem!).
Thanks,
Pete A
<http://www.sundognorth.com/TtP-S/>
Has anyone else been having problems with getting quotes from Yahoo
recently? I have array entered =RCHGetYahooQuotes for about 35 tickers, and
up until last week it has been running fine, takes about 10 - 15 seconds to
return prices. However, last week it started to return prices very slowly.
It could take 5 minutes or more now. Sometimes it would return all blanks
for last price and previous price. Any ideas why?
I have a server-side app that pulls YAHOO quotes for users accessing via
browser: http://www.ttp-
It has intermittent problems with YAHOO data the last few days, but mostly
works as it should (Note: it is NOT using Randy's SMF or excel, so it is
VERY LIKELY a YAHOO problem!).
Thanks,
Pete A
<http://www.sundogno
Tidak ada komentar:
Posting Komentar