G'day CanOz,
G'day damok,
File, Edit, View, Insert. Format, Tools, Data, Window, Help then Sanford Pro.
The code must have the exchange attached i.e CBA.ASX NAB.ASX
You can select from a box which info you need such as volume, last price, 52 weeks low, bid, ask.......etc etc then click on the icon & the info appears.
If you do a lot of spreadsheets like I do, then it saves hours of researching individual items. You can setup your own customised watchlist with the net profit/loss ticking over live per each individual stock after interest & brokerage with a bottom line net result.....it does keep you aware of your position at all times.
On my CFD spreadsheet I have set my stoploss as an amount after interest & comm, rather than the stock share price rate. When the amount hits the stoploss it automatically shows "TRUE"
Keep us informed of your progress.
The dividend trading thread is completely separate to my CFD trades. I have been anti CFDs for about the last 3/4 years, but since its popularity, I decided to test it out......this time with a different slant, using $5000 rather than testing on paper.Well done mate! I enjoy reading your posts in the dividend thread. I had no idea you started with only 5k.
G'day damok,
I believe you can liven your spreadsheets using yahoo finance for free, however, I use Sanford as one of my brokers & they have the facility. So when you open a spreadsheet, along the top line you have the normal:I'm also a avid fan of spreadsheets to do a lot of work for me. I'm just wondering how the 'DDE' links work. Would love to implement something like that.
File, Edit, View, Insert. Format, Tools, Data, Window, Help then Sanford Pro.
The code must have the exchange attached i.e CBA.ASX NAB.ASX
You can select from a box which info you need such as volume, last price, 52 weeks low, bid, ask.......etc etc then click on the icon & the info appears.
If you do a lot of spreadsheets like I do, then it saves hours of researching individual items. You can setup your own customised watchlist with the net profit/loss ticking over live per each individual stock after interest & brokerage with a bottom line net result.....it does keep you aware of your position at all times.
Conventional marginlending is much more relaxed than CFDs as there is more room to move with buffers etc & not so highly geared, where CFDs can be very cut throat to the unwary, so don't blink too often.I plan to trade in normal ASX200 stocks for about two years until I feel nice and confident, then apply the same system to CFD's
On my CFD spreadsheet I have set my stoploss as an amount after interest & comm, rather than the stock share price rate. When the amount hits the stoploss it automatically shows "TRUE"
Keep us informed of your progress.