Jumat, 17 November 2017

[smf_addin] Digest Number 4241

13 Messages

Digest #4241
1a
Re: Date & Sync data by "Randy Harmelink" rharmelink
1b
Re: Date & Sync data by "Joe Mo" joe_mo37
1c
Re: Date & Sync data by "Ron Spruell" hashky
2a
2b
3a
RCHCreateComment Problem by ridgebacksexcel
3b
Re: RCHCreateComment Problem by "Randy Harmelink" rharmelink
4b
Re: ADVFN All Line Items template problem by "Randy Harmelink" rharmelink
5b

Messages

Fri Nov 17, 2017 10:28 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Interesting. I guess I've always done smfGetBarchartPortfolioView() when
the market was closed. They must return a time if the market is open and
last traded date if the market is closed...

I don't see any other kind of date or time stamp on the JSON file.

On Fri, Nov 17, 2017 at 11:17 AM, Ron Spruell hashky@
​...
wrote:

>
> I must be the last light on the string. I can't seem to get a date from
> Barchart. I agree with you on FinViz.
>
> Windows 7
> Stock Market Functions add-in, Version 2.1.2017.11.11 (C:\SMF Add-In;
> Windows (32-bit) NT 6.01; 14.0; ; Local; 1)
>
> This is what I get from Barchart.
> "=smfGetBarchartPortfolioView("SPY","016")"
> 13:05 ET
>
> "=smfGetBarchartPortfolioView("SPY","16")"
> 9/15/1900
>
> Formatting both as General, I get 13:05 ET and 259.35
>

Fri Nov 17, 2017 10:38 am (PST) . Posted by:

"Joe Mo" joe_mo37

For me, the BarChart Trade Time column returns a string like 13:24 ET for stocks and ETFs during market hours, and a serial date/time (a number) for stocks, and ETFs after market close. For mutual funds, Trade Time returns a serial date/time for the last business day prior to the current day while the market is open, and today's date if sufficient time has elapsed after today's market close time.

Fri Nov 17, 2017 11:30 am (PST) . Posted by:

"Ron Spruell" hashky

Thanks -
| "=smfGetBarchartPortfolioView("VFINX","016")" |
| 11/16/2017 |

|
|

So, I just need to use the Prev Close for prices on Finviz.

From: "Joe Mo joe_mo37@yahoo.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Friday, November 17, 2017 12:38 PM
Subject: Re: [smf_addin] Date & Sync data

  For me, the BarChart Trade Time column returns a string like 13:24 ET for stocks and ETFs during market hours, and a serial date/time (a number) for stocks, and ETFs after market close. For mutual funds, Trade Time returns a serial date/time for the last business day prior to the current day while the market is open, and today's date if sufficient time has elapsed after today's market close time.
#yiv8893158605 #yiv8893158605 -- #yiv8893158605ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8893158605 #yiv8893158605ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8893158605 #yiv8893158605ygrp-mkp #yiv8893158605hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8893158605 #yiv8893158605ygrp-mkp #yiv8893158605ads {margin-bottom:10px;}#yiv8893158605 #yiv8893158605ygrp-mkp .yiv8893158605ad {padding:0 0;}#yiv8893158605 #yiv8893158605ygrp-mkp .yiv8893158605ad p {margin:0;}#yiv8893158605 #yiv8893158605ygrp-mkp .yiv8893158605ad a {color:#0000ff;text-decoration:none;}#yiv8893158605 #yiv8893158605ygrp-sponsor #yiv8893158605ygrp-lc {font-family:Arial;}#yiv8893158605 #yiv8893158605ygrp-sponsor #yiv8893158605ygrp-lc #yiv8893158605hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8893158605 #yiv8893158605ygrp-sponsor #yiv8893158605ygrp-lc .yiv8893158605ad {margin-bottom:10px;padding:0 0;}#yiv8893158605 #yiv8893158605actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8893158605 #yiv8893158605activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8893158605 #yiv8893158605activity span {font-weight:700;}#yiv8893158605 #yiv8893158605activity span:first-child {text-transform:uppercase;}#yiv8893158605 #yiv8893158605activity span a {color:#5085b6;text-decoration:none;}#yiv8893158605 #yiv8893158605activity span span {color:#ff7900;}#yiv8893158605 #yiv8893158605activity span .yiv8893158605underline {text-decoration:underline;}#yiv8893158605 .yiv8893158605attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8893158605 .yiv8893158605attach div a {text-decoration:none;}#yiv8893158605 .yiv8893158605attach img {border:none;padding-right:5px;}#yiv8893158605 .yiv8893158605attach label {display:block;margin-bottom:5px;}#yiv8893158605 .yiv8893158605attach label a {text-decoration:none;}#yiv8893158605 blockquote {margin:0 0 0 4px;}#yiv8893158605 .yiv8893158605bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8893158605 .yiv8893158605bold a {text-decoration:none;}#yiv8893158605 dd.yiv8893158605last p a {font-family:Verdana;font-weight:700;}#yiv8893158605 dd.yiv8893158605last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8893158605 dd.yiv8893158605last p span.yiv8893158605yshortcuts {margin-right:0;}#yiv8893158605 div.yiv8893158605attach-table div div a {text-decoration:none;}#yiv8893158605 div.yiv8893158605attach-table {width:400px;}#yiv8893158605 div.yiv8893158605file-title a, #yiv8893158605 div.yiv8893158605file-title a:active, #yiv8893158605 div.yiv8893158605file-title a:hover, #yiv8893158605 div.yiv8893158605file-title a:visited {text-decoration:none;}#yiv8893158605 div.yiv8893158605photo-title a, #yiv8893158605 div.yiv8893158605photo-title a:active, #yiv8893158605 div.yiv8893158605photo-title a:hover, #yiv8893158605 div.yiv8893158605photo-title a:visited {text-decoration:none;}#yiv8893158605 div#yiv8893158605ygrp-mlmsg #yiv8893158605ygrp-msg p a span.yiv8893158605yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8893158605 .yiv8893158605green {color:#628c2a;}#yiv8893158605 .yiv8893158605MsoNormal {margin:0 0 0 0;}#yiv8893158605 o {font-size:0;}#yiv8893158605 #yiv8893158605photos div {float:left;width:72px;}#yiv8893158605 #yiv8893158605photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8893158605 #yiv8893158605photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8893158605 #yiv8893158605reco-category {font-size:77%;}#yiv8893158605 #yiv8893158605reco-desc {font-size:77%;}#yiv8893158605 .yiv8893158605replbq {margin:4px;}#yiv8893158605 #yiv8893158605ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8893158605 #yiv8893158605ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8893158605 #yiv8893158605ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8893158605 #yiv8893158605ygrp-mlmsg select, #yiv8893158605 input, #yiv8893158605 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8893158605 #yiv8893158605ygrp-mlmsg pre, #yiv8893158605 code {font:115% monospace;}#yiv8893158605 #yiv8893158605ygrp-mlmsg * {line-height:1.22em;}#yiv8893158605 #yiv8893158605ygrp-mlmsg #yiv8893158605logo {padding-bottom:10px;}#yiv8893158605 #yiv8893158605ygrp-msg p a {font-family:Verdana;}#yiv8893158605 #yiv8893158605ygrp-msg p#yiv8893158605attach-count span {color:#1E66AE;font-weight:700;}#yiv8893158605 #yiv8893158605ygrp-reco #yiv8893158605reco-head {color:#ff7900;font-weight:700;}#yiv8893158605 #yiv8893158605ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8893158605 #yiv8893158605ygrp-sponsor #yiv8893158605ov li a {font-size:130%;text-decoration:none;}#yiv8893158605 #yiv8893158605ygrp-sponsor #yiv8893158605ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8893158605 #yiv8893158605ygrp-sponsor #yiv8893158605ov ul {margin:0;padding:0 0 0 8px;}#yiv8893158605 #yiv8893158605ygrp-text {font-family:Georgia;}#yiv8893158605 #yiv8893158605ygrp-text p {margin:0 0 1em 0;}#yiv8893158605 #yiv8893158605ygrp-text tt {font-size:120%;}#yiv8893158605 #yiv8893158605ygrp-vital ul li:last-child {border-right:none !important;}#yiv8893158605

Fri Nov 17, 2017 12:10 pm (PST) . Posted by:

ridgebacksexcel

Thanks Randy and all. I will work on it.

Fri Nov 17, 2017 12:20 pm (PST) . Posted by:

ridgebacksexcel

Randy,


In the last few days I have been having an issue with the RCHCreateComment function.


I have a template, probably from you a while back that pulls up the Stock Chart for 35 stocks on a grid of 5 columns by 7 Rows. It has always worked fine but now the first row is compressed by half and the others rows show blank.


The formula is: =RCHCreateComment(B2,INT(3+RAND()),,,1)
The only variable is B2-B8, C2-C8, D2-D8, E2-E8, F2-F8.


Was this perhaps because of a change to the add-in or StockCharts.com site?


Fri Nov 17, 2017 12:50 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Hmm. It appears to work fine here? I tried the template on the Yahoo group:

https://groups.yahoo.com/neo/groups/smf_addin/files/Templates%20and%20Examples/SMF-Template-RCHCreateComment-Charts-Layout.xls

These days, I usually just use the Stockcharts CandleGlance page:

http://stockcharts.com/freecharts/candleglance.html?[DOW]

It can display up to 12 at a time. I have a folder of bookmarks in Chrome
for various groups of stocks.

On Fri, Nov 17, 2017 at 1:20 PM, tmallen2@
​...
wrote:

> In the last few days I have been having an issue with the RCHCreateComment
> function.
>
> I have a template, probably from you a while back that pulls up the Stock
> Chart for 35 stocks on a grid of 5 columns by 7 Rows. It has always worked
> fine but now the first row is compressed by half and the others rows show
> blank.
>
> The formula is: =RCHCreateComment(B2,INT(3+RAND()),,,1)
>
> The only variable is B2-B8, C2-C8, D2-D8, E2-E8, F2-F8.
>
> Was this perhaps because of a change to the add-in or StockCharts.com site?
>
>
>

Fri Nov 17, 2017 12:22 pm (PST) . Posted by:

tony9bb

In the smfGetAdvFNElement-Template-All-Line-Items.xls, the pre-tax income is not loading.


I think I know why, but I don't know how to fix it.


The HTML label "Pre-Tax Income" has a space at the end of the line, before the "</td>".


Is there something I can do in the formula to fix this?


Thanks,
Tony M





Fri Nov 17, 2017 1:06 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Change the formula in cell D43 to be:

=IF(OR(UPPER(Ticker)="NONE",COLUMNS($D:D)>rPeriods),"--",smfGetAdvFNElement(Ticker,rAQ,COLUMNS($D:D),">"&$C43&"
<",,"--"))

...and copy it rightward. All I did was add a blank to this string:

&"<"

...so it would be:

&" <"

On Fri, Nov 17, 2017 at 1:22 PM, tony9bb@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> In the smfGetAdvFNElement-Template-All-Line-Items.xls, the pre-tax income
> is not loading.
>
> I think I know why, but I don't know how to fix it.
>
> The HTML label "Pre-Tax Income" has a space at the end of the line, before
> the "</td>".
>
> Is there something I can do in the formula to fix this?
>
>
>

Fri Nov 17, 2017 1:22 pm (PST) . Posted by:

tony9bb

I figured it would be something simple. . . for you. For me . . . not so much.


Once again you're awesome.


Thanks,
Tony M

Fri Nov 17, 2017 1:13 pm (PST) . Posted by:

tube1296@gmail.com

First I want to say thanks to Randy for the Add-in. I just came across it, and its great.

I think that I have come across a problem on Yahoo Finance. It seems that the dividend they report for Canadian stocks is wrong. Check out SU.TO or BNS.TO. Anyone else come across this? Am I looking at it incorrectly? Is there a work around?

Thanks.



Fri Nov 17, 2017 1:25 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Sorry, but I don't have an answer for that issue. Have you notified Yahoo
of the issue (not that it gets results)?

Is it possible that have converted the dividends into US amounts?

On Fri, Nov 17, 2017 at 2:11 PM, tube1296@
​...
wrote:

>
> First I want to say thanks to Randy for the Add-in. I just came across
> it, and its great.
>
> I think that I have come across a problem on Yahoo Finance. It seems that
> the dividend they report for Canadian stocks is wrong. Check out SU.TO
> or BNS.TO. Anyone else come across this? Am I looking at it
> incorrectly? Is there a work around?
>
>

Fri Nov 17, 2017 2:08 pm (PST) . Posted by:

tube1296@gmail.com

I haven't contacted Yahoo yet. I checked the currency exchange issue, and it wasn't it. Both the rate and yield are whacked and they aren't consistent with each other (at least not that I could reconcile).
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 18.21

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)