13F-HR filed by MACROVIEW INVESTMENT MANAGEMENT LLC
MACROVIEW INVESTMENT MANAGEMENT LLC filed this 13F-HR for the quarter ended 2017-06-30, filed 2017-08-11, with 190 holding rows worth $18,562,000.
- Accession
- 0001214659-17-004994
- Filer
- CIK 1551727
- Filed
- 2017-08-11
- Accepted by EDGAR
- acceptance time not in the bulk data set
- Ingested
- Source
- SEC quarterly data set
13F report for Q2 2017
A holdings report, 190 entries on the cover page, a total value of $18,562,000 stated on the cover page (in dollars after the unit check, H1), rows summing to $18,562,000 with VALUE read as thousands by filing date, 13F file number 028-14993. The quarter's positions are built on this report. The resolved quarter.
The information table after summing rows of one CUSIP and put or call (H4), with the CUSIP and issuer name as filed. Values in dollars after the unit check (method).
| Issuer as filed | CUSIP | Class | Amount | Value | Value read as | Type |
|---|---|---|---|---|---|---|
| SPY | 78462F103 | SHS | 14,145 | $3,420,000 | thousands by filing date | |
| SPDR GOLD TR | 78463V107 | GOLD SHS | 25,944 | $3,062,000 | thousands by filing date | |
| PROSHARES TR | 74348A467 | S&P 500 DV ARIST | 39,532 | $2,284,000 | thousands by filing date | |
| GOLDMAN SACHS ETF TR | 381430503 | ACTIVEBETA US LG | 34,529 | $1,661,000 | thousands by filing date | |
| SSGA ACTIVE ETF TR | 78467V848 | ST STR TOTAL ETF | 18,692 | $920,000 | thousands by filing date | |
| PIMCO ETF TR | 72201R833 | ENHAN SHRT MA AC | 8,895 | $905,000 | thousands by filing date | |
| PROSHARES TR II | 74347W882 | ULTRASHRT EURO | 30,038 | $694,000 | thousands by filing date | |
| ISHARES TR CORE S&P 500 ETF | 464287200 | SHS | 2,505 | $610,000 | thousands by filing date | |
| BLACKROCK MUNIVEST FUND | 09253R105 | COM | 34,291 | $332,000 | thousands by filing date | |
| UNITED STATES COMMODITY INDE | 911717106 | Common Stock | 5,908 | $227,000 | thousands by filing date | |
| NUVEEN MUN CR INCOME FD | 67070X101 | COM SH BEN INT | 14,801 | $221,000 | thousands by filing date | |
| INVESCO VALUE MUNICIPAL INCOME | 46132P108 | COM | 12,351 | $187,000 | thousands by filing date | |
| DREYFUS STRATEGIC MUNS INC | 261932107 | COM | 18,838 | $168,000 | thousands by filing date | |
| PUTNAM MANAGED MUN INCOME TR | 746823103 | COM | 21,122 | $159,000 | thousands by filing date | |
| iShares Core US Aggregate Bond ETF | 464287226 | SHS | 1,402 | $154,000 | thousands by filing date | |
| Vanguard Intermediate-Term Corporate Bond ETF | 92206C870 | SHS | 1,554 | $136,000 | thousands by filing date | |
| WESTERN ASSET MANAGED MUNS F | 95766M105 | COM | 8,674 | $120,000 | thousands by filing date | |
| OMEGA HEALTHCARE INVS INC COM | 681936100 | REIT | 3,539 | $117,000 | thousands by filing date | |
| CROWN CASTLE INC COM | 22822V101 | REIT | 1,129 | $113,000 | thousands by filing date | |
| ISHARES TR | 464287440 | 7-10 YR TRSY BD | 919 | $98,000 | thousands by filing date | |
| MEDICAL PROPERTIES TRUST INC COM | 58463J304 | REIT | 7,187 | $92,000 | thousands by filing date | |
| BulletShares 2025 Corporate | 18383M191 | COM | 4,202 | $87,000 | thousands by filing date | |
| CLAYMORE EXCHANGE TRD FD TR | 18383M266 | CLAYMORE EXCHANGE TRD FD TR | 4,056 | $86,000 | thousands by filing date | |
| EATON VANCE MUNICIPAL BOND FUN | 27827X101 | COM | 6,675 | $85,000 | thousands by filing date | |
| Health Care Select Sector SPDR Fund | 81369Y209 | SHS | 1,015 | $80,000 | thousands by filing date | |
| SCHWAB STRATEGIC TR | 808524839 | US AGGREGATE B | 1,535 | $80,000 | thousands by filing date | |
| Vaneck Long Muni ETF | 92189F536 | ETF | 4,025 | $80,000 | thousands by filing date | |
| ATI INC COM | 01741R102 | Stock | 4,660 | $79,000 | thousands by filing date | |
| United Parcel Service,Inc. Class B | 911312106 | COM | 700 | $77,000 | thousands by filing date | |
| DWS Mun Income Tr | 25160C106 | COM | 5,500 | $74,000 | thousands by filing date | |
| ISHARES TR | 464287465 | MSCI EAFE ETF | 1,116 | $73,000 | thousands by filing date | |
| BLACKROCK MUNIYIELD QUALITY FU | 09254F100 | COM | 4,625 | $71,000 | thousands by filing date | |
| SPROTT PHYSICAL GOLD SILVER | 153501101 | COM | 5,626 | $69,000 | thousands by filing date | |
| Technology Select Sector SPDR Fund | 81369Y803 | SHS | 1,099 | $60,000 | thousands by filing date | |
| POWERSHARES | 73936Q769 | EXCHANGE TRADED | 2,525 | $58,000 | thousands by filing date | |
| Philip Morris International Inc. | 718172109 | COM | 450 | $53,000 | thousands by filing date | |
| TORTOISE ENERGY INFRA CORP | 89147L100 | COM | 1,500 | $46,000 | thousands by filing date | |
| PROSHARES TR | 74348A210 | SHRT RUSSELL2000 | 994 | $46,000 | thousands by filing date | |
| VANECK PHARMACEUTICAL ETF | 92189F692 | ETF | 758 | $45,000 | thousands by filing date | |
| Vanguard Intermediate-Term Bond ETF | 921937819 | SHS | 521 | $44,000 | thousands by filing date | |
| AT&T Inc | 00206R102 | COM | 1,105 | $42,000 | thousands by filing date | |
| Apple Inc | 037833100 | COM | 280 | $40,000 | thousands by filing date | |
| iShares Russell Midcap ETF | 464287499 | SHS | 197 | $38,000 | thousands by filing date | |
| iShares Silver Trust | 46428Q109 | COM | 2,375 | $37,000 | thousands by filing date | |
| VANGUARD HEALTH CARE ETF | 92204A504 | ETF | 246 | $36,000 | thousands by filing date | |
| Vanguard Consumer Discretionary ETF | 92204A108 | SHS | 233 | $33,000 | thousands by filing date | |
| iShares iBoxx Inv Grade Corporate Bond ETF | 464287242 | SHS | 262 | $32,000 | thousands by filing date | |
| Proshares Short S&P | 74347B425 | COM | 914 | $31,000 | thousands by filing date | |
| Altria Group Inc | 02209S103 | COM | 400 | $30,000 | thousands by filing date | |
| iShares MBS ETF | 464288588 | SHS | 269 | $29,000 | thousands by filing date | |
| Vanguard FTSE Europe ETF | 922042874 | SHS | 535 | $29,000 | thousands by filing date | |
| SELECT SECTOR SPDR TR | 81369Y704 | INDL | 425 | $29,000 | thousands by filing date | |
| NUVEEN QUALITY MUNCP INCOME | 67066V101 | COM | 2,057 | $29,000 | thousands by filing date | |
| META PLATFORMS INC CL A | 30303M102 | COM | 183 | $28,000 | thousands by filing date | |
| PROSHARES SHORT | 74347R396 | PSHS SH MSCI EMR | 1,322 | $28,000 | thousands by filing date | |
| Lockheed Martin Corporation | 539830109 | COM | 96 | $27,000 | thousands by filing date | |
| ETFS Gold Trust | 26922Y105 | ETF | 225 | $27,000 | thousands by filing date | |
| STATE STR SPDR DOW JONES IND | 78467X109 | UT SER 1 | 120 | $26,000 | thousands by filing date | |
| GENERAL DYNAMICS CORP COM | 369550108 | Stock | 125 | $25,000 | thousands by filing date | |
| AbbVie,Inc. | 00287Y109 | COM | 313 | $23,000 | thousands by filing date | |
| EXXON MOBIL CORP | 30231G102 | COM | 280 | $23,000 | thousands by filing date | |
| iShares Gold Trust | 464285105 | ISHARES | 1,965 | $23,000 | thousands by filing date | |
| PROSHARES TR | 74348A525 | ULSHOIL&GASNEW13 | 468 | $23,000 | thousands by filing date | |
| VGT | 92204A702 | SHS | 158 | $22,000 | thousands by filing date | |
| ISHARES TR | 464288638 | ISHS 5-10YR INVT | 204 | $22,000 | thousands by filing date | |
| RAYTHEON CO | 755111507 | COM NEW | 139 | $22,000 | thousands by filing date | |
| VTI | 922908769 | COM | 169 | $21,000 | thousands by filing date | |
| SELECT SECTOR SPDR TR | 81369Y308 | STATE STREET CON | 380 | $21,000 | thousands by filing date | |
| COLGATE PALMOLIVE CO COM | 194162103 | Stock | 281 | $21,000 | thousands by filing date | |
| Vanguard Growth | 922908736 | COM | 130 | $17,000 | thousands by filing date | |
| iShares S&P 500 Value ETF | 464287408 | SHS | 160 | $17,000 | thousands by filing date | |
| Abbott Laboratories | 002824100 | COM | 320 | $16,000 | thousands by filing date | |
| Guggenheim S&P 500 Equal Weighted ETf | 78355W106 | Equity | 168 | $16,000 | thousands by filing date | |
| Vanguard Short-Term Bond ETF | 921937827 | SHS | 190 | $15,000 | thousands by filing date | |
| SPDR SERIES TRUST | 78464A516 | ST INTL BBG ETF | 550 | $15,000 | thousands by filing date | |
| Energy Select Sector SPDR Fund | 81369Y506 | SHS | 217 | $14,000 | thousands by filing date | |
| iShares Core MSCI Emerging Markets ETF | 46434G103 | SHS | 277 | $14,000 | thousands by filing date | |
| INVESCO LTD SHS | G491BT108 | Stock | 385 | $14,000 | thousands by filing date | |
| BLACKROCK INC CL A COM | 09247X101 | COM | 33 | $14,000 | thousands by filing date | |
| PIMCO ETF TR | 72201R783 | 0-5 HIGH YIELD | 140 | $14,000 | thousands by filing date | |
| UNITED STS 12 MONTH OIL FD L | 91288V103 | UNIT BEN INT | 820 | $14,000 | thousands by filing date | |
| Accenture Plc Class A | G1151C101 | COM | 104 | $13,000 | thousands by filing date | |
| Medtronic Plc | G5960L103 | COM | 150 | $13,000 | thousands by filing date | |
| Vanguard Value ETF | 922908744 | SHS | 134 | $13,000 | thousands by filing date | |
| ROCKWELL AUTOMATION INC COM | 773903109 | Stock | 80 | $13,000 | thousands by filing date | |
| UNITED TECHNOLOGIES CORP | 913017109 | COM | 104 | $13,000 | thousands by filing date | |
| CVS Health Corporation | 126650100 | COM | 155 | $12,000 | thousands by filing date | |
| Home Depot, Inc | 437076102 | COM | 80 | $12,000 | thousands by filing date | |
| FIRST TR EXCHANGE-TRADED FD | 33739Q408 | FIRST TR ENH NEW | 199 | $12,000 | thousands by filing date | |
| ROYAL CARIBBEAN GROUP COM | V7780T103 | Stock | 100 | $11,000 | thousands by filing date | |
| ALPS ETF TR | 00162Q866 | ALERIAN MLP | 914 | $11,000 | thousands by filing date | |
| PROSHARES TR | 74347B714 | FUND | 279 | $11,000 | thousands by filing date | |
| iShares U.S. Treasury Bond ETF | 46429B267 | SHS | 381 | $10,000 | thousands by filing date | |
| Vanguard Energy ETF | 92204A306 | SHS | 108 | $10,000 | thousands by filing date | |
| ISHARES TR | 464287648 | RUS 2000 GRW ETF | 52 | $9,000 | thousands by filing date | |
| Chevron Corporation | 166764100 | COM | 73 | $8,000 | thousands by filing date | |
| Chubb Limited | H1467J104 | COM | 56 | $8,000 | thousands by filing date | |
| Coca-Cola Company | 191216100 | COM | 175 | $8,000 | thousands by filing date | |
| Duke Energy Corporation | 26441C204 | COM | 100 | $8,000 | thousands by filing date | |
| Marsh & McLennan Companies,Inc. | 571748102 | COM | 103 | $8,000 | thousands by filing date | |
| McDonalds Corporation | 580135101 | COM | 53 | $8,000 | thousands by filing date | |
| Microsoft Corp | 594918104 | COM | 111 | $8,000 | thousands by filing date | |
| NextEra Energy,Inc. | 65339F101 | COM | 57 | $8,000 | thousands by filing date | |
| PepsiCo,Inc. | 713448108 | COM | 68 | $8,000 | thousands by filing date | |
| Pfizer Inc. | 717081103 | COM | 246 | $8,000 | thousands by filing date | |
| Union Pacific Corporation | 907818108 | COM | 69 | $8,000 | thousands by filing date | |
| DIAGEO PLC SPON ADR NEW | 25243Q205 | ADR | 64 | $8,000 | thousands by filing date | |
| NOVARTIS AG SPONSORED ADR | 66987V109 | ADR | 97 | $8,000 | thousands by filing date | |
| BRITISH AMERN TOB PLC SPONSORED ADR | 110448107 | ADR | 111 | $8,000 | thousands by filing date | |
| V F CORP COM | 918204108 | Stock | 136 | $8,000 | thousands by filing date | |
| CRANE CO | 224399105 | COM | 96 | $8,000 | thousands by filing date | |
| PRAXAIR INC | 74005P104 | COM | 59 | $8,000 | thousands by filing date | |
| UNITED STATES NATL GAS FUND | 912318201 | UNIT PAR $0.001 | 1,150 | $8,000 | thousands by filing date | |
| ALPS ETF TR | 00162Q643 | SPROTT GL MINE | 400 | $8,000 | thousands by filing date | |
| Intel Corp | 458140100 | COM | 210 | $7,000 | thousands by filing date | |
| Johnson & Johnson | 478160104 | COM | 56 | $7,000 | thousands by filing date | |
| Texas Instruments Incorporated | 882508104 | COM | 96 | $7,000 | thousands by filing date | |
| Vanguard Total World Stock ETF | 922042742 | SHS | 97 | $7,000 | thousands by filing date | |
| SUNCOR ENERGY INC NEW COM | 867224107 | Stock | 243 | $7,000 | thousands by filing date | |
| ISHARES TR | 464287630 | RUS 2000 VAL ETF | 58 | $7,000 | thousands by filing date | |
| NORDSTROM INC | 655664100 | COM | 155 | $7,000 | thousands by filing date | |
| HCP INC | 40414L109 | COM | 226 | $7,000 | thousands by filing date | |
| ZION OIL & GAS INC | 989696109 | COM | 2,000 | $7,000 | thousands by filing date | |
| POWERSHARES DYNAMIC | 73935X104 | DYNAMIC MKT PT | 84 | $7,000 | thousands by filing date | |
| Intercontinental Exchange,Inc. | 45866F104 | COM | 84 | $6,000 | thousands by filing date | |
| iShares Russell 2000 ETF | 464287655 | SHS | 42 | $6,000 | thousands by filing date | |
| GENERAL ELEC CO | 369604103 | COM | 240 | $6,000 | thousands by filing date | |
| ISHARES TR | 464288281 | JPMORGAN USD EMG | 54 | $6,000 | thousands by filing date | |
| Mkt Vctrs J P Mrgn Em | 92189F494 | COM | 333 | $6,000 | thousands by filing date | |
| Adobe Inc | 00724F101 | COM | 37 | $5,000 | thousands by filing date | |
| Alphabet Inc. Reg. Shares A | 02079K305 | COM | 5 | $5,000 | thousands by filing date | |
| American Tower Corporation | 03027X100 | COM | 39 | $5,000 | thousands by filing date | |
| Comcast Corp | 20030N101 | COM | 127 | $5,000 | thousands by filing date | |
| Danaher Corporation | 235851102 | COM | 60 | $5,000 | thousands by filing date | |
| Honeywell Technologies | 438516106 | COM | 38 | $5,000 | thousands by filing date | |
| iShares S&P 500 Growth ETF | 464287309 | SHS | 40 | $5,000 | thousands by filing date | |
| Mondelez International,Inc. Class A | 609207105 | COM | 109 | $5,000 | thousands by filing date | |
| Starbucks Corporation | 855244109 | COM | 81 | $5,000 | thousands by filing date | |
| Thermo Fisher Scientific Inc. | 883556102 | COM | 29 | $5,000 | thousands by filing date | |
| TJX Companies Inc | 872540109 | COM | 63 | $5,000 | thousands by filing date | |
| Visa Inc | 92826C839 | COM | 54 | $5,000 | thousands by filing date | |
| Walt Disney Co | 254687106 | COM | 49 | $5,000 | thousands by filing date | |
| CENCORA INC COM | 03073E105 | Stock | 57 | $5,000 | thousands by filing date | |
| AMERIPRISE FINL INC COM | 03076C106 | Stock | 38 | $5,000 | thousands by filing date | |
| ECOLAB INC COM | 278865100 | Stock | 39 | $5,000 | thousands by filing date | |
| OSISKO GOLD ROYALTIES LTD | 68827L101 | COM | 400 | $5,000 | thousands by filing date | |
| MYLAN NV | N59465109 | SHS EURO | 130 | $5,000 | thousands by filing date | |
| RED HAT INC | 756577102 | COM | 56 | $5,000 | thousands by filing date | |
| ROCKWELL COLLINS INC | 774341101 | COM | 47 | $5,000 | thousands by filing date | |
| iShares Core S&P Small-Cap ETF | 464287804 | SHS | 54 | $4,000 | thousands by filing date | |
| Lowes Companies,Inc. | 548661107 | COM | 58 | $4,000 | thousands by filing date | |
| WELLTOWER INC COM | 95040Q104 | REIT | 52 | $4,000 | thousands by filing date | |
| OREILLY AUTOMOTIVE INC COM | 67103H107 | Stock | 19 | $4,000 | thousands by filing date | |
| SCHWAB STRATEGIC TR | 808524805 | INTL EQTY ETF | 124 | $4,000 | thousands by filing date | |
| GOLDCORP INC NEW | 380956409 | COM | 300 | $4,000 | thousands by filing date | |
| IJH | 464287507 | COM | 15 | $3,000 | thousands by filing date | |
| Procter & Gamble Co | 742718109 | COM | 35 | $3,000 | thousands by filing date | |
| KIMBERLY-CLARK CORP COM | 494368103 | Stock | 23 | $3,000 | thousands by filing date | |
| WISDOMTREE EUROPE HEDGED EQUITY FUND | 97717X701 | ETF | 41 | $3,000 | thousands by filing date | |
| SPDR SER TR | 78464A870 | S&P BIOTECH | 33 | $3,000 | thousands by filing date | |
| TIME WARNER INC | 887317303 | COM NEW | 26 | $3,000 | thousands by filing date | |
| International Business Machines Corporation | 459200101 | COM | 15 | $2,000 | thousands by filing date | |
| Qualcomm Incorporated | 747525103 | COM | 35 | $2,000 | thousands by filing date | |
| Walmart Inc. | 931142103 | COM | 25 | $2,000 | thousands by filing date | |
| TARGA RES CORP COM | 87612G101 | Stock | 52 | $2,000 | thousands by filing date | |
| ISHARES RUSSELL MID-CAP VALUE ETF | 464287473 | ETF | 22 | $2,000 | thousands by filing date | |
| SPDR SER TR | 78468R721 | NUVEEN BLMBRG MU | 43 | $2,000 | thousands by filing date | |
| SNAP INC | 83304A106 | CL A | 100 | $2,000 | thousands by filing date | |
| GENIE ENERGY LTD | 372284208 | CL B | 212 | $2,000 | thousands by filing date | |
| BARRICK GOLD CORP | 067901108 | COM | 100 | $2,000 | thousands by filing date | |
| STRATASYS LTD | M85548101 | SHS | 100 | $2,000 | thousands by filing date | |
| EVERI HLDGS INC | 30034T103 | COM | 225 | $2,000 | thousands by filing date | |
| DEL TACO RESTAURANTS INC NEW | 245496104 | COM | 139 | $2,000 | thousands by filing date | |
| iShares TIPS Bond ETF | 464287176 | SHS | 5 | $1,000 | thousands by filing date | |
| Schlumberger Limited | 806857108 | COM | 20 | $1,000 | thousands by filing date | |
| Schwab U.S. Large-Cap ETF | 808524201 | SHS | 15 | $1,000 | thousands by filing date | |
| Utilities Select Sector SPDR Fund | 81369Y886 | SHS | 27 | $1,000 | thousands by filing date | |
| WISDOMTREE TR | 97717W760 | INTL SMCAP DIV | 21 | $1,000 | thousands by filing date | |
| HMS HLDGS CORP | 40425J101 | COM | 30 | $1,000 | thousands by filing date | |
| QUALITY CARE PPTYS INC | 747545101 | COM | 44 | $1,000 | thousands by filing date | |
| PENGROWTH ENERGY CORP | 70706P104 | COMMON STOCK-FO | 1,143 | $1,000 | thousands by filing date | |
| ZIX CORP | 98974P100 | COM | 100 | $1,000 | thousands by filing date | |
| BELLICUM PHARMACEUTICALS INC | 079481107 | COM | 70 | $1,000 | thousands by filing date | |
| ACTINIUM PHARMACEUTICALS INC | 00507W107 | COM | 500 | $1,000 | thousands by filing date | |
| EPR PPTYS COM SH BEN INT | 26884U109 | REIT | 5 | $0 | thousands by filing date | Value filed as zero, left out of ratios. |
| EQT CORP COM | 26884L109 | Stock | 0 | $0 | thousands by filing date | Value filed as zero, left out of ratios.Amount filed as zero, left out of ratios. |
| AMERICAN INTL GROUP INC COM NEW | 026874784 | Stock | 2 | $0 | thousands by filing date | Value filed as zero, left out of ratios. |
| CHEMOURS CO COM | 163851108 | Stock | 7 | $0 | thousands by filing date | Value filed as zero, left out of ratios. |
| AMERICAN INTL GROUP INC | 026874156 | *W EXP 01/19/202 | 1 | $0 | thousands by filing date | Value filed as zero, left out of ratios. |
| TIME INC NEW | 887228104 | COM | 15 | $0 | thousands by filing date | Value filed as zero, left out of ratios. |
Amendment chain
| Filing | Role | Filed | Accepted | Ingested |
|---|---|---|---|---|
| 13F-HR 0001214659-17-004994 | this filing | 2017-08-11 | acceptance time not in the bulk data set |