SERVING THE QUANTITATIVE FINANCE COMMUNITY

  • 1
  • 2
  • 3
  • 4
  • 5
  • 8
 
User avatar
BrightDay
Posts: 103
Joined: August 14th, 2003, 12:25 pm

Excel tricks

September 13th, 2012, 10:04 am

Are you very bored today?
 
User avatar
DevonFangs
Posts: 3004
Joined: November 9th, 2009, 1:49 pm

Excel tricks

September 13th, 2012, 11:56 am

I like it
 
User avatar
DevonFangs
Posts: 3004
Joined: November 9th, 2009, 1:49 pm

Excel tricks

September 13th, 2012, 1:07 pm

Actually, there's something I wanted to ask around: I know Excel is a good piece of software under several points of view, but am I the only one who f*cking hates the sh*t out of it.
 
User avatar
DevonFangs
Posts: 3004
Joined: November 9th, 2009, 1:49 pm

Excel tricks

September 13th, 2012, 1:50 pm

what do you mean withQuoteOriginally posted by: outrun however from an coding point of view there is no need for that whining.Actually, maybe what I don't like is having to write XL addins.
 
User avatar
Cuchulainn
Posts: 61487
Joined: July 16th, 2004, 7:38 am
Location: Amsterdam
Contact:

Excel tricks

September 13th, 2012, 2:47 pm

There are many roads leading to Rome..The C++ ATL and Shared add in wizards are becoming much easier to use, recently.Raw XL looks intimidating.And then there's C# and Excel-DNA. Latter is very user-friendly. DF,Excel addin demos
Last edited by Cuchulainn on September 12th, 2012, 10:00 pm, edited 1 time in total.
http://www.datasimfinancial.com
http://www.datasim.nl

Every Time We Teach a Child Something, We Keep Him from Inventing It Himself
Jean Piaget
 
User avatar
DevonFangs
Posts: 3004
Joined: November 9th, 2009, 1:49 pm

Excel tricks

September 13th, 2012, 4:04 pm

QuoteOriginally posted by: CuchulainnThere are many roads leading to Rome..The C++ ATL and Shared add in wizards are becoming much easier to use, recently.Raw XL looks intimidating.And then there's C# and Excel-DNA. Latter is very user-friendly. DF,Excel addin demosExcel DNA is very human-friendly indeed. However, one often has to use some proprietary XL interface...
 
User avatar
Cuchulainn
Posts: 61487
Joined: July 16th, 2004, 7:38 am
Location: Amsterdam
Contact:

Excel tricks

September 13th, 2012, 6:06 pm

If you are feeling ambitious you can build an addin with COM and IDTExtendibility2 a mano, brick by brick. Having done that, let ATL do it.
Last edited by Cuchulainn on September 12th, 2012, 10:00 pm, edited 1 time in total.
http://www.datasimfinancial.com
http://www.datasim.nl

Every Time We Teach a Child Something, We Keep Him from Inventing It Himself
Jean Piaget
 
User avatar
tagoma
Posts: 18351
Joined: February 21st, 2010, 12:58 pm

Excel tricks

September 13th, 2012, 7:55 pm

QuoteOriginally posted by: outrunthe thing I really hate is when you want to move a block of cells with a some merged cells in it to a different empty section. It always warns "Some cells will be unmerged .. bla bla", the same here! that makes me groan each time. eh .. "bark" more exactly
 
User avatar
tagoma
Posts: 18351
Joined: February 21st, 2010, 12:58 pm

Excel tricks

September 14th, 2012, 2:32 pm

QuoteOriginally posted by: outrunI have a spreadsheet with the definition of a tree.Each node in the tree is a row in a table with these columns:* node_id* parent_node_id* distance_to_root* descriptionHow can I get a visual representation of the tree, prefereable like a directory structure, and prefreable without VBA, -eg. using a pivot table-? EDIT:Solved it at the Oracle backend with the START WITH and CONNECT BY hierachical SQL language extension. Nice of Oracle to provide that type of query functionality!did you write a script based on the hierachical SQL language extension to build a tree outside of Excel ?
ABOUT WILMOTT

PW by JB

Wilmott.com has been "Serving the Quantitative Finance Community" since 2001. Continued...


Twitter LinkedIn Instagram

JOBS BOARD

JOBS BOARD

Looking for a quant job, risk, algo trading,...? Browse jobs here...


GZIP: On