Excel / learning and resources for traders

MrMiyagi

MrMiyagi

Active member
Messages
170
Likes
44
Can anyone point me to any sites / books that would cater solely for traders learning excel. I have never really ever had to use excel, so the discussion of Macros and the like is over my head (for now). I just need a few specific things.

Things I want to be able to do:

1. retrieve only specific data fields from web query tables
2. create spreadsheets with data that refreshes daily, and have the old data store somewhere. (question posted often on forums, but never answered)
3. charts overlaid on other charts

Any help greatly appreciated.
 
Or if anyone knows of an excel plugin that'll retrieve the data I want (index option data, and closing prices) and store it in a database, so that I can chart all sorts of weird stuff over time?
Cheap or free preferred.
 
Cheers Swandro, those are definitly helpful, I'm clearly gonna have to get my VBA on... Was thinking of downloading "Build an Automated Spread Trading System"
It looks like it'll teach me a load of things relating to what I'm on about.. Anyone any experience with it, is it balls? or good? anyone know of a good torrent link to it?
cheers
 
Excel Macro

"to move web query values to another location for long term storage and use"

Can anyone offer any insight into how I do this? For example I want to store daily data for FTSE options. Using web queries from Yahoo, my data refreshes, but overwrites the early stuff. On refresh I want the old stuff to go somewhere else and progressively stack up so that I can marvel at it as a graph.

Again, any help greatly appreciated.
 
Mate, ask yourself do you want to be a programmer or a trader. Excel + VBA + cheap data = Massive management problem - before you acheive anything. Sure it can be done, but its a hard, complex, difficult option - especially if you have zero experience.

But somethink like Amibroker [say 200US], and a good data EOD data feed for your chosen market - and your away.

There is a steep Amibroker learning curve, but its nothing compared to what your contemplating.
 
charles_au said:
Mate, ask yourself do you want to be a programmer or a trader. Excel + VBA + cheap data = Massive management problem - before you acheive anything. Sure it can be done, but its a hard, complex, difficult option - especially if you have zero experience.

But somethink like Amibroker [say 200US], and a good data EOD data feed for your chosen market - and your away.

There is a steep Amibroker learning curve, but its nothing compared to what your contemplating.
Click to expand...

Fair points.. I'm trading away quite successfully but simply wish to play around, on the cheap with some ideas I have. you're right, I certainly don't wish to head down the programmer road if I can help it ... was lucky to stumble upon a site called gummy-stuff.org with loads of great excel templates and macros that can easily be tweaked to what I need exactly.. cheers
 
You must log in or register to reply here.

Similar threads

T
** Import Live Forex data into Excel **
Replies
2
Views
5K
hirsi1
H
N
MetaStock Formula ---> Excel Formula
Replies
5
Views
7K
NoumanZafar
N
9
Excel - get external data, delimiter prob?
Replies
9
Views
6K
900xs
9
T
Excel Spreadsheet of Professional Traders
Replies
0
Views
2K
TraderBoy92
T
S
Tidying up tick data with excel; range bars
Replies
2
Views
4K
tickmaster
T
Top