Rabu, 11 Februari 2015

[smf_addin] Digest Number 3320

15 Messages

Digest #3320
1a
Re: SMF and Excel 64 bit by "Gary Hartling" garyhartling
1b
Re: SMF and Excel 64 bit by "Brad Reel" reeldeal9090
2
Fund Analyzer Workbook by bobsledproductions
3a
List of Symbols by "J@Y" g3m1n1980
3b
Re: List of Symbols by "Randy Harmelink" rharmelink
3c
Re: List of Symbols by "J@Y" g3m1n1980
3d
Re: List of Symbols by "Randy Harmelink" rharmelink
3e
Re: List of Symbols by "J@Y" g3m1n1980
5a
Excel or not Excel? by "Alex" ar3582
5b
Re: Excel or not Excel? by "Brad Reel" reeldeal9090
5c
Re: Excel or not Excel? by "Alex" ar3582
5d
Re: Excel or not Excel? by "Jose Jacob" pepecan47
5e
Re: Excel or not Excel? by "Brad Reel" reeldeal9090
6
FX rates from Oanda by bushpilote

Messages

Tue Feb 10, 2015 6:37 am (PST) . Posted by:

"Gary Hartling" garyhartling

Are you sure it's 64-bit Excel and not 64-bit Windows? They are two
different things.
Excel installs as 32-bit by default. Very few people use 64-bit Excel.

-- Gary H.

Tue Feb 10, 2015 6:41 am (PST) . Posted by:

"Brad Reel" reeldeal9090

I did look at my version of excel just now and it is 32 bit. Sorry about
that. My bad.

On Tue, Feb 10, 2015 at 8:37 AM, Gary Hartling Gary.Hartling@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> Are you sure it's 64-bit Excel and not 64-bit Windows? They are two
> different things.
> Excel installs as 32-bit by default. Very few people use 64-bit Excel.
>
> -- Gary H.
>
>
>

Tue Feb 10, 2015 8:53 am (PST) . Posted by:

bobsledproductions

Just published a Fund Analyzer workbook here (built on and extended the ETF Analyzer):


http://toteboard.net/blog/workbooks/fund-analyzer/ http://toteboard.net/blog/workbooks/fund-analyzer/







Tue Feb 10, 2015 5:09 pm (PST) . Posted by:

"J@Y" g3m1n1980



Randy,

Do you have a template for list of tickers? Finviz hasnt been working on the output/export to excel anymore.

Im looking to grab this table for just ticker and name

=IF(TICKER="None","",RCHGetHTMLTable("http://www.findata.co.nz/Markets/NASDAQ.htm/?symbol="&TICKER,"Name",-1,"",1))

Site is http://www.findata.co.nz/Markets/NASDAQ.htm

I just care for name and code column.

Thanks

Jason

Tue Feb 10, 2015 6:08 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

No template. I don't see the value of it, since it changes every day. And
different data sources use different ticker symbols. And have a universe of
different equities.

Having said that, Zacks screening tool does allow you to export the results
of a screen in a single file.

Your formula below should be:

=RCHGetHTMLTable("http://www.findata.co.nz/markets/NASDAQ/symbols/A.htm
",">Code",-1,"",1)

...but you'd need to iterate over exchanges and letters.

On Tue, Feb 10, 2015 at 6:09 PM, 'J@Y' xxjaysonxx@aol.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Do you have a template for list of tickers? Finviz hasnt been working on
> the output/export to excel anymore.
>
> Im looking to grab this table for just ticker and name
>
> =IF(TICKER="None","",RCHGetHTMLTable("
> http://www.findata.co.nz/Markets/NASDAQ.htm/?symbol=
> "&TICKER,"Name",-1,"",1))
>
> Site is http://www.findata.co.nz/Markets/NASDAQ.htm
>
> I just care for name and code column.
>
>

Tue Feb 10, 2015 6:43 pm (PST) . Posted by:

"J@Y" g3m1n1980

Randy,

Makes sense and I dont need the tickers linked to the SMF as I can just paste them.

Im able to pull some stuff on Finviz IE - =RCHGetTableCell("http://finviz.com/groups.ashx?g=sector&v=110&o=name/",2,">Basic Materials",,,,8,"</table",,"--")

But im not able to grab anything from this table - =RCHGetHTMLTable(" http://finviz.com/screener.ashx?v=111",">Company",-1,"",1)

Any thoughts here? http://finviz.com/screener.ashx?v=111

The getcsv doesnt work here anymore

Thanks

Jason

=RCHGetHTMLTable(" http://www.findata.co.nz/markets/NASDAQ/symbols/A.htm",">Code",-1,"",1)

-----Original Message-----
From: Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Tue, Feb 10, 2015 9:08 pm
Subject: Re: [smf_addin] List of Symbols

No template. I don't see the value of it, since it changes every day. And different data sources use different ticker symbols. And have a universe of different equities.


Having said that, Zacks screening tool does allow you to export the results of a screen in a single file.


Your formula below should be:

=RCHGetHTMLTable(" http://www.findata.co.nz/markets/NASDAQ/symbols/A.htm",">Code",-1,"",1)


...but you'd need to iterate over exchanges and letters.





On Tue, Feb 10, 2015 at 6:09 PM, 'J@Y' xxjaysonxx@aol.com [smf_addin] <smf_addin@yahoogroups.com> wrote:






Do you have a template for list of tickers? Finviz hasnt been working on the output/export to excel anymore.




Im looking to grab this table for just ticker and name




=IF(TICKER="None","",RCHGetHTMLTable("http://www.findata.co.nz/Markets/NASDAQ.htm/?symbol="&TICKER,"Name",-1,"",1))




Site is http://www.findata.co.nz/Markets/NASDAQ.htm




I just care for name and code column.

















Tue Feb 10, 2015 7:39 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I'm not having any luck with the Finviz webpage either:

http://finviz.com/screener.ashx?v=111

It throws the RCHGetHTMLTable() extraction routine into an infinite loop.

The ">Company" search term was not a good one. That string occurs at least
once before the table heading.

The CSV export feature of FinViz screens is now only available to members.

On Tue, Feb 10, 2015 at 7:43 PM, 'J@Y' xxjaysonxx@aol.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Makes sense and I dont need the tickers linked to the SMF as I can just
> paste them.
>
> Im able to pull some stuff on Finviz IE - =RCHGetTableCell("
> http://finviz.com/groups.ashx?g=sector&v=110&o=name/",2,">Basic
> Materials",,,,8,"</table",,"--")
>
> But im not able to grab anything from this table - =RCHGetHTMLTable("
> http://finviz.com/screener.ashx?v=111",">Company",-1,"",1)
>
> Any thoughts here? http://finviz.com/screener.ashx?v=111
>
> The getcsv doesnt work here anymore
>
>

Tue Feb 10, 2015 7:47 pm (PST) . Posted by:

"J@Y" g3m1n1980

Thats what I figured. Thanks for double checking

-----Original Message-----
From: Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Tue, Feb 10, 2015 10:39 pm
Subject: Re: [smf_addin] List of Symbols

I'm not having any luck with the Finviz webpage either:

http://finviz.com/screener.ashx?v=111


It throws the RCHGetHTMLTable() extraction routine into an infinite loop.


The ">Company" search term was not a good one. That string occurs at least once before the table heading.


The CSV export feature of FinViz screens is now only available to members.





On Tue, Feb 10, 2015 at 7:43 PM, 'J@Y' xxjaysonxx@aol.com [smf_addin] <smf_addin@yahoogroups.com> wrote:




Makes sense and I dont need the tickers linked to the SMF as I can just paste them.




Im able to pull some stuff on Finviz IE - =RCHGetTableCell(" http://finviz.com/groups.ashx?g=sector&v=110&o=name/",2,">Basic Materials",,,,8,"</table",,"--")




But im not able to grab anything from this table - =RCHGetHTMLTable(" http://finviz.com/screener.ashx?v=111",">Company",-1,"",1)




Any thoughts here? http://finviz.com/screener.ashx?v=111




The getcsv doesnt work here anymore















Tue Feb 10, 2015 10:24 pm (PST) . Posted by:

jimw1705

Randy, thanks so much for the help. I need to read up on the GetTagContent function. Looks like that will work better than the GetTableCell I was trying to use because in some cases the NAV is missing from Bloomberg.

I'm still trying to figure out the API and what data is returned from the Bloomberg site so I have a better understanding of all this.

Thanks again.


Jim

Wed Feb 11, 2015 10:53 am (PST) . Posted by:

"Alex" ar3582

Hi I am wondering if anyone can recommend a good Excel book that would cover what's needed to create stock related worksheets? I am a novice with Excel so it would be great if it would start basic, but also cover VBA, Macros and functions if possible. Also, I use Excel 2002 (PC), but if needed would buy the new or newer version. Thanks. 
 Best Regards,
Alex

Wed Feb 11, 2015 11:08 am (PST) . Posted by:

"Brad Reel" reeldeal9090

I have been using Excel for 20 years, so I can't really speak to a book on
Excel in general. I have looked at some books - like the Excel 2013 Bible
- and I think they are great for getting started and also have good VBA
info. I ultimately decided not to buy because I didn't really have a use
for the Excel general knowledge and I have found that I can Google any VBA
topic I need to get info on and probably figure it out better than a book.
A Google search on "Excel 2013, VBA [subject]" will get you more info than
you could possibly want probably 98% of the time.

I would recommend updating to a more recent copy of excel. If only because
there is more info on the Interwebs on the newer versions, and if you do
get a book, it will cover the newest version.

You might also want to consider an online class, community college, or
something like that. Might cost a little more than a book, but, if its a
good class, you will learn tons more that you will from the book.

On Wed, Feb 11, 2015 at 12:52 PM, Alex ar3582@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> Hi I am wondering if anyone can recommend a good Excel book that would
> cover what's needed to create stock related worksheets? I am a novice with
> Excel so it would be great if it would start basic, but also cover VBA,
> Macros and functions if possible. Also, I use Excel 2002 (PC), but if
> needed would buy the new or newer version. Thanks.
>
> Best Regards,
> Alex
>
>
>

Wed Feb 11, 2015 11:17 am (PST) . Posted by:

"Alex" ar3582

Thanks Brad, part of my problem is that even the most basic issue like opening a macro or knowing how to edit a function is new to me. Meaning I do not know how to do it. I hear you on a class that it would be better, but I am limited to a book for now.  Best Regards,
Alex
From: "Brad Reel brad.reel90@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Wednesday, February 11, 2015 1:01 PM
Subject: Re: [smf_addin] Excel or not Excel?

  I have been using Excel for 20 years, so I can't really speak to a book on Excel in general.  I have looked at some books - like the Excel 2013 Bible - and I think they are great for getting started and also have good VBA info.  I ultimately decided not to buy because I didn't really have a use for the Excel general knowledge and I have found that I can Google any VBA topic I need to get info on and probably figure it out better than a book.  A Google search on "Excel 2013, VBA [subject]" will get you more info than you could possibly want probably 98% of the time.
I would recommend updating to a more recent copy of excel.  If only because there is more info on the Interwebs on the newer versions, and if you do get a book, it will cover the newest version.
You might also want to consider an online class, community college, or something like that.  Might cost a little more than a book, but, if its a good class, you will learn tons more that you will from the book.

On Wed, Feb 11, 2015 at 12:52 PM, Alex ar3582@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

  Hi I am wondering if anyone can recommend a good Excel book that would cover what's needed to create stock related worksheets? I am a novice with Excel so it would be great if it would start basic, but also cover VBA, Macros and functions if possible. Also, I use Excel 2002 (PC), but if needed would buy the new or newer version. Thanks. 
 Best Regards,
Alex

#yiv9671957554 #yiv9671957554 -- #yiv9671957554ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9671957554 #yiv9671957554ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9671957554 #yiv9671957554ygrp-mkp #yiv9671957554hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9671957554 #yiv9671957554ygrp-mkp #yiv9671957554ads {margin-bottom:10px;}#yiv9671957554 #yiv9671957554ygrp-mkp .yiv9671957554ad {padding:0 0;}#yiv9671957554 #yiv9671957554ygrp-mkp .yiv9671957554ad p {margin:0;}#yiv9671957554 #yiv9671957554ygrp-mkp .yiv9671957554ad a {color:#0000ff;text-decoration:none;}#yiv9671957554 #yiv9671957554ygrp-sponsor #yiv9671957554ygrp-lc {font-family:Arial;}#yiv9671957554 #yiv9671957554ygrp-sponsor #yiv9671957554ygrp-lc #yiv9671957554hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9671957554 #yiv9671957554ygrp-sponsor #yiv9671957554ygrp-lc .yiv9671957554ad {margin-bottom:10px;padding:0 0;}#yiv9671957554 #yiv9671957554actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9671957554 #yiv9671957554activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9671957554 #yiv9671957554activity span {font-weight:700;}#yiv9671957554 #yiv9671957554activity span:first-child {text-transform:uppercase;}#yiv9671957554 #yiv9671957554activity span a {color:#5085b6;text-decoration:none;}#yiv9671957554 #yiv9671957554activity span span {color:#ff7900;}#yiv9671957554 #yiv9671957554activity span .yiv9671957554underline {text-decoration:underline;}#yiv9671957554 .yiv9671957554attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9671957554 .yiv9671957554attach div a {text-decoration:none;}#yiv9671957554 .yiv9671957554attach img {border:none;padding-right:5px;}#yiv9671957554 .yiv9671957554attach label {display:block;margin-bottom:5px;}#yiv9671957554 .yiv9671957554attach label a {text-decoration:none;}#yiv9671957554 blockquote {margin:0 0 0 4px;}#yiv9671957554 .yiv9671957554bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9671957554 .yiv9671957554bold a {text-decoration:none;}#yiv9671957554 dd.yiv9671957554last p a {font-family:Verdana;font-weight:700;}#yiv9671957554 dd.yiv9671957554last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9671957554 dd.yiv9671957554last p span.yiv9671957554yshortcuts {margin-right:0;}#yiv9671957554 div.yiv9671957554attach-table div div a {text-decoration:none;}#yiv9671957554 div.yiv9671957554attach-table {width:400px;}#yiv9671957554 div.yiv9671957554file-title a, #yiv9671957554 div.yiv9671957554file-title a:active, #yiv9671957554 div.yiv9671957554file-title a:hover, #yiv9671957554 div.yiv9671957554file-title a:visited {text-decoration:none;}#yiv9671957554 div.yiv9671957554photo-title a, #yiv9671957554 div.yiv9671957554photo-title a:active, #yiv9671957554 div.yiv9671957554photo-title a:hover, #yiv9671957554 div.yiv9671957554photo-title a:visited {text-decoration:none;}#yiv9671957554 div#yiv9671957554ygrp-mlmsg #yiv9671957554ygrp-msg p a span.yiv9671957554yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9671957554 .yiv9671957554green {color:#628c2a;}#yiv9671957554 .yiv9671957554MsoNormal {margin:0 0 0 0;}#yiv9671957554 o {font-size:0;}#yiv9671957554 #yiv9671957554photos div {float:left;width:72px;}#yiv9671957554 #yiv9671957554photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9671957554 #yiv9671957554photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9671957554 #yiv9671957554reco-category {font-size:77%;}#yiv9671957554 #yiv9671957554reco-desc {font-size:77%;}#yiv9671957554 .yiv9671957554replbq {margin:4px;}#yiv9671957554 #yiv9671957554ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9671957554 #yiv9671957554ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9671957554 #yiv9671957554ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9671957554 #yiv9671957554ygrp-mlmsg select, #yiv9671957554 input, #yiv9671957554 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9671957554 #yiv9671957554ygrp-mlmsg pre, #yiv9671957554 code {font:115% monospace;}#yiv9671957554 #yiv9671957554ygrp-mlmsg * {line-height:1.22em;}#yiv9671957554 #yiv9671957554ygrp-mlmsg #yiv9671957554logo {padding-bottom:10px;}#yiv9671957554 #yiv9671957554ygrp-msg p a {font-family:Verdana;}#yiv9671957554 #yiv9671957554ygrp-msg p#yiv9671957554attach-count span {color:#1E66AE;font-weight:700;}#yiv9671957554 #yiv9671957554ygrp-reco #yiv9671957554reco-head {color:#ff7900;font-weight:700;}#yiv9671957554 #yiv9671957554ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9671957554 #yiv9671957554ygrp-sponsor #yiv9671957554ov li a {font-size:130%;text-decoration:none;}#yiv9671957554 #yiv9671957554ygrp-sponsor #yiv9671957554ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9671957554 #yiv9671957554ygrp-sponsor #yiv9671957554ov ul {margin:0;padding:0 0 0 8px;}#yiv9671957554 #yiv9671957554ygrp-text {font-family:Georgia;}#yiv9671957554 #yiv9671957554ygrp-text p {margin:0 0 1em 0;}#yiv9671957554 #yiv9671957554ygrp-text tt {font-size:120%;}#yiv9671957554 #yiv9671957554ygrp-vital ul li:last-child {border-right:none !important;}#yiv9671957554

Wed Feb 11, 2015 11:22 am (PST) . Posted by:

"Jose Jacob" pepecan47

You can search in YouTube for free videos about different topics in Excel.

For example

https://www.youtube.com/watch?v=8L1OVkw2ZQ8

Regards,
Jose L. Jacob

--------------------------------------------
On Wed, 2/11/15, Alex ar3582@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] Excel or not Excel?
To: "smf_addin@yahoogroups.com" <smf_addin@yahoogroups.com>
Received: Wednesday, February 11, 2015, 2:17 PM


 









Thanks
Brad, part of my problem is that even the most basic issue
like opening a macro or knowing how to edit a function is
new to me. Meaning I do not know how to do it. I hear you on
a class that it would be better, but I am limited to a book
for now.  Best
Regards,
Alex


From: "Brad Reel
brad.reel90@gmail.com [smf_addin]"
<smf_addin@yahoogroups.com>
To:
smf_addin@yahoogroups.com
Sent: Wednesday,
February 11, 2015 1:01 PM
Subject: Re:
[smf_addin] Excel or not Excel?



 









I have
been using Excel for 20 years, so I can't really speak
to a book on Excel in general.  I have looked at some books
- like the Excel 2013 Bible - and I think they are great for
getting started and also have good VBA info.  I ultimately
decided not to buy because I didn't really have a use
for the Excel general knowledge and I have found that I can
Google any VBA topic I need to get info on and probably
figure it out better than a book.  A Google search on
"Excel 2013, VBA [subject]" will get you more info
than you could possibly want probably 98% of the time.
I would
recommend updating to a more recent copy of excel.  If only
because there is more info on the Interwebs on the newer
versions, and if you do get a book, it will cover the newest
version.
You might
also want to consider an online class, community college, or
something like that.  Might cost a little more than a book,
but, if its a good class, you will learn tons more that you
will from the book.




On Wed, Feb 11, 2015 at
12:52 PM, Alex ar3582@yahoo.com
[smf_addin] <smf_addin@yahoogroups.com>
wrote:















 









Hi I am wondering if anyone can
recommend a good Excel book that would cover what's
needed to create stock related worksheets? I am a novice
with Excel so it would be great if it would start basic, but
also cover VBA, Macros and functions if possible. Also, I
use Excel 2002 (PC), but if needed would buy the new or
newer version. Thanks. 
 Best
Regards,
Alex










































#yiv3518390217 #yiv3518390217 --
#yiv3518390217ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv3518390217 #yiv3518390217ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv3518390217 #yiv3518390217ygrp-mkp #yiv3518390217hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv3518390217 #yiv3518390217ygrp-mkp #yiv3518390217ads {
margin-bottom:10px;}

#yiv3518390217 #yiv3518390217ygrp-mkp .yiv3518390217ad {
padding:0 0;}

#yiv3518390217 #yiv3518390217ygrp-mkp .yiv3518390217ad p {
margin:0;}

#yiv3518390217 #yiv3518390217ygrp-mkp .yiv3518390217ad a {
color:#0000ff;text-decoration:none;}
#yiv3518390217 #yiv3518390217ygrp-sponsor
#yiv3518390217ygrp-lc {
font-family:Arial;}

