Excel

If you can see the data somewhere, just block, copy and drop it in Excel. You'd be surprised how well this works on many websites.

When you right click, use paste special to exclude any formatting or extra stuff that got copied.
 
Quote from Brian Diesel:

I'm interested in learning to program with Excel as well. What would anyone rec. to learn? VBA, C+, etc

Thanks,

Brian
More...

VBA is definitely the way to go with excel for several reasons:

1. VBA (or VB) is a relatively easy language to learn, and yet it is powerful enough to do most tasks.

2. It is built into excel.

3. You can use the macro recorder to create VBA code and modify it for your purposes. This also can be a great learning tool.

4. There are lots of resources on the web for learning.
 
Quote from kwancy:

too hard for me, I do not have programming background as I studied life science at University. Give me the weekend to go over my excel bible and the links. I took a glimpse but already found the first link too hard to understand for me.

I appreciate all the help offered

thanks
More...

I would highly recommend everyone learn how to program. You will find that you can automate most people's jobs out of existance (ie. trading pits, execution traders,...). The thing is most people give up after looking at a page or less of programming material.
 
Quote from Brian Diesel:

I'm interested in learning to program with Excel as well. What would anyone rec. to learn? VBA, C+, etc

Thanks,

Brian
More...

My suggestion would be to get started with C#. It is easy to learn, and it will be easy for you to pick up other languages like Java or C++.

-segv
 
TradersStudio basic is modeled after a cross between Excel VBA and TradeStation EasyLanguage. We also have a source level debugger.
Since it's a trading platform it handles all of the charting and reports for you. It can also do portfiolo level testing and dynamic money management. All the reports can be saved in Excel format. It also has a OLE link to Excel. You can take a look at an overview of the product at


http://www.tradersstudio.com/Overview/tabid/68/Default.aspx
 
You must log in or register to reply here.
Back
Top