Rank: 1200 based on 71 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 16 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 5 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 7 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 0 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
  • 8
Updated File Comment by Comments Rating
02 May 2012 Paste a Matlab figure to Excel Paste a Matlab figure to Excel Author: Tal Shir Mora, Gilbert

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,
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 16 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 5 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 7 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 0 0

Contact us