#yiv3518390217 #yiv3518390217ygrp-sponsor
#yiv3518390217ygrp-lc #yiv3518390217hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv3518390217 #yiv3518390217ygrp-sponsor
#yiv3518390217ygrp-lc .yiv3518390217ad {
margin-bottom:10px;padding:0 0;}

#yiv3518390217 #yiv3518390217actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv3518390217 #yiv3518390217activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv3518390217 #yiv3518390217activity span {
font-weight:700;}

#yiv3518390217 #yiv3518390217activity span:first-child {
text-transform:uppercase;}

#yiv3518390217 #yiv3518390217activity span a {
color:#5085b6;text-decoration:none;}

#yiv3518390217 #yiv3518390217activity span span {
color:#ff7900;}

#yiv3518390217 #yiv3518390217activity span
.yiv3518390217underline {
text-decoration:underline;}

#yiv3518390217 .yiv3518390217attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv3518390217 .yiv3518390217attach div a {
text-decoration:none;}

#yiv3518390217 .yiv3518390217attach img {
border:none;padding-right:5px;}

#yiv3518390217 .yiv3518390217attach label {
display:block;margin-bottom:5px;}

#yiv3518390217 .yiv3518390217attach label a {
text-decoration:none;}

#yiv3518390217 blockquote {
margin:0 0 0 4px;}

#yiv3518390217 .yiv3518390217bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv3518390217 .yiv3518390217bold a {
text-decoration:none;}

#yiv3518390217 dd.yiv3518390217last p a {
font-family:Verdana;font-weight:700;}

#yiv3518390217 dd.yiv3518390217last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv3518390217 dd.yiv3518390217last p
span.yiv3518390217yshortcuts {
margin-right:0;}

#yiv3518390217 div.yiv3518390217attach-table div div a {
text-decoration:none;}

#yiv3518390217 div.yiv3518390217attach-table {
width:400px;}

#yiv3518390217 div.yiv3518390217file-title a, #yiv3518390217
div.yiv3518390217file-title a:active, #yiv3518390217
div.yiv3518390217file-title a:hover, #yiv3518390217
div.yiv3518390217file-title a:visited {
text-decoration:none;}

#yiv3518390217 div.yiv3518390217photo-title a,
#yiv3518390217 div.yiv3518390217photo-title a:active,
#yiv3518390217 div.yiv3518390217photo-title a:hover,
#yiv3518390217 div.yiv3518390217photo-title a:visited {
text-decoration:none;}

#yiv3518390217 div#yiv3518390217ygrp-mlmsg
#yiv3518390217ygrp-msg p a span.yiv3518390217yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv3518390217 .yiv3518390217green {
color:#628c2a;}

#yiv3518390217 .yiv3518390217MsoNormal {
margin:0 0 0 0;}

#yiv3518390217 o {
font-size:0;}

#yiv3518390217 #yiv3518390217photos div {
float:left;width:72px;}

#yiv3518390217 #yiv3518390217photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv3518390217 #yiv3518390217photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv3518390217 #yiv3518390217reco-category {
font-size:77%;}

#yiv3518390217 #yiv3518390217reco-desc {
font-size:77%;}

#yiv3518390217 .yiv3518390217replbq {
margin:4px;}

#yiv3518390217 #yiv3518390217ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv3518390217 #yiv3518390217ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv3518390217 #yiv3518390217ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv3518390217 #yiv3518390217ygrp-mlmsg select,
#yiv3518390217 input, #yiv3518390217 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv3518390217 #yiv3518390217ygrp-mlmsg pre, #yiv3518390217
code {
font:115% monospace;}

#yiv3518390217 #yiv3518390217ygrp-mlmsg * {
line-height:1.22em;}

#yiv3518390217 #yiv3518390217ygrp-mlmsg #yiv3518390217logo {
padding-bottom:10px;}


#yiv3518390217 #yiv3518390217ygrp-msg p a {
font-family:Verdana;}

#yiv3518390217 #yiv3518390217ygrp-msg
p#yiv3518390217attach-count span {
color:#1E66AE;font-weight:700;}

#yiv3518390217 #yiv3518390217ygrp-reco
#yiv3518390217reco-head {
color:#ff7900;font-weight:700;}

#yiv3518390217 #yiv3518390217ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv3518390217 #yiv3518390217ygrp-sponsor #yiv3518390217ov
li a {
font-size:130%;text-decoration:none;}

#yiv3518390217 #yiv3518390217ygrp-sponsor #yiv3518390217ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv3518390217 #yiv3518390217ygrp-sponsor #yiv3518390217ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv3518390217 #yiv3518390217ygrp-text {
font-family:Georgia;}

#yiv3518390217 #yiv3518390217ygrp-text p {
margin:0 0 1em 0;}

#yiv3518390217 #yiv3518390217ygrp-text tt {
font-size:120%;}

#yiv3518390217 #yiv3518390217ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv3518390217


Wed Feb 11, 2015 11:40 am (PST) . Posted by:

"Brad Reel" reeldeal9090

I've actually had pretty good success finding You Tube videos on some
subjects I was stuck on. Anything you are having trouble figuring out just
use that as the search phrase and add Excel to the phrase. You will be
surprised what you get.

I sat in Barnes & Noble one day for about an hour and paged through the
Excel 2013 Bible. It is a great reference. I almost bought it, but
decided that there wasn't enough new there for me for what I was trying to
do and given what I already know. It might be great for you.

