Kamis, 12 Februari 2015

[smf_addin] Digest Number 3321

8 Messages

Digest #3321
1a
1b
Re: How are you using Excel? by "Brad Reel" reeldeal9090
1c
Re: How are you using Excel? by "james morlock" kagawonger
1d
2a
Re: Excel or not Excel? by "Anant Gupta" anant_guptadbl
3a
Re: FX rates from Oanda by "Randy Harmelink" rharmelink
4b
Re: Randy, when will your program be updated? by "Randy Harmelink" rharmelink

Messages

Wed Feb 11, 2015 12:24 pm (PST) . Posted by:

"Alex" ar3582

As an experienced Excel user (you all) for stock related creations how are you using Excel? Not trying to pry or copy anyone, I would just like to hear that Excel is still very prevalent and needed. I am planning on spending many hours learning on how to use Excel to create stock related worksheets and would like to make sure people still rely on it. Meaning there is a need for it. Another way to ask this is what are you using Excel for that you can't use on a website or another piece of software? Thanks.
 Best Regards,
Alex

Wed Feb 11, 2015 2:30 pm (PST) . Posted by:

"Brad Reel" reeldeal9090

You will need Excel if you plan to use the SMF Add In. However, there are
lots of great sites you can access to do a lot of research. Examples that
come to mind are stockcharts.com, stockfetcher.com, barchart.com.

As I've seen Randy often say in these sort of replies: There are lots of
sites that can be used to filter your selections. Then you should use the
Add-In (and Excel) to get specific info on the stocks that matched your
criteria.

Based on the questions you asked, I would strongly recommend you do some
more research on web sites, trading systems, etc. before diving headlong
into using the Add-In.

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

>
>
> As an experienced Excel user (you all) for stock related creations how are
> you using Excel? Not trying to pry or copy anyone, I would just like to
> hear that Excel is still very prevalent and needed. I am planning on
> spending many hours learning on how to use Excel to create stock related
> worksheets and would like to make sure people still rely on it. Meaning
> there is a need for it. Another way to ask this is what are you using Excel
> for that you can't use on a website or another piece of software? Thanks.
>
> Best Regards,
> Alex
>
>
>

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

"james morlock" kagawonger


 
A spreadsheet is a very flexible tool for working with numbers and
organizing data in row and column format or graphical form.   Excel is
widely used in education, business and industry and learning to use
a spreadsheet like Excel is a basic life skill.
 
The SMF Add In is a tool for extracting stock market and non-stock
market data found on the web and organizing it in an Excel spreadsheet
for further manipulation and analysis.  You don't need Excel or the SMF
Add In for stock market analysis if you are satisfied with the way
data is provided and organized on the web. 
 
You might consider using one of the free spreadsheets to get a better
feel for what a spreadsheet can do for you.  The conceptual skills
learned in using one of the free spreadsheets will be generally
transferrable to Excel.  However, you will need to Excel if you want to
use the SMF Add In as the add in has been designed to work with Excel,
and not the other free spreadsheet products out there.
 

 
On Wed, Feb 11, 2015 at 03:24 PM, Alex ar3582@yahoo.com [smf_addin]
wrote:
 
 

 

As an experienced Excel user (you all) for stock related creations how
are you using Excel? Not trying to pry or copy anyone, I would just like
to hear that Excel is still very prevalent and needed. I am planning on
spending many hours learning on how to use Excel to create stock related
worksheets and would like to make sure people still rely on it. Meaning
there is a need for it. Another way to ask this is what are you using
Excel for that you can't use on a website or another piece of software?
Thanks.

 

Best Regards,
Alex

Wed Feb 11, 2015 8:54 pm (PST) . Posted by:

"Alex" ar3582

Thanks James, very well put.
 Best Regards,
Alex
From: "james morlock JimMorlock@optonline.net [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Cc: "smf_addin@yahoogroups.com" <smf_addin@yahoogroups.com>
Sent: Wednesday, February 11, 2015 10:17 PM
Subject: RE: [smf_addin] How are you using Excel?

   A spreadsheet is a very flexible tool for working with numbers and organizing data in row and column format or graphical form.   Excel is widely used in education, business and industry and learning to use a spreadsheet like Excel is a basic life skill. The SMF Add In is a tool for extracting stock market and non-stock market data found on the web and organizing it in an Excel spreadsheet for further manipulation and analysis.  You don't need Excel or the SMF Add In for stock market analysis if you are satisfied with the way data is provided and organized on the web.   You might consider using one of the free spreadsheets to get a better feel for what a spreadsheet can do for you.  The conceptual skills learned in using one of the free spreadsheets will be generally transferrable to Excel.  However, you will need to Excel if you want to use the SMF Add In as the add in has been designed to work with Excel, and not the other free spreadsheet products out there.  On Wed, Feb 11, 2015 at 03:24 PM, Alex ar3582@yahoo.com [smf_addin] wrote:  

  As an experienced Excel user (you all) for stock related creations how are you using Excel? Not trying to pry or copy anyone, I would just like to hear that Excel is still very prevalent and needed. I am planning on spending many hours learning on how to use Excel to create stock related worksheets and would like to make sure people still rely on it. Meaning there is a need for it. Another way to ask this is what are you using Excel for that you can't use on a website or another piece of software? Thanks.
 Best Regards,
Alex

#yiv0969440601 #yiv0969440601 -- #yiv0969440601ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0969440601 #yiv0969440601ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0969440601 #yiv0969440601ygrp-mkp #yiv0969440601hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0969440601 #yiv0969440601ygrp-mkp #yiv0969440601ads {margin-bottom:10px;}#yiv0969440601 #yiv0969440601ygrp-mkp .yiv0969440601ad {padding:0 0;}#yiv0969440601 #yiv0969440601ygrp-mkp .yiv0969440601ad p {margin:0;}#yiv0969440601 #yiv0969440601ygrp-mkp .yiv0969440601ad a {color:#0000ff;text-decoration:none;}#yiv0969440601 #yiv0969440601ygrp-sponsor #yiv0969440601ygrp-lc {font-family:Arial;}#yiv0969440601 #yiv0969440601ygrp-sponsor #yiv0969440601ygrp-lc #yiv0969440601hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0969440601 #yiv0969440601ygrp-sponsor #yiv0969440601ygrp-lc .yiv0969440601ad {margin-bottom:10px;padding:0 0;}#yiv0969440601 #yiv0969440601actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0969440601 #yiv0969440601activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0969440601 #yiv0969440601activity span {font-weight:700;}#yiv0969440601 #yiv0969440601activity span:first-child {text-transform:uppercase;}#yiv0969440601 #yiv0969440601activity span a {color:#5085b6;text-decoration:none;}#yiv0969440601 #yiv0969440601activity span span {color:#ff7900;}#yiv0969440601 #yiv0969440601activity span .yiv0969440601underline {text-decoration:underline;}#yiv0969440601 .yiv0969440601attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0969440601 .yiv0969440601attach div a {text-decoration:none;}#yiv0969440601 .yiv0969440601attach img {border:none;padding-right:5px;}#yiv0969440601 .yiv0969440601attach label {display:block;margin-bottom:5px;}#yiv0969440601 .yiv0969440601attach label a {text-decoration:none;}#yiv0969440601 blockquote {margin:0 0 0 4px;}#yiv0969440601 .yiv0969440601bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0969440601 .yiv0969440601bold a {text-decoration:none;}#yiv0969440601 dd.yiv0969440601last p a {font-family:Verdana;font-weight:700;}#yiv0969440601 dd.yiv0969440601last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0969440601 dd.yiv0969440601last p span.yiv0969440601yshortcuts {margin-right:0;}#yiv0969440601 div.yiv0969440601attach-table div div a {text-decoration:none;}#yiv0969440601 div.yiv0969440601attach-table {width:400px;}#yiv0969440601 div.yiv0969440601file-title a, #yiv0969440601 div.yiv0969440601file-title a:active, #yiv0969440601 div.yiv0969440601file-title a:hover, #yiv0969440601 div.yiv0969440601file-title a:visited {text-decoration:none;}#yiv0969440601 div.yiv0969440601photo-title a, #yiv0969440601 div.yiv0969440601photo-title a:active, #yiv0969440601 div.yiv0969440601photo-title a:hover, #yiv0969440601 div.yiv0969440601photo-title a:visited {text-decoration:none;}#yiv0969440601 div#yiv0969440601ygrp-mlmsg #yiv0969440601ygrp-msg p a span.yiv0969440601yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0969440601 .yiv0969440601green {color:#628c2a;}#yiv0969440601 .yiv0969440601MsoNormal {margin:0 0 0 0;}#yiv0969440601 o {font-size:0;}#yiv0969440601 #yiv0969440601photos div {float:left;width:72px;}#yiv0969440601 #yiv0969440601photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0969440601 #yiv0969440601photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0969440601 #yiv0969440601reco-category {font-size:77%;}#yiv0969440601 #yiv0969440601reco-desc {font-size:77%;}#yiv0969440601 .yiv0969440601replbq {margin:4px;}#yiv0969440601 #yiv0969440601ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0969440601 #yiv0969440601ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0969440601 #yiv0969440601ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0969440601 #yiv0969440601ygrp-mlmsg select, #yiv0969440601 input, #yiv0969440601 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0969440601 #yiv0969440601ygrp-mlmsg pre, #yiv0969440601 code {font:115% monospace;}#yiv0969440601 #yiv0969440601ygrp-mlmsg * {line-height:1.22em;}#yiv0969440601 #yiv0969440601ygrp-mlmsg #yiv0969440601logo {padding-bottom:10px;}#yiv0969440601 #yiv0969440601ygrp-msg p a {font-family:Verdana;}#yiv0969440601 #yiv0969440601ygrp-msg p#yiv0969440601attach-count span {color:#1E66AE;font-weight:700;}#yiv0969440601 #yiv0969440601ygrp-reco #yiv0969440601reco-head {color:#ff7900;font-weight:700;}#yiv0969440601 #yiv0969440601ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0969440601 #yiv0969440601ygrp-sponsor #yiv0969440601ov li a {font-size:130%;text-decoration:none;}#yiv0969440601 #yiv0969440601ygrp-sponsor #yiv0969440601ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0969440601 #yiv0969440601ygrp-sponsor #yiv0969440601ov ul {margin:0;padding:0 0 0 8px;}#yiv0969440601 #yiv0969440601ygrp-text {font-family:Georgia;}#yiv0969440601 #yiv0969440601ygrp-text p {margin:0 0 1em 0;}#yiv0969440601 #yiv0969440601ygrp-text tt {font-size:120%;}#yiv0969440601 #yiv0969440601ygrp-vital ul li:last-child {border-right:none !important;}#yiv0969440601

Wed Feb 11, 2015 12:30 pm (PST) . Posted by:

"Anant Gupta" anant_guptadbl

Hi,
If you buy any excel cookbook, it will give you practical examples. Going through a complete excel book might be tedious. With excel it is better to learn by trying to replicate a problem e.g VAR etc
Regards,
Anant
On Feb 12, 2015 12:52 AM, "Jose Jacob pepecan47@yahoo.ca mailto:pepecan47@yahoo.ca [smf_addin]" <smf_addin@yahoogroups.com mailto:smf_addin@yahoogroups.com> wrote:
You can search in YouTube for free videos about different topics in Excel.

For example

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

Regards,
Jose L. Jacob

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

Subject: Re: [smf_addin] Excel or not Excel?
To: "smf_addin@yahoogroups.com mailto:smf_addin@yahoogroups.com" <smf_addin@yahoogroups.com mailto: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 mailto:brad.reel90@gmail.com [smf_addin]"
<smf_addin@yahoogroups.com mailto:smf_addin@yahoogroups.com>
To:
smf_addin@yahoogroups.com mailto: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 mailto:ar3582@yahoo.com
[smf_addin] <smf_addin@yahoogroups.com mailto: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 4:20 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Looks like the new URL they generate for a single day works fine:

=RCHGetHTMLTable("
http://www.oanda.com/currency/table?date=02/07/15&date_fmt=us&exch=USD&sel_list=CAD&value=1&format=HTML&redirected=1",">
Code",-1,"",1)

On Wed, Feb 11, 2015 at 12:36 PM, bushpilote@yahoo.ca [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> 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
>
> Any suggestions on how i can rework this in a RCHGetHTMLTable function
> for a single day?
>

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

zbgb952

Hello, looking at your website, it appears the official version is still dated for January 2014. When will there be a new version that has all the changes you have made since? Also, I according you your website, the beta version (RCH_Stock_Market_Functions-2.1.2014.10.23.B.zip http://ogres-crypt.com/SMF/Works-In-Progress/RCH_Stock_Market_Functions-2.1.2014.10.23.B.zip) has 0 size. Why is this? Thanks.


Thu Feb 12, 2015 1:26 am (PST) . Posted by:

"Randy Harmelink" rharmelink

As far as the update, I've been for Yahoo to revert back to the new format
of their options pages. They still have the new format on Chrome and
FireFox, but not IE. That is, 2014.10.12.B doesn't work for Yahoo options
as they are currently displayed in IE.

As for the 0 size, my bad. I forgot to update the value.

On Wed, Feb 11, 2015 at 11:53 PM, mb0329@msn.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Hello, looking at your website, it appears the official version is still
> dated for January 2014. When will there be a new version that has all the
> changes you have made since? Also, I according you your website, the beta
> version (RCH_Stock_Market_Functions-2.1.2014.10.23.B.zip
> <http://ogres-crypt.com/SMF/Works-In-Progress/RCH_Stock_Market_Functions-2.1.2014.10.23.B.zip>)
> has 0 size. Why is this? Thanks.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar