• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Copy and Paste

W

webmal

Banned
Usually I would copy a set of stock codes from Etrade (online) and then paste it to Excel for my records. The data would appear in columns e.g.:

ABC
DEF
GHJ

Then I need to copy the codes to my trading software to examine the charts further. The format my software use is ABC,DEF,GHJ to open those charts. Sometimes I have hundreds of codes. To avoid manual input, what's the easiest way to format the codes?

Thank you.
 
I don't know if there's a simpler way to do it, (there's gotta be)
So, I'd just write a quick macro that would write the string, insert a comma, move down a box, write the next string,...
Then, a simple loop, with a test for the end to exit the loop. Either have it check for a blank entry to end, or maybe manually enter an xxx and just compare it that way.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top