On Wed, Feb 11, 2015 at 1:17 PM, Alex ar3582@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> Thanks Brad, part of my problem is that even the most basic issue like
> opening a macro or knowing how to edit a function is new to me. Meaning I
> do not know how to do it. I hear you on a class that it would be better,
> but I am limited to a book for now.
>
> Best Regards,
> Alex
>
> ------------------------------
> *From:* "Brad Reel brad.reel90@gmail.com [smf_addin]" <
> smf_addin@yahoogroups.com>
> *To:* smf_addin@yahoogroups.com
> *Sent:* Wednesday, February 11, 2015 1:01 PM
> *Subject:* Re: [smf_addin] Excel or not Excel?
>
>
> I have been using Excel for 20 years, so I can't really speak to a book
> on Excel in general. I have looked at some books - like the Excel 2013
> Bible - and I think they are great for getting started and also have good
> VBA info. I ultimately decided not to buy because I didn't really have a
> use for the Excel general knowledge and I have found that I can Google any
> VBA topic I need to get info on and probably figure it out better than a
> book. A Google search on "Excel 2013, VBA [subject]" will get you more
> info than you could possibly want probably 98% of the time.
>
> I would recommend updating to a more recent copy of excel. If only
> because there is more info on the Interwebs on the newer versions, and if
> you do get a book, it will cover the newest version.
>
> You might also want to consider an online class, community college, or
> something like that. Might cost a little more than a book, but, if its a
> good class, you will learn tons more that you will from the book.
>
>
>
>
>
> On Wed, Feb 11, 2015 at 12:52 PM, Alex ar3582@yahoo.com [smf_addin] <
> smf_addin@yahoogroups.com> wrote:
>
>
> Hi I am wondering if anyone can recommend a good Excel book that would
> cover what's needed to create stock related worksheets? I am a novice with
> Excel so it would be great if it would start basic, but also cover VBA,
> Macros and functions if possible. Also, I use Excel 2002 (PC), but if
> needed would buy the new or newer version. Thanks.
>
> Best Regards,
> Alex
>
>
>
>
>
>

Wed Feb 11, 2015 11:36 am (PST) . Posted by:

bushpilote

Good afternoon Randy,
The following formula, which converts any two currency pairs for a specified date, has stopped working because Oanda changed their url:


=RCHGetHTMLTable("http://www.oanda.com/convert/fxhistory?date1=2015-2-7&date=2015-2-7&date_fmt=us&exch=USD&expr=INR&format=HTML&redirected=1","Daily
Averages:",1,"Average (",-1)


A google search shows the new url for a csv file for 30 days of data as follows:


http://www.oanda.com/currency/historical-rates/download?quote_currency=USD&end_date=2015-2-7&start_date=2015-1-9&period=daily&display=absolute&rate=0&data_range=d30&price=bid&view=table&base_currency_0=EUR&base_currency_1=&base_currency_2=&base_currency_3=&base_currency_4=&download=csv http://www.oanda.com/currency/historical-rates/download?quote_currency=USD&end_date=2015-2-7&start_date=2015-1-9&period=daily&display=absolute&rate=0&data_range=d30&price=bid&view=table&base_currency_0=EUR&base_currency_1=&base_currency_2=&base_currency_3=&base_currency_4=&download=csv


Any suggestions on how i can rework this in a RCHGetHTMLTable function for a single day?


Thanks.


For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar