Sunday, April 28, 2013

Quant Finance startups Strategy

Some start-ups ideas in Quant Finance that you would like to look are:

MATLAB
http://www.goddardconsulting.ca/
http://www.reval.com/pages/default.aspx
http://urbanschool.in/outsourcing.html (MATLAB course outsourcing)
http://www.mathtutordvd.com/

Mumbai / Risk
http://www.quantumphinance.com/
http://www.bbanalytics.biz/products-services/risk-analytics/
http://www.discern-risk.com/

About FinStream Financial Advisers

Edu
http://www.iiqf.org/volatility-trading.html
www.iiqf.org/courses/post-graduate-program-algorithmic-trading.html
http://www.iqfindia.com/corporate-training/quantitative-finance.html
http://www.quantinsti.com/algotradingcourses.html
www.quantmaster.in
http://knowledgevarsity.com/

LI
http://www.capmetrics.com/quantitative_analysis.html
Way2Wealth Illuminati
Future first also trading
http://www.esteeadvisors.com/
Mu Sigma

Job Sites:
http://www.globeop.com/

From Coverage:
http://www.salusalpha-it.com/SAITPL/Career.aspx?#Culture
http://www.tresvista.com/index.php?option=com_content&view=article&id=114&Itemid=98
http://crisil.com/global-offshoring/quantitative-research.html


Coaching
http://financetrain.com/certification-guides/frm-exam/frm-exam-part-2/
http://www.bionicturtle.com


Quant Trading
https://quadeyesecurities.com/careers.html

Friday, April 26, 2013

VBA Coding Style

http://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/bf247ff3-a496-400c-9bbe-d2477c6d33f6/

http://en.wikibooks.org/wiki/Programming:Visual_Basic_Classic/Coding_Standards

http://www.ee.columbia.edu/~marios/matlab/MatlabStyle1p5.pdf

http://www.exceluser.com/explore/vbastds.htm


Following consistent type and scope for the variables
Using inline comments where required

http://www.xoc.net/standards/rvbanc.asp

http://www.fincad.com/pdfs/vba_coding.pdf

good 2 page summary

http://en.wikipedia.org/wiki/Programming_style

http://en.wikipedia.org/wiki/Coding_conventions

Nothing on youtube

http://msdn.microsoft.com/en-us/library/aa240822(v=vs.60).aspx

Talks about division: Naming convention, commenting and indenting.

For other rules please refer the coding standard reference (Primary):
(http://en.wikibooks.org/wiki/Programming:Visual_Basic_Classic/Coding_Standards) is a reference for VBA standards

VBA Coding Standards for reference only (Secondary):
1. http://www.exceluser.com/explore/vbastds.htm
2. http://www.xoc.net/standards/rvbanc.asp
3. http://www.fincad.com/pdfs/vba_coding.pdf
4. http://en.wikipedia.org/wiki/Programming_style
5. http://en.wikipedia.org/wiki/Coding_conventions
6. http://msdn.microsoft.com/en-us/library/aa240822(v=vs.60).aspx


Join our VBA for financial engineering course (http://www.wiziq.com/course/19620-vba-for-financial-engineering-and-modeling) & get 15% discount. Ask for discount code, email - info@qcfinance.in.

Tuesday, April 16, 2013

Sneak Peek of Wiziq Courses

Bloomberg Assessment Test (BAT) Exam Prep Course:








MATLAB For Financial Engineering:








My Courses:





Join our VBA for financial engineering course (http://www.wiziq.com/course/19620-vba-for-financial-engineering-and-modeling) & get 15% discount. Ask for discount code, email - info@qcfinance.in.

Join our Bloomberg Aptitude Test Prep course (http://www.wiziq.com/course/7526-bloomberg-assessment-test-bat-exam-prep) & get 15% discount. Ask for discount code, email - info@qcfinance.in

Join our MATLAB for financial engineering course (http://www.wiziq.com/course/7225-matlab-for-financial-engineering) & get 15% discount. Ask for discount code, email - info@qcfinance.in

Monday, April 8, 2013

VBA Important Programs Class 1-5 Proposal

Course Link on Wiziq - http://www.wiziq.com/course/19620-vba-for-financial-engineering-and-modeling

Qutting a Loop after taking users permission

VBA programs outline:



Class 2:
Copying data validation using range
for and while loop in the same program
param array
exporting file contents into a new file
creating dynamic data tables
clearing values of range selectively based on logic
Using capital IQ, factset data bases


Class 3:
Concepts of Financial Engineering
10k
Adjustment to data


Class 4:
Intro to Monte Carlo in Excel
Cho decomposition


Class 5:
Revision Project open session / Pulling data from yahoo case study (Ref: )

http://www.youtube.com/watch?v=iSlBE3CWg5Q


Areas that we will talk on:
On erro goto next should be avoided use goto in case you need to. on error goto 0 removes the effect for Future of on erro resume next
Named ranges all cases that could happen, seaching, copying, string, address not found, etc.Resetting charts Where required, ignore charts that is not there.
Correlated residuals to be used on the future values, why residual smatter in monte carlo? how to get these Correlated residuals in Monte Carlo...
Interview questions in VBA
#na from local us #na from a link?
Factset codes, sources, and adjustments
Searching #NA picked from toher values, power of NA()
Updates in term of both pages e and i
Example of array formula f ctr shift enter (matrix multiplication)
VBA notes on linking with power point
Power point advanced charting, flow charts,etc
OFFset function (example): http://support.microsoft.com/kb/324991



Some codes that we will discuss:

------------------------------------------

Option Explicit
Sub SetFormat()
    Dim ws As Worksheet
    For Each ws In ActiveWorkbook.Worksheets
    With ws
              ws.Cells.Font.Name = "Arial"
        End With
    Next ws
    End Sub

----------------


m = Range("range").Count
For j = 0 To m
      If Range("range")(j).Value = "O" Then
      Range("range2")(j, 0).EntireRow.Clear
       Range("range")(j).Value = "O"
       End If
   Next j


------------------------------------

Private Sub Reset()
   Dim objCht As ChartObject
   For Each objCht In ActiveSheet.ChartObjects
   With objCht.Chart
        With .Axes(xlValue)
       .MinimumScaleIsAuto = True
      .MaximumScaleIsAuto = True
  End With
      End With
   Next objCht
End Sub


-------------------------------------------------

Sub Highlight_Cells_With_Text_or_Formulas()

'Highlights all cells with text or formulas on the active sheet
'Will remove color from cells without formulas or text

Dim r As Range

With ActiveSheet.UsedRange
    .Interior.ColorIndex = xlNone
    For Each r In .Cells
        If r.Value <> "" Then r.Interior.ColorIndex = 3
        Next
End With

End Sub

-----------------------------------


Code for playing with data validation

Private Sub Worksheet_Activate2()
    Dim rng As Range, cell As Range
    With Range("BL38:BL38")
        Set rng = Intersect(.SpecialCells(xlCellTypeAllValidation), .SpecialCells(xlCellTypeBlanks))
    End With
    If Not rng Is Nothing Then
        Application.EnableEvents = False
        For Each cell In rng
            cell.Value = Sheets("Assumptions").Range("B7:B9")(1).Value
        Next cell
        Application.EnableEvents = True
    End If
End Sub


--------------------------------


Private Sub Set_Default_values() 
  Dim rng As Range
  
    Set rng = Range("Default_Values").SpecialCells(xlCellTypeAllValidation)
  
   Range("Range_name").Value = Range("Default_Values")(1).Value
    
End Sub


------------------------------------------





Sub AddNewWBKs()
Dim myWB As Workbook, newWB As Workbook
Dim myWS As Worksheet
Set myWB = ThisWorkbook
Application.ScreenUpdating = False
Set myWS = myWB.Sheets("Assumptions")
Set newWB = Workbooks.Add
myWS.Range("Coverage_Data").Copy
Range("A1").PasteSpecial xlPasteValues
 Range("A1").PasteSpecial xlPasteFormats
Application.CutCopyMode = False
ActiveSheet.UsedRange.EntireColumn.AutoFit
Application.DisplayAlerts = False
 newWB.SaveAs Filename:="C:\Documents and Settings\shivgan\My Documents\Exported Spreadsheet.xls"
Application.DisplayAlerts = True
newWB.Close
Application.ScreenUpdating = True
End Sub


--------------------------------------------------



Public Sub Count()
  Dim count_columns_selection, i, iReply As Integer
  Dim range_name_string As String
   
  For i = 1 To Range("Range_X").Rows.Count

Code for anything that may cause trouble

    On Error GoTo Error_control
    ContinueLoop:
  Next i

Do While i < Range("Range_X").Rows.Count
Error_control:
    
   iReply = MsgBox(Prompt:="Foudn Error?", _
            Buttons:=vbYesNoCancel, Title:="BLANK???")
   On Error GoTo -1
    If iReply = vbYes Then
     GoTo ContinueLoop
    ElseIf iReply = vbNo Then
      Exit Sub
    Else
       Exit Sub
    End If
    
 Loop
 
  
End Sub


-------------------------------------



Range("G6").GoalSeek Goal:=0, ChangingCell:=Range("G7")


End Sub



Sub reset()



Range("G7").Value = 0


End Sub

-------------------------------------------------


Join our VBA for financial engineering course (http://www.wiziq.com/course/19620-vba-for-financial-engineering-and-modeling) & get 15% discount. Ask for discount code, email - info@qcfinance.in.



Thursday, April 4, 2013

Bloomberg Terminal for BAT test Prep Online Class

Bloomberg Terminal for BAT test Prep Online Class

Bloomberg Terminal is a computer system that allows investors to access the Bloomberg data service. It provides real-time financial data, news feeds, messages along with the felicitation of trades.

Bloomberg charges around $24,000 a year for a single terminal subscription.

Bloomberg is currently the market leader in Providing financial data service with 315,000 subscribers.

Institutional investors are the typical customers of Bloomberg Terminal.

Bloomberg Terminal is compatible with the Excel program, thus becomes an important tool for those who work in financial sector.

Bloomberg also offers access to its users of the services from online & through mobile devices which is termed as "Bloomberg Anywhere" service.

Bloomberg Terminal Keyboard:

(Source: Wikipedia)

Function Keys on Bloomberg Terminal's Keyboard are substituted with market sector keys. Some of them are shown here:


  1. GOVT - government securities (US treasury and non-US)
  2. CORP - corporate debt
  3. MTGE - mortgage securities
  4. M-Mkt - money market
  5. MUNI - municipal debt
  6. PFD - preferred shares
  7. EQUITY - equity shares
  8. COMDTY - commodity markets
  9. INDEX - indexes
  10. CURNCY - currency markets

In our Wiziq Course on BAT, we will discuss various capabilities of Bloomberg Terminal. Some of them are as follows:
  • News: Bloomberg Terminal offers real-time news updates from varied sources. One has to just type - "NEWS" in the search bar for accessing the most recent financial & non-financial news headlines from around the world.
News Feed Interface (Source: Investopedia)


  • Equities: Bloomberg allows following facilities:
  1. To Search by name, exchange, country, etc. of the publicly traded equity shares.
  2. Equity menu allows users to view historical pricing on a stock.
  3. Compare equities side by side.
  4. Allowing screeners to screen for stocks using a multitude of metrics.


Along with many more functions........ 

Equity Menu (Source: Investopedia)


  • Fixed Income: Bloomberg allows users to search for real-time data on fixed income securities. This includes corporate debt, municipal bonds & government bonds.
  • Derivatives: Users can find real-time values for securities. Bloomberg also allows users to value hard-to-price derivatives.
Derivatives, using Historical Volatility (Source:Investopedia)

          Also, it offers Swap Manger Tool which is a highly customized Swap pricing utility which allows users to input the parameters of a swap agreement & come up with an estimate for the value of that swap.

Swap Manager Tool (Source: Investopedia)


  • Foreign Exchange: Users can view real-time rates of dozens of currencies.

These are just some of the features of Bloomberg Terminal that are discussed here. More such feature are discussed on the Bloomberg Assessment Test (BAT) prep course on Wiziq.

Join our Bloomberg Aptitude Test Prep course (http://www.wiziq.com/course/7526-bloomberg-assessment-test-bat-exam-prep) & get 15% discount. Ask for discount code, e-mail:- info@qcfinance.in.


Methodology: Go to link and answer the questions below each link.

Links to check terminal images used in the classes:

http://i.investopedia.com/inv/articles/site/Bloombergadvanced1.gif

http://i.investopedia.com/inv/articles/site/Bloombergadvanced7.gif

http://bizlib247.files.wordpress.com/2012/03/commodities.gif

http://www.bu.edu/library/files/2011/05/Apple-Bloomberg-Company-Ratio1.gif

http://www.fullermoney.com/content/2011-11-03/ABD_NAV.gif

http://i.investopedia.com/inv/articles/site/Bloombergadvanced18.gif

http://www.bloomberg.com/professional/files/2012/08/Bloomberg-Charts.jpg

http://people.stern.nyu.edu/adamodar/New_Home_Page/Bloombergdescr_files/image079.png

http://www2.le.ac.uk/departments/economics/images/bloomberg/CGB0347a_edited-1.jpg

http://i.investopedia.com/inv/articles/site/Bloombergadvanced15.gif

http://i.investopedia.com/inv/articles/site/BloomBond3.gif

http://deadlyclear.files.wordpress.com/2013/02/bt-loan-located.jpg

http://2.bp.blogspot.com/_UltIXMCtoCY/TO-UJjaRGzI/AAAAAAAACr0/czCUHZL2jOU/s1600/sg2010111735569.gif.



My Course:

One on One Customized Training:
qcfinance.in believes in personalized touch so that our clients are completely satisfied with our service. In this regard, we offer One on One Customized Training to our clients.
These Trainings are provided on request by our clients & are customized according to their individual needs.
The course structure & timings for these training are highly flexible, classes are scheduled as per the convenience of our clients.

Contact Us for More details: info@qcfinance.in.

Tuesday, April 2, 2013

Chart of The Day - Bloomberg Assessment Test/Bloomberg Aptitude Test Prep Course

Chart of The Day provided by Bloomberg plays a very important role in the Bloomberg Assessment Test (BAT), as it is conducted by the same institute.

Bloomberg Assessment Test consists of 8 sections, out of which there is a section called "Chart & Graph Analysis" forming 12% of weightage in the actual exam. This section assesses a test taker's ability to interpret & use information found in charts & graphs. It requires complete understanding of any chart or a graph provided in the question.

Thus, given it's high weightage, we have made Chart of the Day (COD) an important part of our entire course on Bloomberg Assessment Test.

One of the PowerPoint Presentations from the course, is shown below:

Uploaded by Shivgan on WizIQ Tutorials

Join our Bloomberg Aptitude Test Prep course (http://www.wiziq.com/course/7526-bloomberg-assessment-test-bat-exam-prep) & get 15% discount. Ask for discount code, email - info@qcfinance.in 


Following Charts are covered in the slide:

http://www.bloomberg.com/news/2012-10-19/mcdonald-s-post-black-monday-advance-leads-dow-chart-of-the-day.html

http://www.bloomberg.com/news/2013-01-03/aging-americans-may-weigh-on-entitlement-cuts-chart-of-the-day.html

http://www.bloomberg.com/news/2013-01-20/china-growth-sets-vancouver-home-prices-chart-of-the-day.html

http://www.bloomberg.com/news/2013-01-28/bitcoin-s-gains-may-fuel-central-bank-concerns-chart-of-the-day.html

http://www.bloomberg.com/news/2013-01-30/beijing-air-akin-to-living-in-smoking-lounge-chart-of-the-day.html

http://www.bloomberg.com/news/2012-04-10/apple-to-top-spain-greece-portugal-chart-of-the-day.html

http://www.bloomberg.com/news/2013-03-07/apple-may-be-unable-to-meet-its-sales-forecast-chart-of-the-day.html

http://www.bloomberg.com/news/2013-03-21/commodity-catch-up-with-stocks-seen-as-elusive-chart-of-the-day.html

http://www.bloomberg.com/news/2012-11-26/u-k-energy-policy-weighs-on-green-investment-chart-of-the-day.html

http://www.bloomberg.com/news/2013-02-19/brics-demand-for-u-s-exports-set-to-beat-eu-chart-of-the-day.html


For More Details Contact - Arpit (arpit@qcfinance.in)