3 Messages
Digest #3724
Messages
Tue Jun 7, 2016 6:09 am (PDT) . Posted by:
nicolaslee1992
What made you decide to create this product in the first place and why is it all free?
Tue Jun 7, 2016 6:52 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I was doing a lot of financial analysis on the PC using EXCEL 2000 (or
2002) web queries to get data into the workbooks. And EXCEL would always
crash after a number of queries had been done. So I started writing some
VBA routines to get the data my own way. I was on the XLTraders Yahoo group
back then, and people would ask how to do the things I was doing when I
mentioned I used VBA to do it. So I started sharing code there. I then
combined them into an XLA file so they were easier to share. One by one,
new functions got added, either because I wanted to get some data into
EXCEL, or someone was requesting a way to get some data. Pretty soon, even
a ZIP version of the XLA was getting too large for that group, because
Yahoo groups only had something like 10 or 20 megabytes of storage
allocated for files. So I started my own Yahoo group, just as a storage
location for the ZIP file. And it grew from there.
I've always been a believer of freeware and shareware. So I'm basically
just sharing something I wrote for my own use, which then expanded. I think
if I charged for it, it would become a job and I'd resent having anything
to do with it.
I've had a number of times people have said they'd been working on
something for weeks, even months, and were asking for advice. Many only
took less than 30 minutes to do. Others an hour or two. Some I found beyond
my understanding or capability (e.g. Darvas boxes). It was usually a matter
of people finding something that piqued my interest, and I'd be on it like
a bulldog on a bone. But offer me money to do it, and I'd quickly lose
interest.
I'm actually shocked there isn't a commercial product available by now. Or
that one of the major players haven't done it themselves. MSN had an add-in
a few years ago, but they dropped it. They actually dropped a lot of good
financial tools and data. Their stock screener used to be in the top tier.
On Tue, Jun 7, 2016 at 6:09 AM, nicolaslee1992@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> What made you decide to create this product in the first place and why is
> it all free?
>
2002) web queries to get data into the workbooks. And EXCEL would always
crash after a number of queries had been done. So I started writing some
VBA routines to get the data my own way. I was on the XLTraders Yahoo group
back then, and people would ask how to do the things I was doing when I
mentioned I used VBA to do it. So I started sharing code there. I then
combined them into an XLA file so they were easier to share. One by one,
new functions got added, either because I wanted to get some data into
EXCEL, or someone was requesting a way to get some data. Pretty soon, even
a ZIP version of the XLA was getting too large for that group, because
Yahoo groups only had something like 10 or 20 megabytes of storage
allocated for files. So I started my own Yahoo group, just as a storage
location for the ZIP file. And it grew from there.
I've always been a believer of freeware and shareware. So I'm basically
just sharing something I wrote for my own use, which then expanded. I think
if I charged for it, it would become a job and I'd resent having anything
to do with it.
I've had a number of times people have said they'd been working on
something for weeks, even months, and were asking for advice. Many only
took less than 30 minutes to do. Others an hour or two. Some I found beyond
my understanding or capability (e.g. Darvas boxes). It was usually a matter
of people finding something that piqued my interest, and I'd be on it like
a bulldog on a bone. But offer me money to do it, and I'd quickly lose
interest.
I'm actually shocked there isn't a commercial product available by now. Or
that one of the major players haven't done it themselves. MSN had an add-in
a few years ago, but they dropped it. They actually dropped a lot of good
financial tools and data. Their stock screener used to be in the top tier.
On Tue, Jun 7, 2016 at 6:09 AM, nicolaslee1992@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> What made you decide to create this product in the first place and why is
> it all free?
>
Tue Jun 7, 2016 7:47 am (PDT) . Posted by:
nicolaslee1992
Well I really appreciate it man. Been able to build out some crazy models.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar