We show jobs from every employer career page, job board and news source we can find.
Salary
$750-1500
Location
San Jose, CA, United States
Posted on
Aug 18, 2020
Profile
Couple owned very small business needs a EXCEL VBA macro consultant
My extensive trading of Vanguard Mutual funds in 3 Vanguard accounts requires an automated VBA enabled macro inside EXCEL 2020 to grab Performance data from a Morningstar.com. website and place in existing extensive, sophistication huge Spreadsheet developed & maintained by me. Current manual method of click, copy paste takes 45-1hr per session for 84 funds on my current Watch-list. Example Morningstar fund URL:
[login to view URL]
I will supply all 84 current URLs. Desired data exists in Total Performance table (once per year need) & in Trailing Performance table (need 100 times per yr.). Each fund existence must be checked for viability as Vanguard drops about 1 fund per year. Hence I must be easily able to modify the input list. Morningstar is oft late with data readiness, so, if possible, macro needs to be able 2 run automatically on a timer after I go to bed. I have written extensive LOTUS 123 macros from decades ago, so understand concept, but @ age 74, do not desire to delve into extensive idiosyncrasies of EXCEL VBA macros. Consultant must be able to prove their macro works for 1 fund, as I have been told this is tediously laden with difficulties, but have watched YouTube videos of folks showing how to do it (if one extensively knows VB). Definitely hugely desire to work with N. CA / Silicon Valley based consultant. My project budget is tight (retired individual trader), but my desire for a solution is high.
Skills:
Visual Basic
, Visual Basic for Apps
, Excel
, Excel Macros
, Excel VBA
, Local Job
About the Employer:
( 0 reviews )
San Jose, United States
Project ID:
#27003357
Offer to work on this job now! Bidding closes in 6 days
Open - 6 days left
Your bid for this job
USD
Your email address
Bid on this job
Set your budget and timeframe
Outline your proposal
Get paid for your work
Its free to sign up and bid on jobs
6 freelancers are bidding on average $1192 for this job
cgullapalli
(948 Reviews)
8.1
P0L
(417 Reviews)
7.7
elqueabandona
(286 Reviews)
7.2
shirleyk915
Hi Dimpletes. I am very skillful in VBA and Excel Macro. I am ready for your project now
I am very interested in your project.
I am sure I can complete your project.
Hope to discuss more details with you.
Thank you!
$2000 USD
in 12 days
(1 Review)
3.8
twinklekumar
Excel and Macro are key strengths as I have worked on good amount of projects and helped my clients. Looking for this next challenge and to learn more about funds. Thanks
$1125 USD
in 7 days
(8 Reviews)
2.8
amanrangan
Hi there, I was messaged about this opportunity through Freelancer and I would love to chat more about it. I just finished my MBA from the University of Michigan and have been actively day trading through a combinatio
More
$1125 USD
in 7 days
(0 Reviews)
0.0
Offer to work on this job now! Bidding closes in 6 days
Open - 6 days left
Your bid for this job
USD
Your email address
Bid on this job
Set your budget and timeframe
Outline your proposal
Get paid for your work
Its free to sign up and bid on jobs
Post a project like this
Next Job >
Similar jobs
VBA for updating excel sheets ($10-30 USD)
Need to create a loop in VBA that searches for a product id and pastes the rows associated with it ($2-8 USD / hour)
Convert Descriptions in Excel to html -- 2 ($30-250 USD)
Accountant ($30-250 USD)
SKILLED PROJECT FOR FRESHER. ($8-15 USD / hour)
Macro Guru.. ($10-50 AUD)
Move/host, configure 2 APKs( there are 2 mobile apps available) into Google play store (₹600-1500 INR)
Excel & Word Maestro ($25-50 USD / hour)
Macro expert needed .... ($20-100 NZD)
dataentry (₹100-400 INR / hour)
Move data from 120 Excel files into one file. ($15-25 USD / hour)
Receive documents through courier by international mail and depatch via local port / courier (b) (Kyiv, Ukraine $10-30 USD)
English and Hindi typing (₹100-400 INR / hour)
pos system ($10-30 USD)
VB.net expert required. -- 2 ($10-100 AUD)
Couple owned very small business needs a EXCEL VBA macro consultant (San Jose, United States $750-1500 USD)
Building VBA macros in excel (₹600-1500 INR)
Sahil ALL ABOUT (₹100-400 INR / hour)
Macro Guru.. -- 2 ($20-50 NZD)
Macro Guru.. -- 2 ($20-50 NZD)
Need to hire a freelancer for a job?
Its free to sign up, type in what you need & receive free quotes in seconds
Enter your project description here
Post a Project
English - US (International)
Help & Support
Freelancer
Categories
Projects
Contests
Freelancers
Enterprise
Preferred Freelancer Program
Project Management
Local Jobs
Showcase
API for Developers
About
About us
How it Works
Security
Investor
Sitemap
Quotes
News
Terms
Privacy Policy
Terms and Conditions
Copyright Policy
Code of Conduct
Fees and Charges
Apps
Registered Users
Total Jobs Posted
Freelancer ® is a registered Trademark of **MEMBERS ONLY**SIGN UP NOW***. (ACN 141 959 042)
Copyright © 2020 **MEMBERS ONLY**SIGN UP NOW***. (ACN 141 959 042)
×
Welcome,
Processing …
Welcome
Link to existing Freelancer account
The email address
is already associated with a Freelancer account.
Enter your password below to link accounts:
Username:
Password:
Link Accounts
Close
I am a new user
I am a returning user
Link your account to a new Freelancer account
Email address
Email address
Username
Valid username
I am looking to
Hire
Work
Create Account
Link to your existing Freelancer account
Username or Email
Password
I forgot my password
Link Accounts
Company info
Sign Up Now - WashingtondcCrossing.com
Recruiter job
90 Day Old Job