Visit our COVID-19 site for latest information regarding how we can support you. For up to date information about the pandemic visit www.sacoronavirus.co.za.

bs-regular
bs-extra-light
bs-light
bs-light
bs-cond-light-webfont
bs-medium
bs-bold
bs-black

Community


Share knowledge. Ask questions. Find answers.

Online Share Trading

Engage and learn about markets and trading online

Watchlist export ?

Reply
Blik
Super Contributor
Possibly a dumb question: Is there a way to export a watchlist from this site into an MS Excel ready format?
0 Kudos
4 REPLIES 4
JohnnyCash
Super Contributor
Try highlighting the watchlist and then Copy/Paste into sheet. Will have to delete all links it copied accross by Copy /Paste Values once in excel.
0 Kudos
Blik
Super Contributor
it puts it all into a single cell which makes it hard to run the "text to columns" function.
0 Kudos
Blik
Super Contributor
Ok - Tried again - Thanks Johnny - it seems to work. Messy though - I wonder if Simon could suggest an export function.
0 Kudos
Surf_Rat
Super Contributor
Hey surfrat does this every month so here is how you do it step 1 highlight the watch list copy go to excel and select a single cell and go paste special as a text 2. then go to data and click on text to columns click on cirlce to delimitedthen tick space and you are surfing china with a couple of small moves you line up the columns and you can add % alles cheers hope this helps you make D Money
0 Kudos