Rank: 1115 based on 59 downloads (last 30 days) and 7 files submitted
photo

Tal Shir

E-mail

Personal Profile:

Quant at Saf & Co

Professional Interests:

 

Watch this Author's files

 

Files Posted by Tal View all
  • 1 - 5 of
  • 7
Updated   File Tags Downloads
(last 30 days) 		Comments Rating
28 Apr 2009 Screenshot cellhist Plots a Histogram based on cell string array. Author: Tal Shir hist, histogram, cell, char, string 4 0
12 Mar 2009 Set columns in Excel to Auto Fit Set columns in Excel to Auto Fit Author: Tal Shir auto fit, column, format, autofit, excel 3 0
09 Mar 2009 Cornish-Fisher VaR Returns the Cornish-Fisher Expansion Valut at Risk. (Up to 4th moment) Author: Tal Shir value at risk, finance, risk, var 9 0
  • 1.0
1.0 | 1 rating
26 Feb 2009 Set conditional formating to Excel Set a conditional format in Excel to change negative numbers text color to red. Author: Tal Shir excel, format, conditional format, color 4 1
  • 5.0
5.0 | 1 rating
16 Feb 2009 eomdateAN Allow for negative and bigger than 12 month number with eomdate.m function Author: Tal Shir calander, date, end of month, finance, eomdate 2 0
Comments and Ratings by Tal
  • 1 - 1 of
  • 1
Updated File Comments Rating
02 Mar 2010 COMBINATOR -combinations AND permutations Returns 1 of 4 different samplings on the set 1:N, taken K at a time. Author: Matt Fig

Just what I needed. Thanks.
Comments and Ratings on Tal's Files View all
  • 1 - 5 of
  • 7
Updated File Comment by Comments Rating
25 Oct 2011 Paste a Matlab figure to Excel Paste a Matlab figure to Excel Author: Tal Shir Klomp, Matthijs
13 Jul 2011 Spider (radar) Chart Plots a radar (spider) chart (no need of circle function here) Author: Tal Shir KUBO, Takayuki
29 Jul 2010 Cornish-Fisher VaR Returns the Cornish-Fisher Expansion Valut at Risk. (Up to 4th moment) Author: Tal Shir Licona, Andres
04 Jun 2009 Set conditional formating to Excel Set a conditional format in Excel to change negative numbers text color to red. Author: Tal Shir Aviator

Great capability. Can you tell me what needs to be changed in this code if I want to set a condition that: when/if any content of for instance 'C1:C10' is less (or) greater than 'B1:B10' turn that cell in the range 'C1:C10', Red???

Thanks,
18 Dec 2008 Paste a Matlab figure to Excel Paste a Matlab figure to Excel Author: Tal Shir Silver, Richard

Thanks. Works for me.
Top Tags Applied by Tal
  • 1 - 5 of
  • 33
excel, finance, format, auto fit, autofit
Files Tagged by Tal View all
  • 1 - 5 of
  • 7
Updated   File Tags Downloads
(last 30 days) 		Comments Rating
28 Apr 2009 Screenshot cellhist Plots a Histogram based on cell string array. Author: Tal Shir hist, histogram, cell, char, string 4 0
12 Mar 2009 Set columns in Excel to Auto Fit Set columns in Excel to Auto Fit Author: Tal Shir auto fit, column, format, autofit, excel 3 0
09 Mar 2009 Cornish-Fisher VaR Returns the Cornish-Fisher Expansion Valut at Risk. (Up to 4th moment) Author: Tal Shir value at risk, finance, risk, var 9 0
  • 1.0
1.0 | 1 rating
26 Feb 2009 Set conditional formating to Excel Set a conditional format in Excel to change negative numbers text color to red. Author: Tal Shir excel, format, conditional format, color 4 1
  • 5.0
5.0 | 1 rating
16 Feb 2009 eomdateAN Allow for negative and bigger than 12 month number with eomdate.m function Author: Tal Shir calander, date, end of month, finance, eomdate 2 0

Contact us at files@mathworks.com