1 Message
Digest #3841
Message
Sun Nov 13, 2016 12:16 pm (PST) . Posted by:
"Christopher Chang Sue" cchangsue
Hi Randy,
Not sure if I am doing this right but I am pulling back errors when trying to retrieve the 50 and 200 day moving averages on some stocks that I follow.
The formula I am using is =RCHGetElementNumber(XEN.TO,1226,) and =RCHGetElementNumber(XEN.TO,1236,).
Also I tried using the Yahoo one; =RCHGetElementNumber(XEN.TO,977,) and =RCHGetElementNumber(XEN.TO,978,). This is also bringing back errors.
Your help will be greatly appreciated.
EXCEL Stock Market Functions Add-in EXCEL Stock Market Functions Add-in Group
3 Messages
Digest #3840 1a Help with BarChart by guywoolley@sbcglobal.net 1b Re: Help with BarChart by "Randy Harmelink" rharmelink 2a Recent File updates on the SMF Add-in Website by rharmelink
Messages
1a
Help with BarChart
Fri Nov 11, 2016 1:47 pm (PST) . Posted by:
guywoolley@sbcglobal.net
Randy Is there a work around for =RCHGetElementNumbe r("BarChart MM", 1199)? I have been searching the group but haven't found anything. Thank you.
Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^
1b
Re: Help with BarChart
Fri Nov 11, 2016 3:30 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Sorry about the delay. I just updated the new element definitions. See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30999
The BarChart website changes were discussed at the start of the month.
On Fri, Nov 11, 2016 at 1:53 PM, guywoolley@
...wrote:
> Randy Is there a work around for =RCHGetElementNumbe r("BarChart MM", 1199)?
> I have been searching the group but haven't found anything. Thank you.
>
>
>
Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^
2a
Recent File updates on the SMF Add-in Website
Fri Nov 11, 2016 3:28 pm (PST) . Posted by:
rharmelink
At the beginning of November, BarChart.com complete redesigned their web site, so a number of changes had to be made to element definitions.
Updated files in http://ogres-crypt.com/SMF/Elements
-- RCHGetElementNumber-Element-Definitions.xls
-- smf-elements-9.txt
Updated files in http://ogres-crypt.com/SMF/Templates
-- SMF-Template-Barchart-Market-Momentum.xls
-- RCHGetTableCell-Template-BarChart-Technical-Signals.xls
Updated files in http://ogres-crypt.com/SMF/Documentation
-- Change-Log.html
Updates:
1. Updated Barchart elements on smf-elements- 9.txt for web page changes: #1195-1214. Obsoleted #1146-1194.
2. Updated Barchart elements on smf-elements- 9.txt for web page changes: #701-715, #1215-1284. Added #1101-1110.
The elements for advancing/declining /unchanged and new highs/lows data could not be updated, because the URL to get the data is now a JSON query and is far too long for an EXCEL formula. However, workarounds to get the data are in the Market Momentum template.
Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^ For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF Visit Your Group
- New Members 17
• Privacy • Unsubscribe • Terms of Use
On Sunday, November 13, 2016 5:05 AM, "smf_addin@yahoogroups.com" <smf_addin@yahoogroups.com> wrote:
#yiv9771628553 #yiv9771628553 -- #yiv9771628553ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9771628553 #yiv9771628553ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9771628553 #yiv9771628553ygrp-mkp #yiv9771628553hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9771628553 #yiv9771628553ygrp-mkp #yiv9771628553ads {margin-bottom:10px;}#yiv9771628553 #yiv9771628553ygrp-mkp .yiv9771628553ad {padding:0 0;}#yiv9771628553 #yiv9771628553ygrp-mkp .yiv9771628553ad p {margin:0;}#yiv9771628553 #yiv9771628553ygrp-mkp .yiv9771628553ad a {color:#0000ff;text-decoration:none;}#yiv9771628553 #yiv9771628553ygrp-sponsor #yiv9771628553ygrp-lc {font-family:Arial;}#yiv9771628553 #yiv9771628553ygrp-sponsor #yiv9771628553ygrp-lc #yiv9771628553hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9771628553 #yiv9771628553ygrp-sponsor #yiv9771628553ygrp-lc .yiv9771628553ad {margin-bottom:10px;padding:0 0;}#yiv9771628553
Not sure if I am doing this right but I am pulling back errors when trying to retrieve the 50 and 200 day moving averages on some stocks that I follow.
The formula I am using is =RCHGetElementNumber(XEN.TO,1226,) and =RCHGetElementNumber(XEN.TO,1236,).
Also I tried using the Yahoo one; =RCHGetElementNumber(XEN.TO,977,) and =RCHGetElementNumber(XEN.TO,978,). This is also bringing back errors.
Your help will be greatly appreciated.
EXCEL Stock Market Functions Add-in EXCEL Stock Market Functions Add-in Group
3 Messages
Digest #3840 1a Help with BarChart by guywoolley@sbcglobal.net 1b Re: Help with BarChart by "Randy Harmelink" rharmelink 2a Recent File updates on the SMF Add-in Website by rharmelink
Messages
1a
Help with BarChart
Fri Nov 11, 2016 1:47 pm (PST) . Posted by:
guywoolley@sbcglobal.net
Randy Is there a work around for =RCHGetElementNumbe r("BarChart MM", 1199)? I have been searching the group but haven't found anything. Thank you.
Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^
1b
Re: Help with BarChart
Fri Nov 11, 2016 3:30 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Sorry about the delay. I just updated the new element definitions. See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30999
The BarChart website changes were discussed at the start of the month.
On Fri, Nov 11, 2016 at 1:53 PM, guywoolley@
...wrote:
> Randy Is there a work around for =RCHGetElementNumbe r("BarChart MM", 1199)?
> I have been searching the group but haven't found anything. Thank you.
>
>
>
Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^
2a
Recent File updates on the SMF Add-in Website
Fri Nov 11, 2016 3:28 pm (PST) . Posted by:
rharmelink
At the beginning of November, BarChart.com complete redesigned their web site, so a number of changes had to be made to element definitions.
Updated files in http://ogres-crypt.com/SMF/Elements
-- RCHGetElementNumber-Element-Definitions.xls
-- smf-elements-9.txt
Updated files in http://ogres-crypt.com/SMF/Templates
-- SMF-Template-Barchart-Market-Momentum.xls
-- RCHGetTableCell-Template-BarChart-Technical-Signals.xls
Updated files in http://ogres-crypt.com/SMF/Documentation
-- Change-Log.html
Updates:
1. Updated Barchart elements on smf-elements- 9.txt for web page changes: #1195-1214. Obsoleted #1146-1194.
2. Updated Barchart elements on smf-elements- 9.txt for web page changes: #701-715, #1215-1284. Added #1101-1110.
The elements for advancing/declining /unchanged and new highs/lows data could not be updated, because the URL to get the data is now a JSON query and is far too long for an EXCEL formula. However, workarounds to get the data are in the Market Momentum template.
Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^ For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF Visit Your Group
- New Members 17
• Privacy • Unsubscribe • Terms of Use
On Sunday, November 13, 2016 5:05 AM, "smf_addin@yahoogroups.com" <smf_addin@yahoogroups.com> wrote:
#yiv9771628553 #yiv9771628553 -- #yiv9771628553ygrp-
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar