ASP.NET - Expire Cookie When User Closes the Browser

7. April 2014 patrick (0)
I had a need for Site A to communicate a value to Site B on the same domain. I wanted to do this through a cookie and if the user closed Site A the cookie would expire.  This can be done by not setting a expiration date on the cookie. 
//------------------------------------------------
// Site A - Create a cookie with no expiration  
//------------------------------------------------
private void SetCoookieValue()
{
  HttpContext CTX = HttpContext.Current;
  var CookieValue = 'TEST';
  
  var CookieName = "MY_COOKIE";
  HttpCookie MyCookie = new HttpCookie(CookieName);
  if (CTX.Request.Cookies[CookieName] != null) MyCookie = CTX.Request.Cookies[CookieName];
    
  MyCookie.Value = CTX.Server.UrlEncode(CookieValue);
    
  //No Expiration - it will expire when the user closes the browser
  //MyCookie.Expires = DateTime.Now.AddHours(8);
  CTX.Response.Cookies.Add(MyCookie);
}
    
//------------------------------------------------    
// Site B - Attempt to read the cookie in, 
// it should be gone after closing Site A
//------------------------------------------------  
private string GetCookieValue(string cookieName, string itemName)
{
    var CookieName = "MY_COOKIE";
    var CookieValue = string.empty;

    HttpCookie myCookie = Request.Cookies[CookieName];
    if (myCookie == null) return "No cookie found";

    //If you added a key vs. the value in the cookie
    //CookieValue = myCookie[itemName].ToString();

    //Get the value of the cookie 
    CookieValue = Page.Server.UrlDecode(myCookie.Value.ToString());
}

Oracle - Extract Characters from String, Extract Date from Timestamp

7. April 2014 patrick (0)
Extract Characters from a string in Oracle using Regular Expression
function f_extract_string(in_position in number, iv_string in varchar2) return varchar2 is    
lv_retun_value varchar2(50);
begin             
        SELECT REGEXP_SUBSTR(iv_string,'[^,]+', 1,in_position)
        into lv_retun_value
        FROM DUAL;        
        
        return lv_retun_value;        
end f_extract_string;
Extract Date from Timestamp 
function f_timestamp_to_date(iv_timestamp in varchar2) return date is    
  ldte_date date;
begin    

  select to_date(trunc(to_timestamp(iv_timestamp)))
  into ldte_date
  from dual;
  
  return ldte_date;          
end f_timestamp_to_date;

Calculate Iron Condor MAX Gain in SQL Server

5. April 2014 patrick (0)
This is one of many functions used on MTR Investors Group to calculate option return values.
Create FUNCTION [dbo].[f_get_condor_gain_pct] 
(
 @SellStrike decimal(18,2),
 @BuyStrike decimal(18,2), 
 @PutSellPrice decimal(18,2),
 @PutBuyPrice decimal(18,2),
 @CallSellPrice decimal(18,2),
 @CallBuyPrice decimal(18,2)
)
RETURNS decimal(18,2)
AS
BEGIN
declare @GainAmount decimal(18,2);
declare @SpreadAmount decimal(18,2);

--The Option Sell > Buy - On Strikes the call side is flipped.
set @GainAmount = ((@PutSellPrice - @PutBuyPrice) + (@CallSellPrice - @CallBuyPrice)) * 100 ;
set @SpreadAmount = (@SellStrike - @BuyStrike) * 100;
if (@GainAmount = 0 or @SpreadAmount = 0) return 0;

return (@GainAmount / @SpreadAmount);

END